Creating Folder and Hyperlink using user-defined input cell

[greeca]

Hi All,

I'm creating a worksheet which allows users to input progress against a project via a checklist system, which in turn updates a summary worksheet giving basic data from user inputs. I've got the spreadsheet itself working alright but I am now trying to create a Macro which both creates a blank folder using a user selected cell as the name and then creates a hyperlink within the worksheet to the newly created folder.

The full process would be as follows:

• User creates a new project column in the worksheet, giving the project a unique ID number in row 3.
• The user then presses a button which has a macro that:
  • Prompts the user to select the correct cell with the ID number for the newly created project column.
  • Creates an empty folder in the 'main project' directory with the ID number as its name.
  • Creates a hyperlink to the newly created folder at the bottom of the relevant project column.
• The user can then fill in the checklist as the project progresses and they can also access any files related to the project via the hyperlink to the project folder.

I don't know if it would be easier, when creating the hyperlink, to prompt the user to select the cell in which to place the link or to automatically have the link created at the bottom of the column (row 44).

For clarity I am using Windows XP and Excel 2003.

Any help you can offer on this would be appreciated.

Carl