Dear All,
I am working on a userform which requires further enhancement for which I need your help.
Let me first explain what this tool is doing..
Description of the tool:
In the home tab if you click on ‘Click here to submit your idea’, it will open the userform( which user uses to submit their idea). If you select the employee ID, employee name and department wil be automatically filled in, you have to enter the date, write the name of the idea, synopsis and process impact, and finally hit the submit button. Once you hit the submit button, excel will store the information ‘Data’ sheet and and save the information from excel to Word doc and place the doc in the same path where the workbook is located.
My requirement:
b. Second slide should contain synopsis , process impact and the attached file. Please note that as of now, the length of text to be entered in the text box of the user form is not fixed which I am planning to limit later (say 100 words)
Looking forward for your help on this piece.
Regards,
Kaushik
I am working on a userform which requires further enhancement for which I need your help.
Let me first explain what this tool is doing..
Description of the tool:
In the home tab if you click on ‘Click here to submit your idea’, it will open the userform( which user uses to submit their idea). If you select the employee ID, employee name and department wil be automatically filled in, you have to enter the date, write the name of the idea, synopsis and process impact, and finally hit the submit button. Once you hit the submit button, excel will store the information ‘Data’ sheet and and save the information from excel to Word doc and place the doc in the same path where the workbook is located.
My requirement:
- It may happen that an user want to attach a supporting file(could be word, excel or ppt(most preferably)). Considering that, I want to place a button in userform , clicking on which file open dialogue box will open and user will be able to select the file from their location(any drive in the computer) and attach it in the tool. As I said the entered data are getting stored in data sheet from Column A to Column G(one after another row), hence the selected file should be inserted in Col H of that corresponding data row
- Instead of saving the data into word, I want to save the same in PPT as follows:
b. Second slide should contain synopsis , process impact and the attached file. Please note that as of now, the length of text to be entered in the text box of the user form is not fixed which I am planning to limit later (say 100 words)
Looking forward for your help on this piece.
Regards,
Kaushik