Macro for creating pdf with multiple sheets based on cell value in each sheet.

LEHoisveen

New Member
Joined
Aug 4, 2017
Messages
7
I'm trying to create an macro for generating a pdf containing multiple sheets, I want all sheets that have A1 = "x" or "X" to be included in the pdf.
I also want the pdf to be saved in \..\..\9 - GENERERTE PDF\ and with the value in call H7 in active sheet to be the file name.

All the sheets are named diferently, they have not the standard names anymore.

I have tried to modify some other macros I have without luck :( anyone that can help?
Running MS365
 

Attachments

  • TILBUDSMAL MED KALKYLE OG AVTALEFORSLAG - Excel.png
    TILBUDSMAL MED KALKYLE OG AVTALEFORSLAG - Excel.png
    8.4 KB · Views: 3

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,214,976
Messages
6,122,541
Members
449,089
Latest member
davidcom

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
Back
Top