|
-
Mar 22nd, 2000, 10:20 PM
#6
Thread Starter
Fanatic Member
Judd, I assume you're not talking about the "painting the sheet on the form" bit, so here is the way HDR showed me to edit a new excel sheet (sort of external to VB).
Private xlOut As Excel.Application
Set xlOut = CreateObject("Excel.Application")
' You put in path and file name.
xlOut.Workbooks.Open xlOutPath & xlOutFileName & ".xls"
' If you want to see it, uncomment.
'xlOut.Visible = True
' You put in the name of the worksheet,
xlOut.Worksheets(xlOutWorkSheetName).Activate
' and the row and column.
xlOut.Worksheets(xlOutWorkSheetName).Cells(intOutRow, intOutColumn) = Data
xlOut.ActiveWorkbook.Close SaveChanges:=True
Set xlOut = Nothing
xlOut.Quit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|