MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Open another spreadsheet while a form is open

  Asked By: Mada    Date: Nov 29    Category: MS Office    Views: 2530

I have a spreadsheet in which I have used the line
"Application.visible = False" so I can hide the workbook and just use
forms to enter data (not sure if this has any relevance to my problem
but though I had better mention it).

I also have another program (accounting package) which (when pressing
CTRL & F8) opens a new Excel workbook and dumps data into it.

I then want to use a form in the first spreadsheet to extract data
from the new spreadsheet.

I have no problems writing the VBA code to extract the data, I can
successfully run it from the VBA editor to extract the data. The
problem is, with the Form open, I can not open the second spreadsheet.
Only when I have quit the form can I open a new spreadsheet.

Is there a way around this?



1 Answer Found

Answer #1    Answered By: Alvin Nguyen     Answered On: Nov 29

Two possible problems  here.

Firstly, the non-visible application would mean that you wouldn't be able to
see the new workbook  even if you could open  it. (I think.)

Secondly, the active form  has locked excel  (the spreadsheet  engine) while it
is active. To open another spreadsheet, you need to open another instance
of Excel. (I suspect this one is your major problem - I've seen it

Didn't find what you were looking for? Find more on Open another spreadsheet while a form is open Or get search suggestion and latest updates.