Exporting SNP Format in a Macro?

  • Thread starter Thread starter FlaSquid
  • Start date Start date
F

FlaSquid

Is it possible to export a report in SNP (Snapshot) format using a
Macro?

I figured how to email the SNP using SendObject, but can't figure how
to export to a file.

Runcommand will open the Export Dialog Box but can't figure how to
pass it a paramter to save as SNP.

BONUS QUESTION: how to specify a unique filename, maybe using
time/date?

Thanks < Advance

Fla Squid
 
Figured out my own question: Output To.

I have the same set of reports that I would like to run against
mutliple sets of client data. Would still love to learn how to
automatically name the Output File.

Something like this?

Object Type: Report
Object Name: Client List
Output Format: Snapshot Format
Output File: "C:\My Documents\"Client List" &
"DLookUp("ClientName","Customers","CustID=" & 1)""

So the resulting output file would be named: Client List John
Jones.snp

ManyThanks < Advance,

Fla Squid/Caveman
 
Back
Top