Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Generated Hyperlinks
My need is this; I have a master spreadsheet with Column A being a list of
9 character control numbers which are text entries for hyperlinks to another folder filled with Excel spreadsheets, whose first nine characters are the control numbers matched in the master Spreadsheet. What I would like is an update spreadsheet button; not a new toolbar button, on the master spreadsheet that will tell excel to go look in a specified folder, it will always be the same folder, check to see if there are any files in the folder which are not on the master spreadsheet already. If there are new files create a new hyperlink; titled with the first nine characters of the file name in the next available cell in Coloumn A. When it is done updating a little window saying how many entries were created or if none were created would be nice, but not neccessary. I am not a VB programmer by anymeans and my Excel formula skills are moderate, so any help with this would be greatly appreciated, thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks? | Excel Programming | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
(repost) Adding hyperlinks to VBA-generated worksheets | Excel Programming | |||
Adding hyperlinks to macro-generated sheets from list of sheet nam | Excel Programming | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |