Excel to pdf conversion without user intervention

%3CLINGO-SUB%20id%3D%22lingo-sub-2260311%22%20slang%3D%22en-US%22%3EExcel%20to%20pdf%20conversion%20without%20user%20intervention%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2260311%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20folder%20with%20subfolders%20in%20it.%20Each%20folder%20will%20have%20some%20Excel%20files%20coming%20into%20it%20whenever%20user%20generates%20Excel%20reports.%20I%20want%20to%20convert%20these%20Excel%20reports%20into%20pdf%20files%20automatically.%20Any%20one%20of%20the%20following%20will%20work%3A%3C%2FP%3E%3CP%3E1.%20Generate%20pdf%20automatically%20whenever%20a%20new%20Excel%20file%20is%20generated%20or%20added%20into%20a%20folder%20OR%3C%2FP%3E%3CP%3E2.%20Generate%20pdf%20files%20for%20all%20Excel%20files%20at%20a%20set%20time%20once%20in%20a%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERequest%20experts%20to%20guide%20how%20this%20can%20be%20achieved.%20Thank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EPawan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2260311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2260631%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20to%20pdf%20conversion%20without%20user%20intervention%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2260631%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1020118%22%20target%3D%22_blank%22%3E%40Pawanmusale%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20you%20don't%20describe%20exactly%20what%20you%20want.%3CBR%20%2F%3ESpecific%20area%20in%20the%20worksheet%2C%3CBR%20%2F%3ESingle%20worksheet%20in%20PDF%2C%3CBR%20%2F%3ECertain%20worksheets%20in%20the%20workbook%2C%3CBR%20%2F%3EWhole%20workbook%20in%20PDF.%3C%2FP%3E%3CP%3EHere%20is%20a%20Link%20of%20what%20I%20once%20found%20on%20the%20Internet.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F31111436%2Fsaving-a-range-of-data-as-a-pdf-with-a-button-in-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESaving%20a%20Range%20of%20data%20as%20a%20PDF%20with%20a%20button%20in%20excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20many%20ways%20to%20find%20a%20solution%2C%20that%20is%20the%20magic%20of%20Excel.%20It%20depends%20on%20what%20you%20need%20the%20solution%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2299108%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20to%20pdf%20conversion%20without%20user%20intervention%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299108%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20reply.%20I%20have%20one%20folder%20where%20system%20will%20automatically%20generate%20some%20Excel%20files%20with%20unique%20file%20names.%20These%20reports%20will%20have%20only%20one%20sheet%20in%20it.%20When%20system%20generates%20Excel%20reports%2C%20we%20want%20to%20generate%20same%20report%20in%20pdf%20format%20as%20well.%20Over%20the%20years%20thousands%20of%20reports%20will%20accumulate%20in%20this%20folder.%20How%20can%20we%20do%20this%3F%20Thanks.%3C%2FLINGO-BODY%3E
New Contributor

I have a folder with subfolders in it. Each folder will have some Excel files coming into it whenever user generates Excel reports. I want to convert these Excel reports into pdf files automatically. Any one of the following will work:

1. Generate pdf automatically whenever a new Excel file is generated or added into a folder OR

2. Generate pdf files for all Excel files at a set time once in a day.

 

Request experts to guide how this can be achieved. Thank you in advance.

 

Regards,

Pawan

4 Replies

@Pawanmusale 

Because you don't describe exactly what you want.
Specific area in the worksheet,
Single worksheet in PDF,
Certain worksheets in the workbook,
Whole workbook in PDF.

Here is a Link of what I once found on the Internet.

Saving a Range of data as a PDF with a button in excel

 

There are many ways to find a solution, that is the magic of Excel. It depends on what you need the solution for.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

Thanks for the reply. I have one folder where system will automatically generate some Excel files with unique file names. These reports will have only one sheet in it. When system generates Excel reports, we want to generate same report in pdf format as well. Over the years thousands of reports will accumulate in this folder. How can we do this? Thanks.

@Pawanmusale 

I'd ask Power Automate or PowerShell people, that's more question for them.

@Pawanmusale 

 

https://www.rondebruin.nl/win/section1.htm

 

This Link can give you more help as i can do.