PDA

View Full Version : use code on a new workbook



tommy1234
02-15-2009, 12:05 PM
Hello
i wrote a code which select rows according to some criteria and after that copy them to a new workbook (each workbook has different name).
i need to add a new column to the new workbook (it doesn't has any code in it) which will be hyperlink (each line) to outlook and when i'll press the hyperlink the only the line which is written in this line will be copy to outlook.
the problem is (i guess) to write the code in the original workbook and all the work to be done on the new workbook.

thanks

mdmackillop
02-15-2009, 12:38 PM
1. Create a template sheet in your original workbook and put the necessary code in that sheet module.
2. Copy your rows to the template sheet; add the column and create the hyperlinks
3. Copy the template sheet to a new book and save it with the new name
4. Clear the template sheet