Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Macro locks me in a single XLS file

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Excel file locks up all memory resources, accesses externalfile? [email protected] Excel Discussion (Misc queries) 4 December 21st 07 11:01 PM
Save a single worksheet in Excel as a single file. Dakota New Users to Excel 4 February 22nd 06 04:46 PM
calc locks up after running a macro that moves sheets to a new fil shibao Excel Discussion (Misc queries) 0 November 7th 05 10:58 PM
file "save as" to floppy locks up Commodore Excel Discussion (Misc queries) 4 September 16th 05 10:17 AM
Excel data query locks source file jim.bahr Excel Discussion (Misc queries) 0 June 10th 05 05:48 AM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"