ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open File (https://www.excelbanter.com/excel-programming/310066-open-file.html)

Kevin

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