I'm having a problem with what, I hope, is a situation that has an obvious answer that I'm simply overlooking.
Here are the basic details of what I'm doing:
1. Periodically a report is ran and sent via email attachment in xls format that is saved to the user's computer
2. Via userform, the user opens up the attachment
3. Key data from the workbook is copied over into another workbook, sorted and used to populate several fields in a formatted coversheet
4. Multiple activities take place after this
The problem is...I can work within a single workbook without any serious issue. However, bringing data from one workbook to another has given me issue.
Coding the process for populating the coversheet infomation is also no issue...if I have the data in place.
Any help would be greatly appreciated!
lr
Here are the basic details of what I'm doing:
1. Periodically a report is ran and sent via email attachment in xls format that is saved to the user's computer
2. Via userform, the user opens up the attachment
3. Key data from the workbook is copied over into another workbook, sorted and used to populate several fields in a formatted coversheet
4. Multiple activities take place after this
The problem is...I can work within a single workbook without any serious issue. However, bringing data from one workbook to another has given me issue.
Coding the process for populating the coversheet infomation is also no issue...if I have the data in place.
Any help would be greatly appreciated!
lr