I also had the problem when first writting the code.

wdApp.Selection.PasteExcelTable(False, False, True) gives a syntax error
looking for an "="

That happens when you put args in parenthesis for any proc.


but wdApp.Selection.PasteExcelTable False, False, True works just fine.

The rule is if you're not expecting a return then don't send an
envelope (ie: envelope = args wrapped in parenthesis) In this case
you're just passing parameters to PasteExcelTable method, which doesn't
return anything such as would be the case if it was a function that
returned a value or reference.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc