Changing File Extensions.
I am editing some VB code in my excel workbook that opens other excel files. The problem is that there are many other users of these files and some have Excel 2003 and some have Excel 2007 and some have Excel 2010. When the code opens the file filename.xls. It can't find the file when the newer versions of excel have saved the file and it is now filename.xlsm or filename.xlsx. Do I have to use file extensions in the code when opening and manipulating the file?
you should use the proper file extension in your VBA code. If you the have filename and the folder, you could use the Dir command within VBA to get the extension.
You could also use a Dialog within VBA to pick the file (and its extension).
Gary's Student
The file extension changes depending on who was the last one to save the file? Is there some simple easy way to have it open the file with either file extension? The macros that are having this problem run in different versions of excel and the files in question run in different versions of excel. I am a novice programmer in VB so please make explanation easy and give me an example. Thanks!
Here is an example.
The scenario is that we know the folder (C:\TestFolder) and we know the workbook name (Book2), but we don't know the extension (.xls or .xlsx or .xlsm)
This macro:
- searches the folder
- finds a file with the correct name
- sets a variable to the complete name (name + extension)
- opens the file
Please Login or Register to view this content.
I think this will work. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks