VBA to convert pdf

[Abdulkhadar]

Hi Excel Experts.
I want to save excel sheet as pdf, file name is as per cell C15, location -desktop.
Thank you

 

[jolivanes]

Can you in a concise manner explain what you want to achieve. I am horrible at going through other's code and try to understand.
I did see that two sheets are excluded when ClearingContents but if you want all the other stuff done the "Next ws" needs to be moved after you save the sheet to PDF

 

[Abdulkhadar]

#8 does what you need, just add some of your other code to exclude the sheets you don't want to do it to.

yes sir it works, but page set up not working and only one sheet saved blank.

 

[jolivanes]

If you take the time to answer post #11, it should be pretty simple.

 

[Abdulkhadar]

Can you in a concise manner explain what you want to achieve. I am horrible at going through other's code and try to understand.
I did see that two sheets are excluded when ClearingContents but if you want all the other stuff done the "Next ws" needs to be moved after you save the sheet to PDF

Can you in a concise manner explain what you want to achieve. I am horrible at going through other's code and try to understand.
I did see that two sheets are excluded when ClearingContents but if you want all the other stuff done the "Next ws" needs to be moved after you save the sheet to PDF

Your code is working as per my goal. generated all sheets in pdf. thank you.
In "Data" sheet column F have contains sheets names. my code work as, first clear the contents from 19 row of every sheets except "Centre" and "Data" sheets. then from "Data" sheet transfer data from column B to E to concerned sheets as per column F (sheets name).
Now I want to set up the page up to last content row of every sheets from column A to E exclude "Centre" and "Data" sheets and convert pdf exclude "Centre" and "Data" sheets.

 

[jolivanes]

Question.
You are looping through all Sheets in the Workbook with the exception of two Sheets ("Data" & "Center") with "For Each ws In Worksheets"
Why do we need to get the Sheet Names from "Data" Sheet?

 

[jolivanes]

I must be misunderstanding.
If you clear from Row 19 on down, your first empty cell will be A19, B19, C19 etc
Why do we need to find the last Row with Cells(Rows.Count, "B").End(xlUp)? The offset should be 19
If possible put your workbook with before and afters in DropBox or similar free site and let us know how to get it.

 

[Abdulkhadar]

Question.
You are looping through all Sheets in the Workbook with the exception of two Sheets ("Data" & "Center") with "For Each ws In Worksheets"
Why do we need to get the Sheet Names from "Data" Sheet?

because the data transferred to concerned sheets as per column F of "Data" sheet, the sheets names are as it is in column F of "Data" sheet. so data transferred to concerned sheets as it as in column F sheet name. In "Data" sheet, In the F column of "Data" sheet, "Centre" and "Data" name sheet are not included. If any changes in "Data" sheet, so when update the data want to clear the content of all sheets except these two sheet, then update the data as per in "Data" sheet again.

 

[Abdulkhadar]

I must be misunderstanding.
If you clear from Row 19 on down, your first empty cell will be A19, B19, C19 etc
Why do we need to find the last Row with Cells(Rows.Count, "B").End(xlUp)? The offset should be 19
If possible put your workbook with before and afters in DropBox or similar free site and let us know how to get it.

Supervisor List Mar-24.xlsm

 

[jolivanes]

OK, got it. Thank you very much.
There are a lot of duplicate sheet names in Column F so I assume you want these filtered and copied into these same named sheets.
I would not think that if you have for instance 20 times a sheet in Column F that you want to copy one row and print, copy the next row and print and do this for all 20 times that you copied data across. In other words, you only want the sheets saved to a pdf file once when we've looped, or filtered, through all of Column F
Do the existing data need to be deleted first. From your code it looks like just add it to the bottom and print. Is that right.
Let us know if my thoughts are as you need it done.
It is bed time here now so it'll be tomorrow.

 

[Abdulkhadar]

OK, got it. Thank you very much.
There are a lot of duplicate sheet names in Column F so I assume you want these filtered and copied into these same named sheets.
I would not think that if you have for instance 20 times a sheet in Column F that you want to copy one row and print, copy the next row and print and do this for all 20 times that you copied data across. In other words, you only want the sheets saved to a pdf file once when we've looped, or filtered, through all of Column F
Do the existing data need to be deleted first. From your code it looks like just add it to the bottom and print. Is that right.
Let us know if my thoughts are as you need it done.
It is bed time here now so it'll be tomorrow.