<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Hi All<BR>I have listed below a few lines from a StarBasic
macro I am trying to convert<BR>from Excel. This just isn't working and
the "help" files aren't helping very<BR>much. Here what I wrote so
far:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Option Explicit<BR>Dim Cell As Object, Doc As Object, Sheet As
Object<BR>'<BR>'Process New Data<BR>'<BR>Sub
Process_Data()<BR> Dim Date1 As Date<BR>
'Input Date to Process<BR> Date1 = InputBox("Enter Date of
Data Being Processed.")<BR>
Doc=StarDesktop.CurrentComponent 'Not sure this line is
correct-No errors<BR>
Sheet=Doc.Sheets.getByName("New") 'Object error when run from
Basic IDE<BR>
Cell=Sheet.getCellByName("A1") 'Object error
when run from Spreadsheet<BR> Cell.Value = Date1</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>I think the heart of the problem begins on the Doc= line.
I think this is<BR>intended to open the services for the spreadsheet
objects. I found this all<BR>very confusing when reading the various help
files. Does anyone know the correct</FONT></DIV>
<DIV><FONT size=2>syntax for establishing the service to spreadsheet
objects?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks much<BR>George Gammel<BR><A
href="mailto:ggammel1@yahoo.com">ggammel1@yahoo.com</A></FONT></DIV></BODY></HTML>