OLE with Excel question.

[General Fear]

I had the following goal. The end user will enter numbers into one
spreadsheet. But when they close it, I want to take number they typed
in and put it into another spreadsheet.

The trick is that I do not want to show the recieving spreadsheet on
the screen. Basically, the spreadsheet that is going to be updated
needs to be hidden from the end user.

I believe that I did this once but for the life of me I can't remember
how.

Regards

 

[Corey]

To made the updating NOT visible to the user use the :
Application.Screenupdating = False

Remmember to turn it back on at the end of the procedure too.


Corey...

 

[signon77]

To made the updating NOT visible to the user use the :
Application.Screenupdating = False

Remmember to turn it back on at the end of the procedure too.

Corey...











- Show quoted text -

General Fear,

I suggest you do the following:

a) Create a Workbook_BeforeClose event procedure.
b) In the new event procedure, code something like: set wkbToUpdate =
Workbooks.Open(filename:=FilePathOfWorkBookToUpdate)
c) Use the wkbToUpdate workbook object to update the workbook with the
necessary information

Rob

 

[Office_Novice]

Seach Excel Help File for
Create a link to another cell, workbook, or program