Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Dukker Jansen   on Dec 08 In MS Office Category.

  
Question Answered By: Burk Martin   on Dec 08

They are named... I looked in the VBE and they are referenced by Sheet1,
but not an order... I have sheet  12, sheet 9, sheet 7 and so on...

Obviously the easiest is to open  each workbook 12 times and print  the
first sheet I need, the 2nd, 3rd and so on...

I was thinking I could put them in a collection, have them all open and
then iterate thru the collection  one sheet at a time... It doesn't seem
logical that when I reference the workbook from the collection that the
program would now it's a spreadsheet... Plus I can't think of a good way
to programmatically say here is book  1 print the first page, now go to
book 2 and print the first page... Then go back  to book 1 and print page
2...

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Printing page1 in 39 wrkbks then page 2, etc... Or get search suggestion and latest updates.


Tagged: