Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button to create folder
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wanting to Create A Command Button Command | Excel Programming | |||
How to Create a Command Button | Excel Discussion (Misc queries) | |||
Open an Outlook folder when a user clicks on a command button ... | Excel Discussion (Misc queries) | |||
Open an Outlook folder when a user clicks on a command button ... | Excel Programming | |||
Opening an Outlook public folder from Excel using a command button... | Excel Programming |