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
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