Results 1 to 4 of 4
  1. #1
    accrep18 is offline Novice
    Windows 10 Access 2007
    Join Date
    Mar 2018
    Posts
    11

    Question specifying specific Excel chart to display

    I have a Report that contains several Bound Object Frames, each of which I would like to use to display a certain Chart from a single Excel file.

    The Excel file contains these charts, each on their own worksheet.


    On the Report, in Form View, I use Insert Object and click Create from File...but it doesn't allow me to specify which worksheet to display...




    How can I select the specifc worksheet ?


    Thanks !

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See this thread for possible method.

    Found another example"
    Code:
           
    
      This code imports from a sheet named "temp" in a workbook named "temp.xls", and stores the data in a table named "tblFromExcel".
      Dim strXls As String
    strXls = CurrentProject.Path & Chr(92) & "temp.xls"
    DoCmd.TransferSpreadsheet acImport, , "tblFromExcel", _
        strXls, True, "temp!"

  3. #3
    accrep18 is offline Novice
    Windows 10 Access 2007
    Join Date
    Mar 2018
    Posts
    11
    Sorry - I'm using a Form, not a Report.... not sure if that changes the situation.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    The code I showed should get you the worksheet from the workbook.
    Your own logic/program would manipulate the data/chart.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 05-18-2016, 03:32 PM
  2. Replies: 11
    Last Post: 12-25-2015, 02:41 PM
  3. Replies: 3
    Last Post: 08-13-2015, 07:06 PM
  4. Replies: 2
    Last Post: 04-06-2015, 12:08 PM
  5. Replies: 1
    Last Post: 11-20-2014, 08:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums