A Macro to Print sheets in mult w.books

G

Gladiator

Hi there, can anyone help me with the codes to get a macro to print local
wbook sheets along with the several sheets in other workbooks? I was able to
record a macro to print worksheets in the local workbook, but how do i make
the same macro to print the worksheets in three more different workbooks with
multiple worksheets in them? Thanks in advance?
 
F

Fred Smith

Your best bet is to:
a. Post your code
b. Post to the .programming newsgroup.

Someone will show you how to change your code to support other workbooks.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A macro code to print multiple sheets in different w.books 3
Macro to format multiple worksheets 24
print macro 8
Excel VBA - macro that copies the sheets to another workbook 3
How to record a macro within a macro 9
Creating a print-macro that'll only print page 1? 2
Rename worksheets macro 2
Macro to copy value in field and insert it into filter 2

Top