cancel
Showing results for 
Search instead for 
Did you mean: 

print workbook

Former Member
0 Kudos

Hi,

I have to print the workbook with page number in the bottom right corner and company name with copyright infomration in the bottom of the page(each ).

How to achieve it.

Button with some VBA code?

Thanks

billy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You only need to create a template workbook, to be the permanent woorkbook for your query. after that you just format your workbook with the page setup in the excel and save the workbook.

Answers (1)

Answers (1)

Former Member
0 Kudos

This is easy in with the Web Frontend, must the source be a Workbook?

Former Member
0 Kudos

Hi Alan Poole,

Can you give me some more details.

Thanks

Billy

Former Member
0 Kudos

Have a look at the document: How to...Enhance Web Printing

You will need to add your query to a Web Template and then you can adjust the print settings using the above mentioned doc.

alan