using Win98se, OO.o 2.3(680m5 9221), Opera 9.24:
Copy from cells from bank statement via Opera 9.24 won't auto-paste:
I want to copy rows of 'cells' of a bank statement from Opera & paste
to Calc without the need to confirm the format every time .
When I try to paste to a calc file in OO.o 2.3, a window pops up
asking if I want "Text Import" as "unicode".
I ALWAYS want this.
If I select to 'paste special' I am then asked if I want 'unformatted
text' (only choice). If Ok the same "Text Import" as "unicode" pops
up.....
How do I tell OO.o to DEFAULT to this without the pop-up window ALWAYS
showing??
I always want to default to unformatted text from any other program.
(This was also in OO.o 2.2)
I recorded a macro to do this but I can't get it to 'ENTER' the final
"ENTER' ( I have to type <ENTER> manually)
this is the recorded code:
REM ***** BASIC *****
sub PasteUnformatted
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
----------------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Format"
args1(0).Value = 1
dispatcher.executeDispatch(document, ".uno:PasteSpecial", "", 0,
args1())
end sub
Drew? please help?
Thanks for any help, Greg
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
