Open Files
Hello,
I have a ton of files that need to be opened and printed. I have a list of
their names in an excel spread sheet and I am wondering if it is possible to
write a program that would open up each of those files and/or print them off.
All the files are tif files.
I have tried:
Open "C:\Documents and Settings\JSena\My Documents\ECOacksheet1" For Input
Access Read Lock Read As #1 'if I run this twice it gives me an error
because the file is already opened, but I can not see it as opened.
also tried:
fileToOpen = Application _
.GetOpenFilename()
If fileToOpen < False Then
MsgBox "Open " & fileToOpen
End If 'but obviously this does not actually open the file, and don't know
how to make it.
also tried:
Application.FindFile 'and this seems like it would work if only I could
enter aruguments so that it could find the files on its own as long as I gave
it the paths.
Thank you very much for any help with this,
Jordan
|