Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

Hi, may i know is there any setting has to be enabled when i run my 2007 excel file (hello.xls) on 2010 excel?

The macro in this file can run smoothly when i open it with microsoft excel 2007. Yet, when i tried to open my file with microsoft excel 2010, an error msg state that my file is not being supported my microsoft excel 2010.

I have a function

Please Login or Register  to view this content.

in my macro.. i wonder is it becoz of this my file is not being supported.. but i have google that excel 2010 does support 32 and 64.

Please advise... Thank u very much

Originally Posted by dominicb

Good morning Orange.CL

Microsoft introduce a sneaky VBA update when Excel 2010 was introduced, the VBA version jumping from 6.5 to 7.0. However not much has changed.

What has changed is the way API's are now dealt with. There doesn't seem to be that much discussion about this on the forums at the moment, but John Walkenbach posted this on his blog about the subject. That might give you a shove in the right direction.

I think your best bet in the first instance would be to get two versions, one that works on XL2007 and one that works on XL2010. If you really need one version that works in both, then you have a starting point, in that you know what works.

HTH

DominicB

Thank u for your sharing Dominic. may i know since there is VBA has been updated, most of the macro can still being executed, right?

Originally Posted by romperstomper

Are you using 64bit Excel 2010 or 32bit?

Hi Guru, i m using 64Bit.. why? that gives effect on the system time display function since Lib 32 is being use? I tried to search for "LIB 32" in the HELP... but i didn't get any result from there... I wish to understand why (0,0,100, ..) is passed to the function .. why must those value.... can advise on this?

Thanks

thanks for testing..

weird then... then must be somewhere wrong in my orginal code...

hmmmm thanks again... i will check it out again..

may i know that u run my attached file or u copy the code and saved it with 2010?