F
FGM
Windows 2000
Office 2002
in one sub I open excel and copy recordsets to different worksheets.
then save the workbook...
Then in the next sub
I want to use the same Excel workbook and create charts. Then I need to
know how to refer to the Sheets
For Each shtNext In Sheets
strSheetName = shtNext.Name
'for only the sheets starting with LN-
If Left(strSheetName, 3) = "LN-" Then
.Sheets(strSheetName).Activate
intRows = Range(Range("A4"), Range("A4").End(xlDown)).Count
intloops = intRows / 6
What is the best way to reopen that workbook and create the charts from
Access?
Do not need to know how to do the chart just how to Set the application to
see the workbook and make that workbook active.
Thanks
Office 2002
in one sub I open excel and copy recordsets to different worksheets.
then save the workbook...
Then in the next sub
I want to use the same Excel workbook and create charts. Then I need to
know how to refer to the Sheets
For Each shtNext In Sheets
strSheetName = shtNext.Name
'for only the sheets starting with LN-
If Left(strSheetName, 3) = "LN-" Then
.Sheets(strSheetName).Activate
intRows = Range(Range("A4"), Range("A4").End(xlDown)).Count
intloops = intRows / 6
What is the best way to reopen that workbook and create the charts from
Access?
Do not need to know how to do the chart just how to Set the application to
see the workbook and make that workbook active.
Thanks