+ Reply to Thread
Results 1 to 14 of 14

Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

  1. #1
    Registered User
    Join Date
    06-20-2010
    Location
    Mal
    MS-Off Ver
    Excel 2007
    Posts
    25

    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

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    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
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    Are you using 64bit Excel 2010 or 32bit?
    Remember what the dormouse said
    Feed your head

  4. #4
    Registered User
    Join Date
    06-20-2010
    Location
    Mal
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    Quote Originally Posted by dominicb View Post
    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?

  5. #5
    Registered User
    Join Date
    06-20-2010
    Location
    Mal
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    Quote Originally Posted by romperstomper View Post
    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

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    If you are using 64bit then the APIs have changed, so you need to review the link Dominic posted. It will explain what the arguments are.

  7. #7
    Registered User
    Join Date
    06-20-2010
    Location
    Mal
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    API changed? Does it give effect on RGB display or the program that involves syntax like below?

    Please Login or Register  to view this content.
    Btw, i have simple test version for 2010.

    Please Login or Register  to view this content.
    By refering to the result of my macro when i run it with 2010,
    I noticed that my excel file can only display the RED color... those cells tat within the range remained as white....

    Can advise or elaborate more????

    Many thanks!!!!
    Attached Files Attached Files
    Last edited by Orange.CL; 06-29-2010 at 03:24 AM.

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    I've tested your file in 2010 and it works the same as in 2007.

  9. #9
    Registered User
    Join Date
    06-20-2010
    Location
    Mal
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    thanks for testing..

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

  10. #10
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    Code runs in 2007 & 2010 as expected for me as well
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  11. #11
    Registered User
    Join Date
    06-20-2010
    Location
    Mal
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

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

  12. #12
    Registered User
    Join Date
    06-20-2010
    Location
    Mal
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

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

  13. #13
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    I opened & used your file in 2007 & 2010

  14. #14
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007

    I too used your file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1