files names under a process - vb.net 2008
-
Hi, I opened ten excel files, and all files are coming under one process in the task manager. Is there any option to find all the excel file names which are lying in this excel process? Thanks
-
Hi, I opened ten excel files, and all files are coming under one process in the task manager. Is there any option to find all the excel file names which are lying in this excel process? Thanks
Perhaps if you use the interop stuff to interact with Excel directly.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
-
Hi, I opened ten excel files, and all files are coming under one process in the task manager. Is there any option to find all the excel file names which are lying in this excel process? Thanks
You're going to have to use Office Interop to get the list of opened workbooks from Excel.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
You're going to have to use Office Interop to get the list of opened workbooks from Excel.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008can u provide some sample code to process it?
-
Hi, I opened ten excel files, and all files are coming under one process in the task manager. Is there any option to find all the excel file names which are lying in this excel process? Thanks
Set
IgnoreRemoteRequetsto True to force excel to open a new instance of excel.exe for each workbook, this may cause undesired behavior and may cause links to not work. Save your sheet when you setignoreremoterequeststo true. This will prevent all worksheets opened programtically when a user opens a workbook from his desktop.