Thread: Open File
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 134
Default 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?