A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How set up exce workbookl to run from a server?



 
 
Thread Tools Display Modes
  #1  
Old June 13th, 2004, 03:05 AM
JEM
external usenet poster
 
Posts: n/a
Default 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  
Old June 15th, 2004, 02:23 AM
Raghu Prakash
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.