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

Top