AnsweredAssumed Answered

vrf Tables in Access

Question asked by VRFuser on Nov 7, 2004
> The problem I am having is that I can not 'read' the information
> that is in an activate cell, in either of the two methods detailed
> in the vee examples,

Well there's really nothing to it at all. You just set a variable equal to
the active cell. It's usually much more efficient to transfer an entire
range though, so as to avoid multiple IDispatch invocations.

// Get a worksheet.
Set app = CreateObject("Excel.Application");
Set wbk = app.Workbooks.Add;
Set wks = wbk.Worksheets.Add;

// Set some stuff.
app.ActiveCell = "This is text.";
app.ActiveCell.Offset(1, 0).Activate;
app.ActiveCell = 1.2;

// Get some stuff.
stuff = app.Range("A1:A2");
// Or just the active cell.
stuff2 = app.ActiveCell;

// Quit.
app.Visible = True;
app.DisplayAlerts = False;
app.Quit();
-SHAWN-


---
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