Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wanting to Create A Command Button Command bumper338 Excel Programming 3 May 7th 07 06:53 PM
How to Create a Command Button Jason Excel Discussion (Misc queries) 1 October 12th 05 09:50 PM
Open an Outlook folder when a user clicks on a command button ... Rob Keel Excel Discussion (Misc queries) 2 August 1st 05 08:23 AM
Open an Outlook folder when a user clicks on a command button ... Rob Keel Excel Programming 2 August 1st 05 08:23 AM
Opening an Outlook public folder from Excel using a command button... Rob Keel[_2_] Excel Programming 1 July 29th 05 06:02 PM


All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"