Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() This code works for ~20 sets of excel workbooks. ONE of the sets (a single workbook) always crashes the workbook, with a request to contact MS with the error report. The last crash gave me a DDE server crash error. Is there any thing in the sheet that would cause this? For i = 1 To rsMaster.RecordCount 'Set xl(i) = New Excel.Application 'Early binding Set xl(i) = CreateObject("Excel.Application") 'Late Binding With xl(i) If admin Then 'hide from user? .Visible = True Else .Visible = False End If .Application.WindowState = xlMinimized .Application.DisplayAlerts = False .Workbooks.Open FileName:=(pathExcel & rsMaster!Source), UpdateLinks:=0, ReadOnly:=False End With rsMaster.MoveNext Next i '...much work done Set rsLbl = xl(i).Application.Run("getRs", rsLbl) 'call Excel Function '...much work done 'now end For Each x In xl() x.ActiveWorkbook.Saved = True x.Quit Set x = Nothing Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expiring/Killing Macro(s) | Excel Discussion (Misc queries) | |||
Finding and killing all Access queries in an Excel spreadsheet | Links and Linking in Excel | |||
VBA loop is killing me! | Excel Discussion (Misc queries) | |||
Killing the split window | Setting up and Configuration of Excel | |||
Killing Excel :) | Excel Programming |