Recent content by Garyrpollitt

Thanks A, but this will only link to the first sheet or the sheet that had the focus when Excel was saved. I have charts on 3 different sheets, and each Excel spreadsheet is saved as data1.xls,data2.xls,data3.xls etc. Therefore when I open a report I will say I want to see the 3 charts from...

Is there a way to create a report which links to 3 different excel sheets all showing different charts. I can do a hyperlinkm to excel. But I want to open a report with the charts already their

I am inserting data into a table from Excel using .addnew.This is fine if I have a range C1 etc. But I need to import a Excel Picture from a different sheet into my access table. I can activate the sheet, select what I want then copy all in code, but how do I then paste the sheet into an Access...

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"

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...