![]() Workbooks(MVP.Name).Application.CalculateBeforeSave = False ![]() Workbooks(MVP.Name).Application.Calculation = xlCalculationManual Sheets("Automatisierung Datenupdate").Activate Pfad_Input = ActiveSheet.Range("B7").Value Thanks a lot in advance! ' Definitionsĭim mapping_sheet, Worksheet_MVP, Dateiname_Input, Name_Worksheet_Input, Pfad_Input, Pfad_Datei, Zelle, Text As String To cancel saving the file, click cancel."ĭoes anyone have an idea on how to fix this error? I am also posting the full code below. To make the repairs in a new file, click continue. Microsoft Excel may be able to save the file by removing or repairing some features. However, sometimes the macro cannot save the file (and I cannot see a regularity here - sometimes it works, sometimes it doesn't) and it displays the error message: "Errors were detected while saving. The macro works fine and the inputs are pasted in my excel model. I am just updating the values and not inserting formulas, formats or images etc. ![]() I want to insert data from source files in my excel model by opening the files and copying and pasting the values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |