Plse could anyone once you have opened an instance of excel with getobject
how do you populate a worksheet

Any advice welcome

Dim xlApp as Object
xlapp = GetObject("Excel.Application")
xlapp.Activesheet.Range("A1:B10").Formula = "=Trunc(rand()*100+1)"

Treat xlapp as the application object you would use within excel itself.

--
Regards,
Tom Ogilvy

Brian wrote in message
...
Plse could anyone once you have opened an instance of excel with getobject
how do you populate a worksheet

Any advice welcome

Brian,

Along the lines of

xlApp.Visible = True
xlApp.Workbooks.Add
xlApp.ActiveWorkbook.Worksheets(1).Range("A1").Val ue = "Bob"


--

HTH

Bob Phillips

"Brian" wrote in message
...
Plse could anyone once you have opened an instance of excel with getobject
how do you populate a worksheet

Any advice welcome

thanks will try it


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

thanks i will try this


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!