I got a file for converting all mass xlsm to xlsx file.
Convert between Excel file formats macro option formats (.XLS, .XLSX, .XLSM) with/with.
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option but getting an error message at it needs to an update for 64 bit coding.
Can anyone assists or have another solution
my goal is to convert all xslm to xlsx
Please Login or Register to view this content.
A little reading for the evening and part of the answer here:
http://www.rondebruin.nl/win/s5/win001.htm
The rest probably in the forum ...
Basically your Excel is the 64 bit version and that code is using 32bit API's. You need to reference the 64bit apis and likely change some of your variables to account for it. Its also possible to right logic that checks if the version of Excel runing the macro is 32/64 bit and reference the appropriate API based on it (bit more code this way, but avoids having issues moving between 32/64 bit).
EDIT: Also probably the most well written error dialog Microsoft has ever made. It essentially tells you what I just did.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks