Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21

    Unanswered: Macro & Clipboard

    I have a macro that copy/paste special values from a csv file into a excel workbook. After every page it asks me if I want to save the info on the Clipboard. What statement or option can I put into the macro so I don't have to keep clicking NO when the box pops up? Here is part of the macro where I think the code or option needs to go in....I just don't know what it is.....
    Range("A1:EZ20").Select
    Selection.Copy
    Windows("Data.xls").Activate
    Sheets("R0001").Select
    ActiveWindow.ScrollColumn = 1
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    Windows("R001").Activate
    ActiveWindow.Close
    Application.CutCopyMode = False
    Range("A1").Select

    Thank you,
    Melinda

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Code:
    Application.DisplayAlerts False
    Then be sure to include this immediately following the code, or you won't ever get the alerts in this macro.

    Code:
    Application.DisplayAlerts True
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21
    Originally posted by shades
    Code:
    Application.DisplayAlerts False
    Then be sure to include this immediately following the code, or you won't ever get the alerts in this macro.

    Code:
    Application.DisplayAlerts True


    Works like a charm......after adding in the "=" sign :-)
    Thank you!!!
    Application.DisplayAlerts = False
    Application.DisplayAlerts = True

    Melinda

  4. #4
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21
    Originally posted by shades
    Code:
    Application.DisplayAlerts False
    Then be sure to include this immediately following the code, or you won't ever get the alerts in this macro.

    Code:
    Application.DisplayAlerts True


    Works like a charm......after adding in the "=" sign :-)
    Thank you!!!
    Application.DisplayAlerts = False
    Application.DisplayAlerts = True

    Melinda

Posting Permissions

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