Timeline for Pasting from another workbook
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 27, 2018 at 20:59 | comment | added | AJD | @Robby: [...] So, taking a step back - what problem are you trying to solve, what outcome are you trying to achieve, and is refactoring a single macro going to help or should you rethink your suite of macros? | |
| Jul 27, 2018 at 20:59 | comment | added | AJD | @Robby: clearly there is more to this than you have exposed. I suspect that refactoring at a higher level would help - but we can only work with what we have given. This single macro will not cause noticeable slowness - the biggest time driver would be the opening and closing of the workbook or the handling of events that we don't know about here. However, if you are opening multiple workbooks (or, even worse, opening the same workbook multiple times) this will all add up. [...] | |
| Jul 27, 2018 at 12:44 | comment | added | Robby | A lot of the other code is written similarly. I haven't had time to try this technique yet, but the plan is to make similar changes to the other code that I have, and hopefully it does make an impact on the load my macro takes on. | |
| Jul 27, 2018 at 6:13 | comment | added | Raystafarian | @Robby if you have more, feel free to post it as another question | |
| Jul 24, 2018 at 20:10 | history | edited | AJD | CC BY-SA 4.0 |
Updated based on feedback.
|
| Jul 24, 2018 at 20:00 | comment | added | Robby | There's LOTS of code happening before and after this bit of code runs in one workbook. This Sub opens Formatting.xlsx, making it visible, but it needs to be not be visible. I just need it open long enough to copy and paste over to the original workbook, and then close. | |
| Jul 24, 2018 at 19:51 | history | answered | AJD | CC BY-SA 4.0 |