| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you take a 'snapshot' of an excel page (including toolbar) | Excel Discussion (Misc queries) | |||
| Snapshot function, 2003 to 2007 | Excel Worksheet Functions | |||
| How to make Lable in Excel from a xls file | Excel Discussion (Misc queries) | |||
| in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
| snapshot viewer print protection error | Excel Discussion (Misc queries) | |||
Linear Mode
