How do I get a macro to move between workbooks?
I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4,...
View Answer
| Jun 19 2008 1:19 AM GMT
| asked by
Bondsmith
Macros, Microsoft Excel, Workbooks
Word macro to toggle tracked changes after running an “update fields”
I have a macro that will turn off track changes (if they are on or leave them off if they are off) and then update the field codes in the document. Now I need to know how to return the document to its original state after it runs the update portion of the macro (track changes back on if they were...
View Answer
| Jun 13 2008 1:19 AM GMT
| asked by
Calberts
Macros, track changes
Editing exhisting macro
I have an exhisting macro but now I want to delete column's E and H in one of the sheets and am unsure how to edit the macro to correspond to this change.
View Answer
| Jun 7 2008 7:08 PM GMT
| asked by
Cadenthais
Excel macros, Macros, Microsoft Excel
Deletion of Macros when doing a repair & compact
We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up--what do you think could be the problem?
Answer Question
| May 5 2008 6:14 PM GMT
| asked by
SharieL
Macros, Repair and Compact, Microsoft Access
ctrl f and highlight intervening text
For macro writing purposes, I'm trying to figure out how to make a ctrl f search in Word or a text editor highlight (for subsequent deletion) intervening text between the cursor and the found character. Is there some way to do that? Thanks!
Answer Question
| Mar 10 2008 3:03 PM GMT
| asked by
Petter
Microsoft Word, Macros
