Linking a Report to Excel Spreadsheet

[Garyrpollitt]

I am trying to create a report linking to 3 sperate named sheets in an Excel Spreadsheet. (Each shee containes a graph) I am using 3 Unbounded Object frames with Source Doc and Source Item pointing to the exact sheets. All I get is the same sheet in all 3 object frames. How do I link to a specific sheet ?

 

[Ally]

Try a command button with:

Private Sub ButtonNm_Click()
On Error GoTo Err_ButtonNm_Click

    Dim x As Integer
    Dim AppName As String

    AppName = "C:\Program Files\Microsoft Office\Office\EXCEL.EXE Path:\... ... ... ExcelFileName.xlw"
    x = Shell(AppName, 6)

Exit_ButtonNm_Click:
    Exit Sub

Err_ButtonNm_Click:
    MsgBox Error$
    Resume Exit_ButtonNm_Click
    
End Sub

 

[Garyrpollitt]

Thanks, but I do not want to open excel, just link to a sheet.How can I specify a sheet to link to. The report has to automatically link to 3 separate sheets called aa,bb,cc and display a graph from each of these sheets in on spreadsheet called "Exercise"