AnsweredAssumed Answered

vrf Adding comments in Excel

Question asked by VRFuser on Aug 10, 2005
Thanks Lee,

I was able to get what I needed. 

For anyone else wanting to programmatically add Excel comments with vee
when multiple workbooks or sheets exist, start with the example program
AddComment.vee and modify the line "set range =
xlApp.Workbooks(1).Sheets(1).Range(cell);" so that it references the
index of the desired open workbook and sheet (indices begin with 1).
You can use the Excel > Enumerate functions to establish the correct
references to workbooks and sheets programmatically. 

If your Excel workbook is already open, just remove the OpenWorkbook
function from the example for it to work.

-----Original Message-----
From: HUDSON,LEE (Non-A-Lumileds,ex1) [mailto:lee.hudson@lumileds.com]
Sent: Tuesday, August 09, 2005 1:42 PM
To: VRF
Subject: RE: [vrf] Adding comments in Excel

Hi Chule,

Take a look at the attached program; it seems to work fine. I'm using
VEE Pro 7.51 operating on Windows2000.  If you have a problem it might
be due to having an instance of Excel already running before you start
this program.  Go into the task manager -> Processes tab -> select any
instance of "Excel.exe" and click on the End Task button; then try
running this program.

Regards.
Lee

Lee Hudson, R&D Scientist
LumiLeds Lighting, U.S., LLC
370 West Trimble Road, MS 91ML
San Jose, CA 95131
(408) 435-5834
(408) 435-6574 FAX
lee.hudson@lumileds.com
http://www.lumileds.com <http://www.lumileds.com> http://www.luxeon.com
<http://www.luxeon.com>


-----Original Message-----
From: Chule Walker [mailto:CWalker@rfmd.com]
Sent: Monday, August 08, 2005 11:00 AM
To: VRF
Subject: [vrf] Adding comments in Excel

I have tried using the Vee 7.5 example program AddComment.vee but I want
to add multiple comments to an existing open workbook.  This program
warns about doing this with previously open workbooks but has anyone a
fix for this?  The "set range =
xlApp.Workbooks(1).Sheets(1).Range(cell);" line is the key but I can't
get it work. 

Thanks in advance,

Chule

---
You are currently subscribed to vrf as: lee.hudson@lumileds.com To
subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to
"leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: CWalker@rfmd.com To subscribe
send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to
"leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".


---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes