Open an Excel sheet through DDE

[Sajit]

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,

 

[Arvin Meyer [MVP]]

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.

 

[Sajit]

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

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.