UUUUhhhhhhhhh

[Parra]

I am running a macro that starts in Excel goes to Word and returns to excel. And it won't paste what is in the clipboard. Any suggestions????As to why I get the following runtime error 1004??? I click on the debugger and the following line is highlighted

ActiveSheet.PasteSpecial Format:="Text"


AppActivate "Microsoft Excel"
Columns("A:A").Select
Range("A1").Select
ActiveSheet.PasteSpecial Format:="Text"
Range("A1").Activate

Oh, I am not an expert on code, please help. Thanks

 

[Jack in the UK]

common question you must set word as an objext to excel

i sugget opening he microsoft document sample.xls all laid out there and came with office all version from 97 on...

VBA code is these also..

 

[Ivan F Moala]

On 2002-04-25 15:30, Parra wrote:
I am running a macro that starts in Excel goes to Word and returns to excel. And it won't paste what is in the clipboard. Any suggestions????As to why I get the following runtime error 1004??? I click on the debugger and the following line is highlighted

ActiveSheet.PasteSpecial Format:="Text"


AppActivate "Microsoft Excel"
Columns("A:A").Select
Range("A1").Select
ActiveSheet.PasteSpecial Format:="Text"
Range("A1").Activate

Oh, I am not an expert on code, please help. Thanks

Your code line;
ActiveSheet.PasteSpecial Format:="Text"

Should be;

Activesheet.PasteSpecial Paste:=xlValues

Format is not a valid Pastespecial command.