Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open File
I am trying to open an existing excel file. I have the
following code: fToOpen = Application.GetOpenFilename("Excel Files (*.xls), *.xls") Unload MenuForm Workbooks.Open fileName:=fToOpen This code runs from a user input form ("MenuForm")which is closed when the code is executed. This works and the file is opened, but... When the file opens, the file name is modified by adding a number to the end. If my original file name is "Test.xls", the modified file name is "Test1.xls". Any reason from the code shown, this should happen? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |