| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file and print sheets based on data in cell
Hi everyone. In column A I have the full path of a file. In columns B
through AZ I have sheet names within that file. How can I code excel to open the file in A1, print the sheets in B1 through AZ1, then close the file, then move to the next row and do the same until all rows containing data in column A have been looped though? Thank you in advance. PS - Some files may only have 2 sheets to be printed, so D1 through AZ1 may be blank. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Every file I open has print area set to one page per cell | Excel Discussion (Misc queries) | |||
| When I open a file in excel, I cannot open any of the sheets | Excel Worksheet Functions | |||
| Hide Certain Sheets based on Cell Data | Excel Programming | |||
| Code to transfere all cell data in one old file to a new open? | Excel Programming | |||
| cut & paste between sheets based on cell data | Excel Programming | |||
![Steph[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
