Your question, your audience. Choose who sees your identity—and your question—with question security.
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
Join the community of 500,000 technology professionals and ask your questions.