is it just as simple as changing it to 64? in the code... it cant be im assuming .
this is the part of the code which states 32 bit
Please Login or Register to view this content.
is it just as simple as changing it to 64? in the code... it cant be im assuming .
this is the part of the code which states 32 bit
Please Login or Register to view this content.
If it will only be run on 2010 or later, you can just use:
If your code stores the return value in a variable, make sure to declare that variable as LongPtr not Long.Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
I really am lost with this code... to be blunt. is that ALL I have to change in that code to allow a person using 64 bit to use the spreadsheet>>
Yes, it is.
I tried but when I open it on 64 bit it still comes up with errors. and says something like "I need to add a ptrsafe attribute
this is full code..
Please Login or Register to view this content.
if you can sort this, I would APPRECIATE it a lot
sorry didn edit code the way you told me.. hang on
receiving errors about the rest of the code now - e.g the string parameters etc..
this is full code after edit...
I can now open spreadsheet but the links to files don't work
Please Login or Register to view this content.
any ideas?????
What errors?
just saying there are problems with strings etc cant be single or something
What is the actual error message?
bear with me.
this is the error now?
When transposing, why cut some instruction from original working 32 bits version ?‼
Just read your original post and see what is lacking …
OK - you need to add the word 'Private' at the start of the 'Declare Function ...' line:
because it's in a worksheet code module.Please Login or Register to view this content.
Yes, the answer is in the error message …
I haven't cut any code. I know it looks that way from pic.. but I haven't. its all there. until I try to use a link and then that pops up and looks like a big chunk of the code is gone but it hasnt
did I say you guys were legends? if not I am now. thanks it works now! finally!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks