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!
Bookmarks