Windows 10: Excel Macro File Saving Problem

Discus and support Excel Macro File Saving Problem in Windows 10 Network and Sharing to solve the problem; Hello Friends, Here I am new so, please help me. I received a message/error "There isn't enough memory to complete this action" when I save my MACRO... Discussion in 'Windows 10 Network and Sharing' started by SandeepSoni4, Dec 28, 2021.

  1. SANDEEPSONI4
    SandeepSoni4 Win User

    Excel Macro File Saving Problem


    Hello Friends, Here I am new so, please help me. I received a message/error "There isn't enough memory to complete this action" when I save my MACRO File. I try all things from YOUTUBE but not helpful.

    :)
     
    SandeepSoni4, Dec 28, 2021
    #1
  2. MAURICE HICKS
    Maurice Hicks Win User

    File save/resave problem Excel running on Windows 10

    having trouble saving/resaving some Excel files (Windows 10). message.."errors were detected while saving..." Then on retry, message reads 'Microsoft Excel may be able to save this file by removing/repairing..." The problem seems tooccur on files where
    a Macro has been created. Anyone else had this problem and can you suggest a fix?
     
    Maurice Hicks, Dec 28, 2021
    #2
  3. SAXON
    Saxon Win User
    Problem with Excel macro to open Word files

    I am having a problem with an Excel macro which opens Word files. The macro opens the files OK but sometimes the file is not visible; instead, it is hidden in the window behind the Excel Workbook and the Word icon on the taskbar flashes to show that the file is open. I want the Word file to appear visible on-screen automatically without my having to click on the taskbar.

    The relevant part of the macro is:

    Set objWord = CreateObject("Word.Application")
    With objWord
    .Documents.Open DocsFullPath(i)
    .Visible = True
    .Activate
    .Application.WindowState = 1
    .ActiveWindow.ActivePane.View.Zoom.Percentage = 100
    End With
    GoTo Finish

    Can anyone help me resolve this? It's been driving me mad!
     
    Saxon, Dec 28, 2021
    #3
  4. HGAMBALE
    hgambale Win User

    Excel Macro File Saving Problem

    Save Excel 2007 file in two places with one step

    I have an Excel 2007 file that I need to save in two places whenever I make updates to it which is very often. Instead of saving twice is there a way to save in both places in one step? Seems I would need to create a macro but I'm not sure how. Can anyone
    please help? Thanks!
     
    hgambale, Dec 28, 2021
    #4
Thema:

Excel Macro File Saving Problem

Loading...

  1. Excel Macro File Saving Problem - Similar Threads - Excel Macro File

  2. Defender - excel macro exception

    in AntiVirus, Firewalls and System Security
    Defender - excel macro exception: Hello,how can be possible to create in Windows Defender an exception for directory with all sub directories, where can be stored xlsx files which can contain macro and will be macros predefined enabled for rest directories must be macro predefined disabled and can be manualy...

  3. Excel Macro File Saving Problem

    in Windows 10 Gaming
    Excel Macro File Saving Problem: Hello Friends, Here I am new so, please help me. I received a message/error "There isn't enough memory to complete this action" when I save my MACRO File. I try all things from YOUTUBE but not helpful....

  4. Excel Macro File Saving Problem

    in Windows 10 Software and Apps
    Excel Macro File Saving Problem: Hello Friends, Here I am new so, please help me. I received a message/error "There isn't enough memory to complete this action" when I save my MACRO File. I try all things from YOUTUBE but not helpful....

  5. Excel macro, if Excel gets the focus.?

    in Microsoft Office and 365
    Excel macro, if Excel gets the focus.?: So I want the macro to start immediately when I switch to Excel from another application with <alt>+<tab>. Excel-Makro, wenn Excel den Focus bekommt.?

  6. window 10 excel file save problems

    in Windows 10 Network and Sharing
    window 10 excel file save problems: I am using window 10. My excel files are saved somewhere unknown place c:\users\Star\AppData\Local\packages\microsoft .windowscommunication…...Attachments. how can I find this file....

  7. Problem with Excel macro to open Word files

    in Microsoft Office and 365
    Problem with Excel macro to open Word files: I am having a problem with an Excel macro which opens Word files. The macro opens the files OK but sometimes the file is not visible; instead, it is hidden in the window behind the Excel Workbook and the Word icon on the taskbar flashes to show that the file is open. I want...

  8. Problem with Excel macro to open Word files

    in Windows 10 Support
    Problem with Excel macro to open Word files: I am having a problem with an Excel macro which opens Word files. The macro opens the files OK but sometimes the file is not visible; instead, it is hidden in the window behind the Excel Workbook and the Word icon on the taskbar flashes to show that the file is open. I want...

  9. Add a shortcut to an Excel Macro

    in Microsoft Office and 365
    Add a shortcut to an Excel Macro: W10 and Excel. I have several macros in my personal.xls all activated from a customized ribbon or Quick Access. I would like to add a KB shortcut to 2 of them. I know I should have done that when I created them but I did not realize then how helpful it would have been My bad...

  10. Excel file saving problem. File disappeared.

    in Windows 10 Network and Sharing
    Excel file saving problem. File disappeared.: Excel file had problem saving. Window asked if report to Microsoft. Now, excel file disappeared. There is a .tmp file. Where is my excel file? https://answers.microsoft.com/en-us/windows/forum/all/excel-file-saving-problem-file-disappeared/c1450290-5248-4c9f-aeb2-47702d4bdc54"