vba excel to pdf

hematinsite

New Member
Joined
Nov 3, 2020
Messages
14
Office Version
  1. 2019
Platform
  1. Windows
hi dears
i have excel file and after convert to pdf , there are many empty margin in page. but if i convert excel to jpg and with acrobat reader convert jpg to pdf , then there is no margin and empty margin .
i adjust page zoom,printarea,scale to fit , software printer , print to file , save as pdf and etc .
are have any macro to do it for entire workbook , without any empty margin ? if these macro have these option is very good
1-for do it for entire workbook automativally and with no question
2-for each sheet make seperate pdf and every export pdf file name is same as sheet name in my excel file path
3- printarea by default selected for each sheets , for to convert in pdf
4-export pdf use minimum size pdf format .


for example i attached xlsm file to try on it in google drive

main.xlsm


kamel.png
naghes.png
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,119,119
Messages
5,576,205
Members
412,706
Latest member
msousa25
Top