Is it possible to replace 'ActiveSheet' by 'Sheets(strImported)' ??????????

[Hutas]

Hi guys

I need this line in my macro. What it does is, importing a textfile.

With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & vFilename, _
Destination:=Range("A1"))

What I want to do is to replace 'ActiveSheet' by 'Sheets("Import")' or something like that.
I hate the idea that I first need to select the sheet, and then Import the data.

Is this possible? Because with the 'Sheets("Import") method I get the error:

"The destination range is not on the same worksheet that the Query table is being created on."

Please let me know.
Thanx

[MSP77079]

Instead of 'Sheets("Import")', you should use Sheets("Import") (without the single quotation mark.

Alternative, you could use the CodeName instead of the Tab name for the worksheet. You can see the code name in the Project Explorer window of VB Editor. You will see something like this: Sheet1 (Import)

The command would then be: Sheet1.QueryTable .....

[Hutas]

Hi,

I know about the quotes, don't worry about them. The point is, that when I USE the Sheets("something") instead of Activesheet... then I get a error message. So I'm doing something wrong... and I want to know what that is.

Greetz,
Vernon

[MSP77079]

OK ... I can't tell exactly what it is you are trying to do ... so I'm not too surprised that VB is similarly confused.

I suggest dimensioning some variables. Then set the variables one at a time and step through the routine finding out which variable is not setting set.

One thing that is not clear is Range("A1"). Is that Range("A1") on the active sheet or the "something" sheet? Since you don't specify, the default is the active sheet. That might be the entire problem right there.