Link/Embed spreadsheet

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

Guest

I want to avoid storing the spreadsheet in the tabel but operate in a similar way to the image object i.e. bind it to a text frield which in turn is bound to a field on the table containing the address of the spreadsheet
e.g.
txtBox bound to Field2 in tblSpreadshee
Field2 contains
C:\test1.xls in the first recor
c:\test2.xls in the seconf recor
etc
The report would have a control similar to an image that is bound to txtBox
txtBox is hidden so that the address does not display on the repor
All works fine if I use and image control to display .bmp or.gif but will not work for .xl
Any Ideas

Thank
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the "Bound Object Frame" control. On the toolbar it has XYZ on
the top border and what looks like a tree, horizon & sun. When you
click it & put it on the report a wizard appears & asks you all
questions necessary to create a link to the s/s.

To change the location of the s/s file you'll have to change the
control's Source Document property. This may be done by putting a
reference to the TextBox (your Field2) that holds the path to the
Excel file (untested). If that doesn't work you'll probably have to
create a VBA routine that updates the SourceDocument property.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDt9RYechKqOuFEgEQJCNgCcC7Ym1WW2SDMmv2w8FhHgs7EVtTcAoIH2
4o4m/g5SVPCtPJ0lQTAVBp5G
=/7r7
-----END PGP SIGNATURE-----
 
Back
Top