I have a declare function that only seems to work with 64 bit excel and i want it to work with both 32 and 64. I was thinking of using an "IF" statement to determine which function to run. However, I don't know how to determine if its 32 or 64.
Below is the Declare Function and the code that runs on Userform_Initialize:
Please Login or Register to view this content.
Try this
=INFO("OSVERSION")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You may use conditional compilation:
Please Login or Register to view this content.
Last edited by Izandol; 03-05-2014 at 01:07 PM.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Perhaps this macro written by Richard Schollar?
AlfPlease Login or Register to view this content.
Thank you all! I ended up using Izandol's code and it works great.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks