How To Display Excel Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I display multiple worksheets from a given excel file on a report.

I have displayed bitmap images using the image object. All I needed was to
specify the pathname of the source using vba code and I was able to display
any picture with my data.

I have about 90 small worksheets in one excel file. I want to display a
worksheet that I specify using vba code such that I can control which
worksheet is displayed for a given report page. I tried using an unbound
object frame, and it does show one of the worksheet. I can figure how to
control which worksheet it is displaying.

Any suggestions on this issue?

I am using access 2k

Thank You,

Gary
 
I'd suggest asking this in a newsgroup related to Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.
 
This is an Access Question.

There is a Bound Object Frame. If I put this in a Report, and I could set
SourceDoc = "c:\excel\test.xls"

I could use the SourceItem = "R1C1:R5C5" to control the cells.

How do I indicate which worksheet I want to use???


Gary
 
you can try creating a reference to each of the worksheets and ranges an
assign them a range name. then hyperlink to the range. your question is kind
of vague. the othe possibility is to create a dropdown box using data
verification and then make the target range equal a mirror of the named
range.

to create the names loop through ws like
for each ws in sheets
ws.select
cells(1,1).currentregion.name= ws.name&"_"&cells(1,1).value
next ws

Just Ideas, but again I am not sure of what you are going after.
Carl
 
Back
Top