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;

You are currently subscribed to vrf as:
To subscribe send a blank email to "".
To unsubscribe send a blank email to "".
To send messages to this mailing list,  email "". 
If you need help with the mailing list send a message to "".