Re^2: Trying to use Win32::OLE PasteExcelTable method

I think either $range->PasteExcelTable( 0, 0, 0 );

or $range->PasteExcelTable({ LinkedToExcel => 0, WordFormatting => 0, RTF => 0, }); aka

my %args = ( qw/ LinkedToExcel 0 WordFormatting 0 RTF 0 / );
$range->PasteExcelTable( \%args );
[download]

But I don't have ole/word/excel/table to test

Comment on Re^2: Trying to use Win32::OLE PasteExcelTable method Select or Download Code

Replies are listed 'Best First'.
Re^3: Trying to use Win32::OLE PasteExcelTable method by aaronbaum2000 (Initiate) on Oct 02, 2014 at 14:40 UTC
Thanks for the suggestions, but they didn't work either. I've listed the code lines and commented the exceptions/errors each gave me below my %args = ( qw/ LinkedToExcel False WordFormatting False RTF False / +); $range->PasteExcelTable( \%args ); #Gives me "Command not availabl +e" #my %args = ( qw/ LinkedToExcel 0 WordFormatting 0 RTF 0 / ); #$range->PasteExcelTable( \%args ); #Gives me "Command not availab +le" #$range->PasteExcelTable( 0, 0, 0); #Gives me "Command not availa +ble" #$range->PasteExcelTable({'LinkedToExcel'} => 0, {'WordFormatting' + => 0}, {'RTF' => 0}); #Gives me "Invalid number of parameter" #$range->PasteExcelTable({'LinkedToExcel' => 0, 'WordFormatting' = +> 0, 'RTF' => 0}); #Gives me "Command not available" [download]	[reply] [d/l]
Re^4: Trying to use Win32::OLE PasteExcelTable method by Anonymous Monk on Oct 02, 2014 at 23:25 UTC
Command not available seems like a very important message, like "out of hot dogs" ... you can't get a hot dog if the store doesn't have hot dogs	[reply]