Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Below is the first part of a macro that works 'almost' perfectly.
In my macro, I don't want to use the 'full path' to the file, because I move the set of files to different directories at times. The macro works well on my Macintosh without a full path. The macro will open the "testfile.xls" when called, if the file has been perviously opened once, via the 'File' menu in Excel. However, opening the testfile.xls via Windows Explorer does not work for the macro. I'd like to be able to either not have to manually open the file, or at least be able to open the file in Windows Explorer without using the File menu. The file can then be closed and the macro will open the file if I haven't quit and restarted Excel, and if the file was opened via the File menu. The "testfile.xls" is in the same directory as the Excel file that is running the macro. First part of macro here... Sub QuoteCopy_Tester() Application.ScreenUpdating = False Workbooks.Open FileName:="testfile.xls" Range("QuoteArea").Select ....macro continues. Thanks for the help. Sorry if I've talked in circles. -Dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Full path possible to be seen? | New Users to Excel | |||
Indirect does not recognize full server path? | Excel Worksheet Functions | |||
full UNC path in footer | Excel Discussion (Misc queries) | |||
full path of excel file | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) |