Thread: Open Files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default 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