use excel while VBA form is running

[niteshseth]

Hi Group ,

I need a Help regarding Working with other Excel files while user form is running.
when i am running a user form , it cant view my attachments directly from Ecel . i have to detach and then view it which is a long process...

can anyone please help me, my mail id is niteshseth@yahoo.com

Thanks
Nitesh

[geekgirlau]

Basically you won't be able to do anything else in that session of Excel while the user form is running. Keep in mind that generally a macro will be manipulating 1 or more Excel workbooks, so you opening another workbook in the middle of this processing will cause errors. As a result, you can't open a workbook in that session of Excel until the macro is finished.

This won't stop you from opening another session of Excel and working there. I'm not sure how you'll go with an attachment, but try opening another session of Excel and then opening the attachment.