Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save "speed up"
Hi!
I have a workbook that includes a macro (size is 750 kb). When the user opens the workbook a number is generated (+ 1). The workbook is saved to a temp location with the new number and the original workbook is saved and closed (also with the new number). My question is: is it possible to speed up this (now it takes 20-30 sec). The code: 'This code saves the original workbook with the new number: If Me.Saved = False Then Me.Save 'This code saves the temp workbook: FileSaveName = ActiveWorkbook.Path FileSaveNameEnd = FileSaveName & "\Arkiv\" varName = ActiveSheet.Name varDir = FileSaveNameEnd varYear = Format(Date, "yyyy") varNr = ReportNumber ActiveSheet.SaveAs Filename:=varDir & varName & varNr & varYear Can i do something else to speed up the saving process? Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
"Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming |