Creating & Printing HTML File - VBA

Zakkaroo

Active Member
Joined
Jul 6, 2009
Messages
383
I have set up a lovely looking Dashboard in excel, to be used by a number of people around the office, the problem is that it doesn't print properly.

I've discovered that there is an issue (and always has been) with excel, as it doesn't print shapes or pictures very well. They are distorted / not on the page - and through a lot of googling, it doesn't appear that there is a solution to the problem.

Trying to think my way around this issue, I contemplated adding my own print button that would:

1) Save the file as .html
2) Print the .html file

I tried using the code from the link below to print the resultant html file, it does print, but the page layout isn't set to landscape and so it doesn't fit on one page ...

http://www.jpsoftwaretech.com/open-or-print-files-in-vba/

Does anyone have any thoughts as to how I can have excel create the html file and print it - while being able to specify that it prints on one page, landscape?
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,127,959
Messages
5,627,861
Members
416,278
Latest member
CellHell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top