asked on How to Embed Excel File into Word Document (as an icon) - Getting compile error
'From within Word VBA getting
'Compile error: User-defined type not defined
'on Dim line below:
Sub InsertFile()
Dim objOLE As oleObject
Set objOLE = ActiveSheet.oleObjects.Add
End Sub
'Compile error: User-defined type not defined
'on Dim line below:
Sub InsertFile()
Dim objOLE As oleObject
Set objOLE = ActiveSheet.oleObjects.Add
End Sub
Editors IDEsMicrosoft Word
Last Comment
MariaHalt
ASKER
Almost there...the icon doesn't look like an Excel icon...the path to xlicons.exe seems incomplete.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
The numbers were the same, the path was slightly different...
"C:\Windows\\Installer\{90
Thank you.
"C:\Windows\\Installer\{90
Thank you.
"", LinkToFile:=False, DisplayAsIcon:=True, IconFileName:= _
"C:\WINNT\Installer\\xlico
IconIndex:=1, IconLabel:="Microsoft Excel Worksheet"