New Template Workbook Set Up, find file directory, user input for use in macro

Good Day All,

I have a pretty complex workbook as a template, it contains a lot of macros to perform various functions. I use this workbook for multiple projects and in order to set it up for each individual project I have to go into VB and add a few things.

1. I have to manually go in and enter a couple of file paths, One is for the macro to know where to save pdfs and the other is where to find attachments for an e-mail. All the different projects have individual project folders, but they are all layed out the same way. So the workbooks are always in the same place. Is there any Macro that could locate the filepath for the folder the actual workbook is in?

2. I have to add the individual project number into the coding for a user form. Is it possible to create a macro where on initial set up a user input box would prompt me for a project number then use the number entered in this code.

It's easy enough for me to do the set up for these, but if I ever leave my job I'd like to leave behind a system that other people who don't know coding can use.

The first question is more important. The second one is more a queery if it can be done. I can easily use a prompt for the project number then just store it in a cell and call that cell in the coding.

Many thanks for any help

R

Bump for any advice

Ang again, Bump

Anyone have any idea's how to do this one?

Please Login or Register  to view this content.

The simplest little piece of code and my life just became a lot easier