Replies

I do not use Option Explicit. I’m using Excel from Office 2010 and the file was created in Office 2007 and it is an XLSM.
I moved the forms to a new file and everything works fine now it just took half a day to get it all moved.

I checked all the references and they matched up.

I’m finding that if I create a new file it will work fine. Just will not work in existing file with code already in it.

It is not checked. I made sure of that first.

It’s making me decalre every variable in the project! Why?

No variables are declared… It doesn’t really matter what variable I use I get the same error. This worked perfectly in Office 2003.

FIXED IT!!! This one works perfectly! just had to change some things around and used xlsb extension.

THANK YOU!!!!!

DoCmd.TransferSpreadsheet acQuery, acSpreadsheetTypeExcel12, a, “C:DATA” & qdftemp.Name & “.xlsb”, False, “”

I’m using Excel 2007. When I use the xlsx extension the file will not open. When I rename the exported file to an xls extension it will open.

Yes I’ve been stepping through and I’ve gotten it to run by changing the line to
DoCmd.OutputTo acOutputQuery, a, acSpreadsheetTypeExcel12, “C:DATA” & qdftemp.Name & “.xls”
When I try the extension of “xlsx” I can’t open the file.

When I try the query with +65,000 records I still get an error saying it can’t export that many lines. It will save the file but stops at 65,535 lines.
The error message says I’ve selected more records than can be placed on the clipboard.

It errored out with the message that Object was missing

Hate to ask but could you edit my code to use the acSpreadsheetTypeExcel12 and a version with the TransferSpreadsheet methods.

This has happened on multiple macros and never seems to stop at the same place. Also these are new computers supplied by employer so I’ll check to make sure with help desk there are no updates required.

I found the answer. I was trying to save the chart from a chart sheet.

THANKS much for your checking!

Thank you !!!

THANK YOU!!! Another question… I had this working 2 weeks ago by adding this reference. Is there something I need to do to the module or the database prior to closing to it so that it’s preserved?

THANK YOU!!! Another question… I had this working 2 weeks ago by adding this reference. Is there something I need to do to the module or the database prior to closing to it so that it’s preserved?