I know it's sinple, but I'm very new at VBA
I like to create a PDF file from an excel worksheet:
Export sheet1 range D1:H10 and save with the name of F1 and G1 in sheet2
Ask for the directory location where to save and wait for the input name or change location
Sheet2 F1 has the name of the file Sheet2 G1 has the number of the file that will increase each time by 1 when the file is saved
I like to create a PDF file from an excel worksheet:
Export sheet1 range D1:H10 and save with the name of F1 and G1 in sheet2
Ask for the directory location where to save and wait for the input name or change location
Sheet2 F1 has the name of the file Sheet2 G1 has the number of the file that will increase each time by 1 when the file is saved