G
gearoidterry
Hi,
I'm trying to convert this VB code:
ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\perl\2.csv", _
Destination:=Range("A1"))
into Perl and can't seem to get the syntax right. Can someone please
help me out? Here is what I have within Perl:
$xlBook->ActiveSheet->QueryTables->Add(Connection=>"TEXT;C:\perl\2.csv",
Destination=>Range("A1"));
I think the Connection parameter is Ok but the syntax on the
Destination parameter is definitely not correct.
Any advice is greatly appreciated.
Thanks,
Perl07.
I'm trying to convert this VB code:
ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\perl\2.csv", _
Destination:=Range("A1"))
into Perl and can't seem to get the syntax right. Can someone please
help me out? Here is what I have within Perl:
$xlBook->ActiveSheet->QueryTables->Add(Connection=>"TEXT;C:\perl\2.csv",
Destination=>Range("A1"));
I think the Connection parameter is Ok but the syntax on the
Destination parameter is definitely not correct.
Any advice is greatly appreciated.
Thanks,
Perl07.