Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code:
'-------------------------------------------------------- Sub TheCode() Dim j As Integer Dim newfile As String Application.ScreenUpdating = False For j = 1 To 5 Workbooks.Open Filename:="C:\main.xlsm" newfile = "version" & CStr(j) & ".xlsm" ActiveWorkbook.SaveAs Filename:="C:\" & newfile, _ FileFormat:=xlOpenXMLWorkbookMacroEnabled, _ CreateBackup:=False Workbooks(newfile).Sheets(1).Range("A1") = "1" Workbooks(newfile).Save Workbooks(newfile).Close Next j Application.ScreenUpdating = True End Sub '-------------------------------------------------------- This code requires that a blank Excel file named "main.xlsm" exists on the C: drive. The code then creates 5 new files on the C: drive. Does anyone know if this code can be improved or optimized to run faster? Would anybody code this differently? I'm asking for a faster solution because this code seems to run much much slower on Excel 2013, as compared to Excel 2010. Are there any commands here that are inefficient for Excel 2013? Thanx! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
How to determine the optimized correlation between 2 sets of data? | Excel Discussion (Misc queries) | |||
optimized way for copying formats and values | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Question about creating Optimized Excel VBA/Formula Files | Excel Programming |