Hello everyone. I am coming to you for extreme help. I have been googling for days now and can't seem to find the answer.

Background. My company is going through a major project by converting 10,000 customers to a new system and we need to fill out a form for each member. My project consists of 3 parts, which I will outline here to see if anyone at all can help me.

1st - i have a form already created for this first part. After the form is created, i wish to have a button on the form that executes a Macro. This Macro will...

Auto save the file as a pdf with the file name as 'Cell contents of C5' in the form of a PDF. However, it needs to go to a specific folder on a network drive of "L:\Order process\ILEC queue" BUT!!! At this location, I need to create a sub folder labeled "FC - 'cell contents of C5(minus comma)' & 'cell contents from G5'

FYI - C5 is the customer name as 'Last, First' If needed to simplify this macro, I could seperate it out, but would rather not.
G5 will be the customer ID number.


That is the first step.

The second step...
I can create the form that auto fills from sheet 1 to sheet 2. But i will then just need to PRINT sheet 2. (there may be some additional data I will need to enter on sheet 2, so the macro button could be on sheet 1 or 2.)

The third step - if its even possible...

For scheduling these installations, my company utilzes about 6 technician calendars that are on a microsoft exchange server. I would LOVE for a macro that auto creates a calendar event based on specific items in the worksheet. However, I am unsure if this can be done by clicking on a check box of which calendar it stores on or a drop down, or if IS possible...
I would be happy to elaborate on this step if someone thinks its possible, but i am leaving it vague for now since I do not think it is possible.


If ANYONE is able to assist me, it would be so gratefully appreciated!

Thank you!