Forum Discussion
VBA for Excel (365), how to print to PDF, while scaling to fit all columns to a single page wide?
NikolinoDE Sorry for the late reply. Thanks for the help. I was able to resolve the issue in another MS forum (https://social.msdn.microsoft.com/Forums/lync/en-US/5295c5e4-7517-41f5-a341-99b84035c59a/with-vba-for-excel-office365-how-can-i-print-a-worksheet-to-pdf-while-scaling-to-fit-all-columns?forum=exceldev).
As far as I had to learn here...
(This information without guarantee, I would be happy to be instructed if it could work.
MS changes, develops and refines its products so well and quickly that you can hardly keep up with them. They are that good! :).
Click the Link for more info about this issue, Please:
This feature is not available in Excel for the web.
If you have the Excel desktop application, you can use the Open in Excel button to open the workbook and scale the worksheet to fit data on one page.
Fit to one page
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE Thanks for the reply. I had a look at that link. Unless I'm missing something though, it describes how to print using the GUI provided by the Excel application. I'm asking how to print using VBA for Excel. Did I miss that information somewhere in the link you provided?
All versions of Office 365 will allow execution and creation of Macros, it is only the free online version that will not.
Mean with it, only MicrosoftOffice 365 (browser version) does not support VBA macros.
Does Office 365 Online version supports VBA(visual basic for applications)?
Work with VBA macros in Excel for the web
Excel for the webEnable or disable macros in Office files
VBA Macros in Excel (office 365)
I hope that with this information I was able to help you in any way.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE I appreciate the reply, but those links aren't giving me any helpful information for my question. I'm asking for specific help on why my VBA code isn't doing what I expect.