Open an Excel sheet through DDE

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

Guest

I am trying to do a work around for a problem in Access 2003.

Access Unbound OLE frames can be linked to an Excel sheet.

The properties that direct the frame to a specific sheet is through the
following properties of the frame.


Source Doc : C:\sajit\test1.xls
Source Item : test2

where, test2 is the sheet name in the Excel file.

However I notice that it does not work. What Access does is, it selects the
Excel sheet that was last selected and saved.

I want to write a piece of code using perhaps DDE to open the Excel file and
select the specific sheet that I want the OLE to link to, save and close.

Can anyone please show me how to get to that.

Thanks,
 
You can link and Excel sheet to Access as a table, then use a datasheet form
or subform to view/update it. It is unnecessary to add the complexity of
using the OLE frame.
 
I want to modify the row height in the Excel file from Access, based on the
length of the text in the Access recordset. Not the data on the Excel file.

--
Sajit
Abu Dhabi


Arvin Meyer said:
You can link and Excel sheet to Access as a table, then use a datasheet form
or subform to view/update it. It is unnecessary to add the complexity of
using the OLE frame.
Click to expand...
 
Back
Top