Hi,

I'm trying to create a macro for some guys at work who have very little knowledge of excel, so it needs to be really simple to use.

Basically the user will be working on a workbook, on a specific sheet and I want them to press a button, where they choose a specific file and then the macro automatically copies set cells (always the same cells) from a set tab (name will not change) to the original workbook in a set location.

I've managed to do most of it but I'm having proplems making the original workbook active using the code below:

Windows("Enhanced Calculator Template v1.6.xls").Activate

My problem is that the filename of the original excel workbook will change and be different for each user. Ideally I want a way of creating a string where I can store the filename of the original excel workbook.

Thanks for all your help.