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
[/CODE]
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!
|
|