4 Answered Questions for the topic macros
Copy Excel worksheet and maintain relative cell reference in formulas?
Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula `=B!23` becomes... more
How can I stop Excel from opening a second blank window when opening a file from Explorer?
When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does!This seems to be a common... more
How to find document variables in MS Word without using a Macro?
I have document with some document variables in and I'm trying to use those variables in the document. But since the variables are set by an external system (which is not well documented) I'm... more