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

Exporting To Excel From Access 2000 Syntax Question

P: n/a
I am having trouble figuring out the correct syntax to export to Excel 2000 and
having the name of the newly created Excel spreadsheet based on a value from an
open form. I am not exporting to existing spreadsheet, but creating a new one
each time I export. I am doing this using a "TransferSpreadsheet" macro. In
the macro the "File Name" would be:

c:\data\export\ ? .XLS

Where the ? represents the syntax I can't figure out. The name for the newly
created spreadsheet that I want to use is found at the following open form:

Forms![EnterSubjectInfoFrm]![SubjectID]

Any help would be very much appreciated.

Nick
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.