Command button to create folder

A

Andy Roberts

Hi

I have a spreadsheet with each job we do in Column A and Job Name in Column
B and postcode in Column C e.g. 9999 Smith Road, London SW19 6RE.

Here is what I'm looking to do...

Have a command button at the top of the sheet which when pressed prompts for
a Job No. I would enter the job number and it would create a folder in a
specific network drive with the title "9999 - Smith Road, London SW19 6RE"

In addition it would hyperlink the Job number to the folder it has just
created.

Also some address have "/" characters in the Job Name cell which can't be in
folder/file names so it would need to replace these with say a "," in the
folder name.

Also it would need to check for any folder with the same job number at the
start

Andy
Office 2010
Win XP Pro SP3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top