Ready to get started with anonymous questions today? It's easy! Learn more.
With dtb '.Visible = True ' Enable control. '.Enabled = True ' Set Locked property to False. '.Locked = False ' Allow embedded objects only. '.OLETypeAllowed = acOLEEmbedded ' Specify the OLE server and the type of object. '.Class = "Excel.Chart.8" ' Specify the file to be embedded. '.SourceDoc = "G:\000_Supply Chain\Procurement-Corporate\Spend Management\Spend Management 7-19-2010.xlsx" ' Specify the Worksheet Item '.SourceItem = "Direct - Charts![Spend Management 7-19-2010.xlsx].Chart 35" ' Create the embedded object. '.Action = acOLECreateEmbed ' End With
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.