By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

TransferSpreadsheet acExport fails when xls sheet does not exist

P: n/a
Hi All,
In Access97 I'm using a TransferSpreadsheet acExport in vba code and
it errors when the spreadsheet I'm exporting does not exist. If I
create a empty spreadsheet with the name I use in the
TransferSpreadsheet statement it works.
I don't understand whats going on here, why won't TransferSpreadsheet
create the spreadsheet if did does not exist?
thanks
bobh.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bob,

I no longer have Access 97 on my system.

However, I assume you've checked the "TransferSpreadSheet Action"
topic in the Access 97 VBA help system. If it's the same as in Access
2000, then it'll say that the "TransferSpreadSheet Method" will create
the Excel file if it doesn't exist. (You might also double-check the
Microsoft knowledgebase online.)

My guess is that the method should create the file, but there is
something else preventing the file's creation.

So, what else could prevent the file's creation? Is it a file system
issue?

If this continues to be a problem you can't resolve and you need a
quick solution, perhaps use the DoCmd.OutputTo method.

Regards
Geoff

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.