Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2021, 02:44 PM
wardw wardw is offline Can't save macro; it's "in use by another application" Windows 7 64bit Can't save macro; it's "in use by another application" Office 2007
Advanced Beginner
Can't save macro; it's "in use by another application"
 
Join Date: Oct 2012
Posts: 56
wardw is on a distinguished road
Default Can't save macro; it's "in use by another application"

I've added a macro to VBA in the Normal project, so it will be saved in Normal.dotm. The macro runs in Word. When I try to save the macro, I get the message "This file is in use by another application or user. (C:\Users\wardw\AppData...\Normal.dotm)"



When I click OK in the message, a Save As dialog opens, suggesting I save the Normal.dotm file in the above directory. If I try to save it there, I'm told I can't replace the existing Normal.dotm file because it's read-only.

If I close Word to ensure that Normal.dotm isn't in use, of course the VBA app closes as well and loses the unsaved macro.

In the Normal.dotm file's Properties under Attributes, the Read-only box is not checked.

Is there a way to escape this seeming paradox?
Reply With Quote
  #2  
Old 07-12-2021, 09:23 PM
gmayor's Avatar
gmayor gmayor is offline Can't save macro; it's "in use by another application" Windows 10 Can't save macro; it's "in use by another application" Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

It sounds like you have an orphaned lock file. This will occur is Word crashes and is not addressed.
Close Word and see https://www.gmayor.com/what_to_do_when_word_crashes.htm with regard to lock files.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 07-12-2021, 11:29 PM
Guessed's Avatar
Guessed Guessed is offline Can't save macro; it's "in use by another application" Windows 10 Can't save macro; it's "in use by another application" Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

In the past I seem to recall issues where Outlook uses Word as the email editor and it could be causing the lock. Perhaps make sure Outlook is closed too in case that is the issue.

In any case, the macro doesn't have to be saved into Normal.dotm. You could save it to another document and SaveAs that file to make it a docm or dotm file.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 07-13-2021, 11:40 AM
wardw wardw is offline Can't save macro; it's "in use by another application" Windows 7 64bit Can't save macro; it's "in use by another application" Office 2007
Advanced Beginner
Can't save macro; it's "in use by another application"
 
Join Date: Oct 2012
Posts: 56
wardw is on a distinguished road
Default

Thanks, Andrew. I don't have Outlook on my computer, but I saved the macro as Normal1.dotm, and that seemed to work.

Thank you, too, Graham. I deleted the temp files, but no joy. I hesitated to follow all the recommended steps for digging out and deleting the rest of the files fear of deleting something vital, but I've bookmarked the page because it will be useful for more important Word crashes.
Reply With Quote
Reply

Tags
macro, normal.dotm, save

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use a "Save As" button without causing digital signatures to become "Invalid"? jferg Word VBA 0 02-16-2016 03:04 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas jocke321 Word VBA 2 12-10-2014 11:27 AM
Disable "Save" & "Save As" & "Print" ribbon Villalobos Word VBA 3 07-14-2014 11:37 PM
Can't save macro; it's "in use by another application" Macro VBA "Save as" with bookmarks in file name string Dom37 Word VBA 2 10-31-2011 03:28 AM
"Microsoft Excel Application" missing in the "Component Services" on win08 sword.fish Excel 0 02-26-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft