OLE with Excel question.
 

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

OLE with Excel question.
 

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

"General Fear" wrote in message
...


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

OLE with Excel question.
 

On Dec 9, 4:21*am, "Corey" wrote:
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...

"General Fear" wrote in message

...





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- Hide quoted text -

- 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:=FilePathOfWorkBookToUpdat e)
c) Use the wkbToUpdate workbook object to update the workbook with the
necessary information

Rob

OLE with Excel question.
 

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

"General Fear" wrote:



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