Make a Snapshot File from an Excel Worksheet

B

Bob Barnes

Asked this in Access Newsgroup = No replies

"M" below will identify a .snp hopefully
produced from an existing Worksheet
in an Excel file.

The Excel File and Worksheet name will stay constant
w/ updated Daily information.

IE.."M" (below) = "C:\BobDev\DailyRep.snp"

Can I use this to...
DoCmd.OutputTo acOutputReport, "LNEmail", _
"Snapshot Format", M, False

...change the [acOutputReport, "LNEmail"]
to identify the Excel File's (above) Worksheet?

TIA - Bob
 

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

DoCmd.Output An Excel Worksheet 0
Snapshot Files 2
Save A Worksheet as a Snapshot File 0
Saving to SnapShot / Excel etc. (A97) 3
Access Automation 3
How to make Subdirectory using OutputTo for Snapshot files from recordset 2
Importing data from an application to an Excel worksheet 1
Saving an Excel File from Access Automation... 3

Top