Copy sheet to sheet based on examples from ron
 

Hi!!
I use this based from examples from ron.
GetData "c:\city breaks\priser\usa\fil.xls", "Fil", "A1:A2",
Sheets("Fil").Range("A1"), True
its works allright
but now i would like to make it so i can use a
value from a sheet to change the map name
Like this
GetData "c:\city breaks\priser\usa\"& priskalk!$A$1&"\fil.xls", "Fil",
"A1:A2", Sheets("Fil").Range("A1"), True
But it dosn't work with "& priskalk!$A$1&" i get an error here.
CAn someone help me please.

Best Regards Alvin

Copy sheet to sheet based on examples from ron
 

Hi!!
i have found out how
Alvin


"Alvin Hansen" skrev:

Hi!!
I use this based from examples from ron.
GetData "c:\city breaks\priser\usa\fil.xls", "Fil", "A1:A2",
Sheets("Fil").Range("A1"), True
its works allright
but now i would like to make it so i can use a
value from a sheet to change the map name
Like this
GetData "c:\city breaks\priser\usa\"& priskalk!$A$1&"\fil.xls", "Fil",
"A1:A2", Sheets("Fil").Range("A1"), True
But it dosn't work with "& priskalk!$A$1&" i get an error here.
CAn someone help me please.

Best Regards Alvin