Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
emailing files from excel, the files will not go until I open up . | New Users to Excel | |||
how do I toggle between 2 open excel files and leave both open | Excel Discussion (Misc queries) | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
Can not open excel files without open application | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |