Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dropdown toolbar with IF statements - Excel VBA
The following code does the following: Users selects/opens a file-> data from the selected file gets copied to the data in the source worksheet/file Sub test() Dim file_open As Variant Dim WB As Workbook file_open = Application.GetOpenFilename("Excel Files (*.xls), *.xls") Set WB =...- kalalala
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Runtime error 424 - Object required
Hello I am getting the Runtime 424 error with the code below. I am a newbie and have looked at help but cannot understand how I can modify the code below to give me what I wana do. Purpose of the code: User selects a file->Open the file->copy over A10 to A10 of the source file Thanks in...- kalalala
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
