Updating excel from a word file
To link the remaining account balance, begin by selecting cell C22 in Excel and executing a Copy command.Then click in the appropriate location in the Word document and click the arrow below the Paste icon on the Home tab of the Ribbon and choose Paste Special.Either way, selecting the data in Excel, pressing Ctrl C, and then pasting by pressing Ctrl V in Word will do the trick.Excel worksheets often contain moving pictures — they provide snapshots of businesses or projects or data as it changes over time.
Sure, you could type the data into the Word document or you could copy-and-paste it, but these methods require manual updating in Word whenever the data changes in Excel.Depending on what you're capturing in your worksheet, you may want to include the data in your Word document but still have the option to update it in the documnet later.By embedding the data instead of just copying and pasting it, you can open Excel and edit the worksheet information from within Word.File Dialog( _ File Dialog Type:=mso File Dialog Open) bn Excel = False Do Until bn Excel = True With dlg Open . If not, open the file 'also grab the wbk name to enable switching Set obj Excel = Get Object(, "Excel. Go To What:=wd Go To Bookmark, Name:=v Bookmarks(j) Set BMRange = Active Document. Range For k = 1 To UBound(v Names) If v Names(k, 1) = v Bookmarks(j) Then s Sheet = v Names(k, 2) s Range = v Names(k, 3) Exit For End If Next k 'copy data from the range as a picture obj Wbk. ' Under those circumstances the code throws an error. Range Next j Err_Exit: 'clean up Set BMRange = Nothing Set obj Wbk = Nothing obj Excel.