Hi All,
I am working with Access. I need a few lines to add to a script to open a workbook and save it again in *.xls format. It is currently in *.xlsx format and my macro cannot open it for some reason.
The file is declared already as a full path as "excelPath" e.g. C:/Desktop/File.xlsx
Can anyone assist?
Thanks
dvent
Hello dvent,
Here is how to save your Active Workbook in Excel 2007 format in a format earlier versions of Excel can use (.xls).
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I think you want to skip the extension, or make it xls:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks