Macro to convert a specific

[elderL]

Hello everyone,

I am looking at converting a specific sheet from multiple files in a pdf format. I have found a macro wich I have slightly modified to be able to select the input folder containing the original files and the output folder where the pdf files should go. Currently it is working fine but the whole worksheet in being printed to a pdf file. I would need to only print the spreadsheet named "Profil". The code is described here below.

Is there any one who could help me in modifying the existing macro to only convert the spreadsheet "Profil" to pdf?

In advance thank you very much

Please Login or Register  to view this content.

[nathansav]

if BukName ="Profil" then

....export code

end if

[elderL]

Hi Nathansav

Sorry I am relatively new to VBA, could you show me on the macro where I should insert the code you specified?

Thank you

[nathansav]

before your export code after setting BukName = Left(Buk.Name, LPosition)

[elderL]

Hi Nathansav

Sorry I have just tried but it does not seem to export the pdf files. Is it possible to define a range withing the "profil" sheet? I guess that your code identifies the file name and not the sheet within the worksheet. Or more probably I am totally out.

[nathansav]

You said spreadsheet in your post, so thought that you meant a workbook called Profil. Which is what my code does.

Please Login or Register  to view this content.

you will need to change these both to Sheets("Profil").index i think.