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. |
All times are GMT +1. The time now is 07:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com