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

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]

Comment on Re^3: Trying to use Win32::OLE PasteExcelTable method Download Code

Replies are listed 'Best First'.
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]