Search results

Oh, and the failure was that I was trying to overwrite cells with equations in them. Living and learning.

<<sighs with embarrassment>> I had the macro posting the same table to two different spreadsheets by design. I was wracking my brain to find the problem with the first export. It was the second one, 6 lines later, that failed. When I did a Step By Step, it became obvious. Should have tried...

Nope, hold the phone, I found it! Thanks for looking, everybody!

Well, it was worth a shot, but it didn't seem to help. The irony is this: It appears that all the data is transferred, but since it throws an error it interrupts the macro, and won't continue. Still looking.....

I have an Access 2007 macro that has run fine for years. Now it balks and I get a "Cannot delete spreadsheet cells. (Error 3435)" message during export to Excel. I have looked over the posts, I don't have any formulas in these cells, the page is not protected or hidden, etc. I am exporting...

Thanks for taking the time, you are making this easier!

Thank you! Since the Auto Fill in VBA showed them, I thought I had to use them. I appreciate your time!

Well, I appear to have signed off too soon. Now I get an Error 2498, wrong data type when I attempt to transfer the file to an Excel spreadsheet. The code is: Option Compare Database Option Explicit Function Macro1() On Error GoTo Macro1_Err Dim strTOP1 As String Dim dbs As Database Dim...

Gentlemen, thank you, all your suggestions were spot on. The variable updates, works fine, now I just have to get the transfer command and loop to work! Thanks for your help.

This is probably so simple for someone out there, but I have spent a lot of time on it. I am trying to set a variable to the value of the single field in a one line table. I get an Object Required message. I have reviewed many posts, etc., but can't figure out what I am doing wrong. Any help...