D
Dick
Am trying to get a SharePoint list into a Word 2003 table and do some
formatting all with VBA in a Word template. Am pretty good with Excel VBA so
I thought this would be easy. Start by recording macros, then put them
together - WRONG.
So first I make sure I can do everything I want with the Word UI, then I
record them. But when I go to execute them as macros, I get all kinds of
"methods don't exist" errors, e.g.,
macro record gave:
Selection.PasteExcelTable False, False, False
cannot execute this 1 line macro from UI.
macro record gave:
With .Borders(wdBorderLeft)
.LineStyle = wdLineStyleSingle
.LineWidth = wdLineWidth050pt **
.Color = wdColorAutomatic
End With
The VBA dies on line ** when I try from UI.
What is the real root of the problem that my macro recordings don't run from
the UI? I am used to VBAizing all kinds of recorded macros.
Why does it say an Excel Table?
Dick P.
formatting all with VBA in a Word template. Am pretty good with Excel VBA so
I thought this would be easy. Start by recording macros, then put them
together - WRONG.
So first I make sure I can do everything I want with the Word UI, then I
record them. But when I go to execute them as macros, I get all kinds of
"methods don't exist" errors, e.g.,
macro record gave:
Selection.PasteExcelTable False, False, False
cannot execute this 1 line macro from UI.
macro record gave:
With .Borders(wdBorderLeft)
.LineStyle = wdLineStyleSingle
.LineWidth = wdLineWidth050pt **
.Color = wdColorAutomatic
End With
The VBA dies on line ** when I try from UI.
What is the real root of the problem that my macro recordings don't run from
the UI? I am used to VBAizing all kinds of recorded macros.
Why does it say an Excel Table?
Dick P.