Copy table from another excel file

**too_tall** · 01-17-2007, 05:53 AM

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.

**Carim** · 01-17-2007, 06:24 AM

Hi,

Make it a variable, stored in the worksheet ...

Dim myfile As String
myfile = Range("A1").Value
....
Windows(myfile & ".xls").Activate

**koda86** · 01-17-2007, 07:04 AM

Hello Carim,
I would like to know how almost everyone uses Dim ... as integer or as string at the beginning of each macro and what does it mean for both??? I tried to find out explanations but I could not.
Thank you