URGENT - have code that only works for 32 bit-need 64 too!

[Muzza86]

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.

[romperstomper]

If it will only be run on 2010 or later, you can just use:

Please Login or Register  to view this content.

If your code stores the return value in a variable, make sure to declare that variable as LongPtr not Long.

[Muzza86]

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>>

[romperstomper]

Yes, it is.

[Muzza86]

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.

[Muzza86]

if you can sort this, I would APPRECIATE it a lot

[Muzza86]

sorry didn edit code the way you told me.. hang on

[Muzza86]

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.

[Muzza86]

any ideas?????

[romperstomper]

What errors?

[Muzza86]

just saying there are problems with strings etc cant be single or something

[romperstomper]

What is the actual error message?

[Muzza86]

bear with me.

[Muzza86]

this is the error now?

[Marc L]

When transposing, why cut some instruction from original working 32 bits version ?‼

Just read your original post and see what is lacking …

[romperstomper]

OK - you need to add the word 'Private' at the start of the 'Declare Function ...' line:

Please Login or Register  to view this content.

because it's in a worksheet code module.

[Marc L]

Yes, the answer is in the error message …

[Muzza86]

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

[Muzza86]

did I say you guys were legends? if not I am now. thanks it works now! finally!