If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How set up exce workbookl to run from a server?
I have a spread sheet that I want to load to my ISP so I can open and edit
it on line. (Simply want to click on a link and have the file open) |
#2
|
|||
|
|||
How set up exce workbookl to run from a server?
Hi JEM,
SUMMARY This step-by-step article discusses the new functionality that the RealTimeData (RTD) function provides. Microsoft Excel 2002 provides a new worksheet function, RealTimeData (RTD), which allows you to call a Component Object Model (COM) Automation server for the purpose of retrieving data in real time. When you need to create a workbook that includes data that is updated in real time -- for example, financial or scientific data -- you can now use the RTD worksheet function. In earlier versions of Excel, Dynamic Data Exchange (DDE) is used for that purpose. However, the RTD function, which is based on COM technology, provides advantages in terms of robustness, reliability, and convenience. RTD depends on the availability of an RTD server to make the real-time data available to Excel. For more information about how to create an RTD server, see the "References" section of this article. The RTD function retrieves data from an RTD server for use in the workbook. The function result is updated whenever new data becomes available from the server and the workbook is able to accept it. The server waits until Excel is idle before updating, which relieves the developer of having to determine whether Excel is available to accept updates. The RTD function differs from other functions in this regard, because other functions are updated only when the worksheet is recalculated. Although the RTD function provides a link to data on a server, it is not the same type of link as references to cells in other worksheets or workbooks. For example, if you use the RTD function in a workbook, you do not receive the Links startup message when you open the workbook, nor can you manage the status of an RTD function through the Edit Links dialog box. HOW TO: Set Up and Use the RTD Function in Excel 2002 Microsoft Knowledge Base Article - 289150 http://support.microsoft.com/default...b;en-us;289150 HOWTO: Automate Microsoft Excel from Visual Basic Microsoft Knowledge Base Article - 219151 http://support.microsoft.com/default...b;en-us;219151 Please let me know has this helped You... Thank You... Raghu... This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|