I am trying to create a custom Excel export macro that will create a spreadsheet of multiple data charts as well as a corporate logo. I can easily get the data tables exported into the right spots on the Excel but so far all of my macros have been failing when trying to copy out the text box. I'm pasting a code snip below...
'Export Logo
set MyTable = ActiveDocument.GetSheetObject("RTK_LOGO")
set XLSheet = XLDoc.Worksheets(1)
Mytable.CopyBitmapToClipboard true
XLSheet.Paste XLSheet.Range("A1")
I've confirmed the text box I want is properly named as above.
Thoughts on how I can make this happen?