View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Barnes Bob Barnes is offline
external usenet poster
 
Posts: 134
Default Make a Snapshot File from an Excel Worksheet

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