Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Excel Processes
Hey all,
I'm doing some pretty heavy Excel automation from within Access 2000. As part of what I do, I scan through multiple Excel files within a folder (as many as 500) and read some values. Everything works the way I want it to....however, I find that I can't open any other Excel sheets while this process is running. Ordinarily, all the workbook opening occurs invisibly - I have objXL.Visible = False. However, if I open another Excel file (unrelated to the automated app), suddenly I see all those files from the folder being opened for a second, then closed again. That would be acceptible, I suppose, if the application didn't give these opening sheets the focus. I guess my question is, is there some way I can use other Excel files in a somewhat normal fashion, while this import is running in the background? -- Hmm...they have the Internet on COMPUTERS now! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Excel Processes
just a guess.... but try putting
DoEvents just before you start the process of reading the excel files in yo code manges -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Excel Processes
have you tried starting another instance of excel and then opening the file?
Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "MDW" wrote in message ... Hey all, I'm doing some pretty heavy Excel automation from within Access 2000. As part of what I do, I scan through multiple Excel files within a folder (as many as 500) and read some values. Everything works the way I want it to....however, I find that I can't open any other Excel sheets while this process is running. Ordinarily, all the workbook opening occurs invisibly - I have objXL.Visible = False. However, if I open another Excel file (unrelated to the automated app), suddenly I see all those files from the folder being opened for a second, then closed again. That would be acceptible, I suppose, if the application didn't give these opening sheets the focus. I guess my question is, is there some way I can use other Excel files in a somewhat normal fashion, while this import is running in the background? -- Hmm...they have the Internet on COMPUTERS now! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
Processes in one cell | Excel Discussion (Misc queries) | |||
Preserving Text Only despite Excel's # Recognition Processes | Excel Discussion (Misc queries) | |||
hiding processes | Excel Programming |