I am trying to print all of the snp files in a folder with either a macro or
in VB/VBA. Unfortunately I am using Office 2000.
Can anyone help, I'm really lost as how to go about this.
This may be worth a shot:
Obtain your file names by repeatedly calling the dir() function
Something like:
strFileName = Dir("*.snp")
while strfilename <> ""
'Do Stuff
strFileName = dir()
wend
Within the loop, use the Shell() function to open the snapshot viewer
for the file.
You may have success by changing the default action of .snp files
through windows (Tools -> Folder options ->File types -> Advanced in
winXP).
On my system, the shell command looks like this:
shell "c:\program files\snapshot viewer\snapview.exe " & strFileName &
" -p"
The annoying part is that "-p" prompts for user intervention (which
printer, what properties, etc.) and is not good for batching. Try
changing that default action. There COULD be another switch I don't
know about too.
-Kris
