Search:
Type: Posts; User: sludge7051-x
Search:
Search took 0.01 seconds.
-
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...
-
It looks like I got it from this page:
VB.NET: Check To See If A Process Is Running . . ....
-
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...
-
I have posted the question here:
VBA - There is no Undo for a Macro today, by design. Why? . . ....
-
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...
-
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...
-
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...
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Excel has a maximum of 24 memory buffers:
...
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
I think the answer would be in these links:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -...
-
. . . 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...
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
I use a "Copy" macro to copy a page, and a "Paste" macro to paste the cells (please see below).
I have...
-
. . . 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...
-
Whoa - it works like magic now! Here are the two macros I'm using, and remarks. Why isn't this common knowledge?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -...
-
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...
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Wait:
I got rid of the "Save" worksheet function, to further simplify, and found:
a.) When I "Step"...
-
. . . 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...
-
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...
|
Click Here to Expand Forum to Full Width
|