Saving Content of Embedded Excel Control on Form

L

LT

Hi,

I have a Microsoft Office Spreadsheet 11.0 Object on my Access form and I
can't seem to save the contents. I have the following code in place:

Code: 
xlsReceiptContainer.ActiveWorkbook.Worksheets("ETSReceipt").SaveAs
uploadPath & "\" & fileName

I've got to be close. Everything clicks along and then on the above line I
get:

"Run-time error '438': Object doesn't support this property or method"

I've checked other VBA samples I have found but maybe these containers don't
allow us to save the contents?

Any ideas would be greatly appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 2042 in Excel ActiveX Control 2
Getting Excel Range Data and Saving as a String 1
Display contents of Tag property for all (closed) forms in the db 2
Filter main form to records with no related records in subform,maintain updateable recordset 4
Syntax for saving an exported Excel file as csv 11
Create and save embedded bitmap image 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
How to save embedded message objects in a Word doc using VBA 1

Top