Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Little Rock, Arkansas, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgrade from Excel 97 to 2k, Error 429 (MS Access 97, Excell 97 and 2k)

    I have a Database that was created using Office 97. Based on the user's selections it will compile some data and export to Excel.
    In one instance I use code and a template file. Everything works fine, except the main user of this function just got a new PC, it has Access 97 but Excel 2000 installed. For the export to the template I get a "Error occurred in Module1 OutputReport click. Error is 429 ActiveX component can't create object" message, debug highlights this line in Module1, "Set xl = CreateObject(gsExcel)".

    I have another instance where I use a the OutputTo action in a macro, when I try to run this, I get "The ... system can't save the output data to the file you've selected, the file may be open... check to make sure the template file exists ... check to make sure you have enough free disk space." The file isn't open, I'm not using a template file, and this is a new PC with over 3GB of free disk space. Based on other posts I have checked and Dao350.dll is present and appears to be installed properly. Again, this application runs just fine on every other PC in the building, all the references are the same in both Access and Excel, the only difference I know of is the version of Excel.

    Any help would be Greately appreciated.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade from Excel 97 to 2k, Error 429 (MS Access 97, Excell 97 and 2k

    >>>>>>>>>all the references are the same in both Access and Excel, the only difference I know of is the version of Excel.<<<<<<<<<

    I believe the reference to Excel should be different. Have you tried changing the reference from:
    Microsoft Excel 5.0 Object Library
    To:
    Microsoft Excel 9.0 Object Library?

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Upgrade from Excel 97 to 2k, Error 429 (MS Access 97, Excell 97 and 2k

    You may want to take a look at one of the MSKB articles cited below to see if they provide any clues for the errors you are encountering:

    INFO: Troubleshooting Error 429 When Automating Office Applications

    INFO: GetObject and CreateObject Behavior of Office Automation Servers

    ACC2000: Error Message Using OutputTo to Output a Report to Another Format

    HTH

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Upgrade from Excel 97 to 2k, Error 429 (MS Access 97, Excell 97 and 2k

    I suggest you read the articles Mark posted. One of the big problems you're facing is the fact that Access 97 uses VBA 5 and Excel 2000 uses VBA 6. That means that the Excel object reference literally cannot be the same on the machine with Excel 2000 installed. The library names changed between versions.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Apr 2002
    Location
    Little Rock, Arkansas, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade from Excel 97 to 2k, Error 429 (MS Access 97, Excell 97 and 2k

    Thanks everybody. Based on your suggestions, I got rid of the Error 429, the first line of my module had "Excel.Application.8". I changed it to "Excel.Application" and the Error 429 went away, it still runs on the Excel 97 computers. I checked the references, and in Excel97 I have MS Excel 8.0 Object Library and MS Office 8.0 Object Library checked, in Excel 2000 it is the same except version 9.0 of each.

    The OutputTo action still fails. I read the article Mark suggested, and it doesn't seem to apply, the only fix they suggest is "Supply a valid file name" which I have done. Should I convert this macro to VBA code and try again or will that make any difference?

  6. #6
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Upgrade from Excel 97 to 2k, Error 429 (MS Access 97, Excell 97 and 2k

    If you are using macro I'd recommend "Save As" VBA code, then if you still get OutputTo error, post the code, it might be helpful in finding out cause for error. It's hard to "debug" a macro....

Posting Permissions

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