How do I batch print 'snp' files?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
Back
Top