I have an excel file which have macros , and in its vb code the file is saved as .xltm file but i want to change it to some other format which would containd the macros .
my code behind the save and close button is :
PLease help me finding a way in which i can save this .xltm file as another file(any format ) which should contains all the macros and data which this file would have.Thanks
Please Login or Register to view this content.
Hi, hahmed,
maybe use the macro enabled format xlsm for saving:
You may also try using xlsb with FileFormat 50.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks