32 bit and 64 bit compatability

**manofcheese** · 06-04-2014, 11:12 AM

So I am working on a project for my father-in-law's business and I just sent what I have right now to him to test it and he came up with an error saying that it needs to be updated to function with 64bit. I have put over 40 hours into this worksheet and I don't want to lose it all. What kind of changes would I need to make to make it compatible?

Here is the spreadsheet if that helps. (Some of my macros aren't complete yet either so just ignore those ones.) Thanks for any help you can provide.
Inventory Management Accounting.xlsm

**Kyle123** · 06-04-2014, 11:18 AM

I think that only your APIs will need updating, take a look here http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

**manofcheese** · 06-04-2014, 11:20 AM

As far as I know I didn't use any API's. But I could be wrong. I am pretty new to VBA.

**Kyle123** · 06-04-2014, 11:23 AM

You are, that's why I said it

**manofcheese** · 06-04-2014, 11:26 AM

Could you give me an example of some API's that I used in my attached spreadsheet? I really don't know what they are and I also don't know how to change them.

**Kyle123** · 06-04-2014, 11:28 AM

Please Login or Register  to view this content.

The link I posted explains how to deal with 64-bit compatibility

**manofcheese** · 06-04-2014, 11:30 AM

So are API's basically the private sub codes that I use for my buttons?

**Norie** · 06-04-2014, 11:32 AM

Are you actually using the code in the NoTitle module?

I can't see it being called anywhere.

**manofcheese** · 06-04-2014, 11:34 AM

Oh yeah. I forgot about that one. I am not currently using it but I plan to use it once I get more done. So if I got rid of this code or fixed this part would it be compatible?

**Norie** · 06-04-2014, 11:44 AM

It'd probably be a better idea to keep it and change it to be compatible.

**manofcheese** · 06-05-2014, 12:16 AM

So on the link you gave me it has this code. From what I understand, if I put this at the beginning of my macros then it should solve it. Is that correct?

Please Login or Register  to view this content.

**romperstomper** · 06-05-2014, 02:07 AM

No - that's an example of how to make an API call compatible (its not an API function you are using). You need to apply the same principle to the actual function declarations you are using.

**manofcheese** · 06-05-2014, 09:30 AM

So if I understand correctly my code would be like this?

Please Login or Register  to view this content.

Or something like that?

**romperstomper** · 06-09-2014, 06:57 AM

Not quite. Your module would become something like this:

Please Login or Register  to view this content.

**manofcheese** · 06-09-2014, 07:09 PM

Thanks for the code. I put it in my spreadsheet and we will see how it works for my brother in law. I'll let you know how it goes as soon as I hear back from him.

32 bit and 64 bit compatability

LinkBack

Thread Tools

Rate This Thread

Display

32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Re: 32 bit and 64 bit compatability

Thread Information

Users Browsing this Thread

Similar Threads

Compatability Mode

[SOLVED] Compatability issues

Backward compatability

[SOLVED] VB backwards compatability

[SOLVED] PIA compatability

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions