| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
