Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: UUUUhhhhhhhhh

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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..

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •