hashbrown64
New Member
- Joined
- Aug 6, 2010
- Messages
- 4
Hey there,
So I'm not a VBA whiz by any means, and need some assistance with a problem I'm having.
I want to turn all of the cells in a column of my spreadsheet into links to the files they're referring to. For example, if the cell says "May 2008 Report", I want it to link to that file.
The good news is that there is a column right next to the name of the document that has a unique identifier with the file name. Basically, I need code to do the following:
Add a hyperlink to each cell to J:\CEP\DB-Allen-CD\AS2_2009\IMAGES\[A1]\[A2]\[A3].tif
So I need some code to automatically create the links using the data in columns 1, 2, and 3. The link would go in column 4. Anyone have any ideas?
So I'm not a VBA whiz by any means, and need some assistance with a problem I'm having.
I want to turn all of the cells in a column of my spreadsheet into links to the files they're referring to. For example, if the cell says "May 2008 Report", I want it to link to that file.
The good news is that there is a column right next to the name of the document that has a unique identifier with the file name. Basically, I need code to do the following:
Add a hyperlink to each cell to J:\CEP\DB-Allen-CD\AS2_2009\IMAGES\[A1]\[A2]\[A3].tif
So I need some code to automatically create the links using the data in columns 1, 2, and 3. The link would go in column 4. Anyone have any ideas?