Change Excel row height from Access

By sxviswan ·
How can I change the row height of Excel rows from Access. I need to do this for an Excel sheet that I am using as a back drop for an Access report. Based on the text length in the Access report. There will be instances where the text box control have to grow. When that happens I want the 'back drop' Excel sheet rows to increase in height by the same amount to keep it place.

My search tells me that I can do this by DDE. However the syntax does not seem to work for me. Is there something that I should be doing prior to this, such as setting a refernce, befor the VBA code can work.

Please help.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums