OLE with Excel question.

G

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
 
C

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...
 
S

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 -
Click to expand...

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
 
O

Office_Novice

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