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?
|