Search:

Type: Posts; User: sludge7051-x

Search: Search took 0.01 seconds.

  1. Re: Compile error: User-defined type not defined

    This is exciting! I asked Bing Chat, and with some slight modifications, I got it to work:

    Q: Using VBA 7.0, what is the code for a macro that 1.) Checks to see if Firefox is open, 2.) If...
  2. Process.GetProcessesByName()

    It looks like I got it from this page:

    VB.NET: Check To See If A Process Is Running . . ....
  3. Compile error: User-defined type not defined [SOLVED - Using Bing Chat]

    I used the macro wizard to make this, and don't really know the code. I can figure it out sometimes.

    I'm trying to tack on this first part, to my VB that works (below), to see if Firefox is open...
  4. Re: Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    I have posted the question here:

    VBA - There is no Undo for a Macro today, by design. Why? . . ....
  5. Re: Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    But now I'm thinking . . . If the size of the Undo file is an issue, why don't they just let you write it to a temporary file on your hard drive? Then the file size becomes much less important. Is...
  6. Re: Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    west, yes, apparently this can be more complex than what I'm doing - working with just one Worksheet.

    They should let you have the option to Undo, where they let you specify how much memory it can...
  7. Re: Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    Ok, I figured it out. This is a common question, with a "hard-to-find" answer:

    1.) There is no "undo" for a macro, by design, because the undo history could be huge.

    2.) So, as I see it, the...
  8. Re: Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    Excel has a maximum of 24 memory buffers:
    ...
  9. Re: Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    I think the answer would be in these links:

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -...
  10. Re: Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    . . . in word this does not happen, so i would believe that it is just the way the excel object model works

    are you saying that you can do a copy and paste macro like mine above, in Word, and...
  11. Why doesn't Ctrl+Z work on a "Paste" macro, but it does if you used Ctrl+V ?

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    I use a "Copy" macro to copy a page, and a "Paste" macro to paste the cells (please see below).

    I have...
  12. Replies
    8
    Views
    7,618

    Re: ActiveSheet.Paste / Runtime Error 1004

    . . . copy and pasting is not necessarily the most efficient method of copying by code

    I have a Worksheet of "to do" lists . . . 12 pages across, 4 pages down, 48 total . . . I have macros that...
  13. Replies
    8
    Views
    7,618

    Re: ActiveSheet.Paste / Runtime Error 1004

    Whoa - it works like magic now! Here are the two macros I'm using, and remarks. Why isn't this common knowledge?

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -...
  14. Replies
    8
    Views
    7,618

    Re: ActiveSheet.Paste / Runtime Error 1004

    I replied to this before, but don't see that it posted. Here's a repeat:

    . . . saving the workbook may well set cut copy mode to false,

    I have verified - yes it does

    . . . so you need to...
  15. Replies
    8
    Views
    7,618

    Re: ActiveSheet.Paste / Runtime Error 1004

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    Wait:

    I got rid of the "Save" worksheet function, to further simplify, and found:

    a.) When I "Step"...
  16. Replies
    8
    Views
    7,618

    Re: ActiveSheet.Paste / Runtime Error 1004

    . . . saving the workbook may well set cut copy mode to false

    Yes, it looks like that prevents "ActiveSheet.Paste" from working, but why not "Ctrl+V" ? I can still paste the copied cells with...
  17. Replies
    8
    Views
    7,618

    ActiveSheet.Paste / Runtime Error 1004

    Simplified version of what I'm trying to do:

    I just want to copy some cells, 5x5, and then paste the info somewhere to the right of them, in the same Worksheet.

    The most important question for...
Results 1 to 17 of 17



Click Here to Expand Forum to Full Width