Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteExcelTable does not work in OS X
Something that I ran into today. When pasting a range from excel into
a new word document, Section.PasteExcelTable works great in windows but errors in Office 2011 for Mac. I also had the problem when first writting the code. wdApp.Selection.PasteExcelTable(False, False, True) gives a syntax error looking for an "=" but wdApp.Selection.PasteExcelTable False, False, True works just fine. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteExcelTable does not work in OS X
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteExcelTable does not work in OS X
Ok. Thanks, I understand what you are saying. I couldn't figure out
why it was giving me an error when I was writting it. Thanks again. Mike On 2010-11-21 19:07:32 -0500, GS said: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy work sheet to another work book, pros and cons | Excel Programming | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 | Excel Programming | |||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming |