acspreadsheettypeexcel4 export error

[TrollBro]

I have users who for whatever reason need the excel4 formated file, but in an Access2K or 2003 database the acSpreadsheetTypeExcel4 generates an error. It works fine in an access97 database, but not the 2K or 2003 databases. My code is below. changing to excel7, 8, 9, 5 all work without an error. Is there something I need to do differently with this?

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel4, stDocName, SaveASstr, True

Thanks

 

[abaldwin]

I dont believe that 2k or 2003 access support the excel4 any longer. Is there a reason you can not use 5 or better?


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[TrollBro]

Thanks Andy - there was a user need for an xls4 version, but I can go xls8 and if they need the xls4 version they can convert it manually. The 97.mde I converted to A2k is really doing some strange things and I thought it might be related to this issue - but I'm beginning to think its a separate issue.

Thanks

 

[abaldwin]

Your welcome.

Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[PHV]

Another way is to export a .csv file that ANY version of Excel can read.