Need Help Creating a Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-1111593%22%20slang%3D%22en-US%22%3ENeed%20Help%20Creating%20a%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1111593%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20macro%20and%20have%20been%20doing%20some%20research.%20Unfortunately%20every%20time%20I%20go%20running%20it%20gives%20me%20issues.%20I%20have%20done%20two%20days'%20worth%20of%20research%20and%20I%20am%20still%20having%20problems.%20Any%20help%20is%20greatly%20appreciated!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20macro%20that%3A%3C%2FP%3E%3CP%3ECreates%20a%20folder%20in%20a%20specific%20location.%20That%20folder%20name%20needs%20to%20be%20base%20off%20of%20a%20cell%20in%20the%20excell%20document.%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20save%20each%20sheet%20as%20a%20separate%20PDF%20inside%20the%20above-said%20folder%20with%20the%20name%20of%20the%20sheet%20and%20the%20above-named%20info%20that%20the%20folder%20was%20created.%3C%2FP%3E%3CP%3EIf%20all%20goes%20well%20I%20would%20like%20a%20message%20to%20pop%20up%20and%20say%20done%2C%20if%20something%20doesn't%20work%20or%20the%20folder%20already%20exists%20to%20pop%20up%20an%20error%20message.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1111593%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1111934%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20Creating%20a%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1111934%22%20slang%3D%22en-US%22%3EMaybe%20you%20wanna%20post%20the%20code%20you%20have%20so%20far%20so%20we%20don't%20have%20to%20start%20from%20scratch%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

 

I am trying to create a macro and have been doing some research. Unfortunately every time I go running it gives me issues. I have done two days' worth of research and I am still having problems. Any help is greatly appreciated! 

 

I need a macro that:

Creates a folder in a specific location. That folder name needs to be base off of a cell in the excell document. 

Then save each sheet as a separate PDF inside the above-said folder with the name of the sheet and the above-named info that the folder was created.

If all goes well I would like a message to pop up and say done, if something doesn't work or the folder already exists to pop up an error message.  

 

1 Reply
Highlighted
Maybe you wanna post the code you have so far so we don't have to start from scratch