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? |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com