Hi
I am looking for a macro that will immediately prompt to open a new file when the Excel file with this macro embedded in it is opened (without having to initialize the macro). thanks!!
Last edited by jhmayor03; 02-03-2012 at 09:00 AM.
Do you mean open a new file (create a brand new blank workbook) or open another file, the name and location of which are known, or open another file in an as yet unknown location (ie requiring user input)?
Last edited by swoop99; 02-02-2012 at 03:07 PM.
open a new file requiring user input. I want it to open data from another file (possibly on a flash drive or other). I will then use other macros to further edit the data. thanks
Last edited by jhmayor03; 02-02-2012 at 04:24 PM.
Ok, try:
Dim path as string path = Application.GetOpenFilename(fileFilter:="(*.xls), *.xls") Workbooks.Open (path)
works perfectly! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks