hematinsite
New Member
- Joined
- Nov 3, 2020
- Messages
- 14
- Office Version
- 2019
- Platform
- 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
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