Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would just start a new instance of Excel and then do file=Open and open
the file I want. -- Regards, Tom Ogilvy "Luca T." wrote in message ... Tom Ogilvy wrote: Do you activate any windows or workbooks or worksheets in your macro? Hmmm no... what do you mean with "activate"? I only do stuff like what you did in the example below. Sub Runme() Dim i As Long Do For i = 1 To 1000 ThisWorkbook.Worksheets(1).Range("A5") = Rnd() DoEvents Next For i = 1 To 10000 DoEvents Next i Loop While True End Sub Unfortunately my Macro cannot always be in the doevents loop. :( Is there a way to open every XLS file with its own Excel instead than with one Excel as it is doing by default? Thanx, Luca |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Excel file locks up all memory resources, accesses externalfile? | Excel Discussion (Misc queries) | |||
Save a single worksheet in Excel as a single file. | New Users to Excel | |||
calc locks up after running a macro that moves sheets to a new fil | Excel Discussion (Misc queries) | |||
file "save as" to floppy locks up | Excel Discussion (Misc queries) | |||
Excel data query locks source file | Excel Discussion (Misc queries) |