Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-26-2015, 08:48 AM
catflap's Avatar
catflap catflap is offline Refer to cell in embedded Excel object within word Windows XP Refer to cell in embedded Excel object within word Office XP
Advanced Beginner
Refer to cell in embedded Excel object within word
 
Join Date: Aug 2015
Location: UK
Posts: 77
catflap is on a distinguished road
Default

Thanks for responding.

I've tried the fit text thing before - it sounded like what I wanted initially, but unfortunately the result is that word just stretches the text, which can produce some ugly results. What I'm really after is something that will adjust the font size to fit instead, so it doesn't look distorted.

To address your other point, I had envisioned running a mail merge by looping through the document's datasource in vba and printing the current record as I went - not ideal I know, but it would have to be something like that to get the excel cell updated with each record as it looped.

I've been toying with this sort of thing:

Dim objExcel As New Excel.Application
Dim exWb As Excel.Workbook

Set exWb = objExcel.Workbooks.Open("c:\mergesource.xls")
exWb.Sheets("Sheet1").Cells(1, 1) = "Hello there"
MsgBox exWb.Sheets("Sheet1").Cells(1, 1)


This displays the corrected 'Hello there' text in the msgbox, but does not update the excel object in, so it doesn't help unless I can find some way to update or refresh it (the aim being to be able to make use of Excel's ability to re-size the text and then merge to this). I guess this is what you meant when referring to the 'deactivation method'?

I'm starting to get the feeling I'm trying to get Word to do something it just doesn't want to do, and that never seems to lead to a positive result....
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refer to cell in embedded Excel object within word Excel table: refer to a particular row? tinfanide Excel 10 08-05-2015 01:17 PM
Refer to cell in embedded Excel object within word If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) lily Excel 9 10-23-2014 06:21 AM
Refer to cell in embedded Excel object within word Edit embedded Visio object in Word TimTDP Visio 12 01-26-2014 12:43 AM
An embedded object's formatting gets jumbled New Daddy PowerPoint 0 11-17-2013 08:13 PM
Refer to cell in embedded Excel object within word Editing an embedded OLE object DugganSC Word VBA 1 08-29-2011 01:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft