![]() |
|
#3
|
|||
|
|||
|
I need vba because it is part of a program to get various information to save the file.
I need to get the info from a particular cell in excel, which I can do, but my code which I have shown below opens the spreadsheet, but I get an error because it is already open. I was pushing the info from excel into content control fields, but I had to move the fields into the header and I cannot find a way to refer to header content controls from excel, it worked fine when they were in the main body of the word document, but cannot see the header ones. Dim exWb As Excel.Workbook Dim objexcel As New Excel.Application Set exWb = objexcel.Workbooks.Open("M:\care plan system\menu forms\office forms menu.xlsm") Dim advisor advisor = exWb.Sheets("menu").Cells(5, 4) ThisDocument.SelectContentControlsByTitle("LAA").I tem.Range.Text = advisor |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
linking word from Excel
|
Lorna B | Word | 1 | 03-22-2012 03:36 PM |
Linking graphs from excel
|
Markc | PowerPoint | 2 | 05-11-2010 02:17 AM |
| Linking Excel to Word | engineer_in_training | Word | 0 | 01-06-2010 01:30 PM |
| Linking Excel Pivot Tables in a Word Document | wmarsh3561 | Word Tables | 0 | 11-17-2009 06:29 AM |
| Linking from Excel to Word | streng | Word | 4 | 10-28-2008 08:23 AM |