VBA project not allowing existing excel sessions to open
Workbooks that are opened prior to launching VBA project are not accessible while VBA Project is being used, another Excel session can be opened after VBA Project is launched which provides full excel functionality. What should I do how can user use the existing excel sessions which are opened prior to launching VBA Project. Please Help!
Last edited by harry_1805; 02-23-2012 at 09:47 AM.
Cross posted here.
Good luck.
yes I wanted answer for this question, is it ok to do it?
Please help me if you have a answer.
Please read the forum rules, specifically rule 8.
Iam sorry I haven't read this rule Thanks you have already provided with the link. Will do the same in that forum too. Let me know if you can give me a answer for this issue, how can i resolve this.
I don't understand your question. I suspect you mean Excel workbooks rather than Excel sessions, because sessions are completely independent of each other.
yes excel workbooks, which is already opened, but iam unable to open them again if the VBA project is running.
Why would you open them again if they are open?
For example, I have three excel files excel1, excel2 and excel3 opened and I have a VBA code excel which is project1 opened just now. If I run project1 vba code, I cannot move back to excel1 or excel2 or excel3 if I have to check for some data. VBA screen doesn't allow me to move back to those opened excel files. Where as if I open another excel from windows Start-> MS office-> MS Excel, then it works well.. Hope you understood what i meant.
to be more specific, I have a form in VBA and when its running, I cannot go back to the excel files which are opened in background, i cannot access them.
You have to either run the form modelessly or add functionality to it to switch between open workbooks.
ok, which property should I change to make the form run modelessly or what functionality should i use to switch between open workbooks?
yeah done, now excel workbook opens but still it shows the form over the excel workbook.
If you don't want that, you'll have to hide the form (or resize it so it's not in the way)
is there a way to minimize the form as per users discretion like we have on web brower.
With a load of API calls, yes.
See attached demo.
Last edited by OnErrorGoto0; 02-23-2012 at 08:17 AM.
ok how to unable that?
I've just added a demo file to my last post.
Thanks a lot buddy, its works really well. Thanks for help me out again, you have been awesome!
Glad to help.
Please don't forget to mark the thread solved (see the FAQ link at the top of the page).
Re: VBA project not allowing existing excel sessions to open
Sure will do that, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks