PeteS
General User
Joined: 12 Feb 2005
Posts: 43
|
 Posted: Tue May 10, 2005 8:17 am Post subject: Record Macro for Insert Sheet |
 |
|
When I try to Record Macro for Insert > Sheet From File, (where I specify the filename in the next dialog) the generated dispatch line is commented out, as if OO can't support it!
Why is that? |
|
PeteS
General User
Joined: 12 Feb 2005
Posts: 43
|
| Posted: Tue May 10, 2005 9:47 am Post subject: |
|
|
Similarly, when I record an Insert > Names > Define where I add a new named range, I get the same rem'd code:
| Code: |
sub DefineName
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
rem dispatcher.executeDispatch(document, ".uno:DefineName", "", 0, Array())
end sub
|
|
|
