• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Attach a file to and generate PPT from a USERFORM

kaushik03

Member
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:
  1. 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
  2. Instead of saving the data into word, I want to save the same in PPT as follows:
a. The first slide should contain Date, Employee ID, Name, Department, and Name of Idea (data and the header)
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
 

Attachments

  • IdeaSubmissionTool.xlsm
    338.5 KB · Views: 16
Hi, kaushik03!

Nice to read you again, buddy! I hope that everything's Ok for you... except Excel, as usual :p

Give a look at this file:
https://dl.dropboxusercontent.com/u...ssionTool (for kaushik03 at chandoo.org).xlsm

I've done only 1), 2) is still pending. Modified user form, at bottom right, added column H to worksheet Data, modified email sub to add attachments, if any, and word file generation.

If I happen to find a little more time I'll try to get back to you with 2)... but don't promise anything.

Regards!
 
Back
Top