RE: Locking a worksheet during the reading of it
- From: v-phuang@xxxxxxxxxxxxxxxxxxxx ("Peter Huang" [MSFT])
- Date: Thu, 10 Aug 2006 03:49:21 GMT
Hi Jason,
From your description, it seems that you will have a VSTO 2005 enabledExcel Workbook which will be updated by an external program.
Based on my experience, I did not recommend you do that because Excel works
as a desktop application which did not works smoothly in the multiple user
environment, the external program will be another user.
For your scenario, I would like to recommend you use the Excel RTD feature
which will update the data but not an external program.
289150 HOW TO: Set Up and Use the RTD Function in Excel 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;289150
How To Create a RealTimeData Server for Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;285339
327215 Create a RealTimeData Server for Excel 2002 or later versions with
Visual C++
http://support.microsoft.com/default.aspx?scid=kb;EN-US;327215
Building a Real-Time Data Server in Excel 2002 (Microsoft Excel 2002
Technical Articles)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/h
tml/odc_xlrtdbuild.asp
Best regards,
Peter Huang
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Prev by Date: VBA codename and codeprotection
- Next by Date: Re: What csv standard used by excel?
- Previous by thread: VBA codename and codeprotection
- Next by thread: RE: Locking a worksheet during the reading of it
- Index(es):
Relevant Pages
|
