Search results for query: *

Linking to the file would not be a solution to my goal to provide a single file package. It is however similar to what I have resorted to which would be providing all three files (Excel, Word, and Presentation template). I'll just have to trust the user to leave them alone. In my Excel...

Having searched extensively yesterday and this morning I have come to the conclusion that the Excel OLE object provides no viable method to extract the object to the file system without activating then manually saving the file from its native application. In my situation this is a non starter...

References: Visual Basic For Applications Microsoft Excel 14.0 Object Library OLE Automation Microsoft Office 14.0 Object Library Microsoft PowerPoint 14.0 Object Library Microsoft Forms 2.0 Object Library Microsoft Word 14.0 Library I am assuming had I not had the Word referece I would have...

Well, ran out of work hours now. Heading home. Resume pissing into the wind in the morning . . .

Yep, do that every time.

A little bit of explanation in case you're interested. A couple of years ago I dveloped an Excel workbook that calculated a set of financial values that drove five data chart sheets in the same workbook. When the user clicked a command button it opened a PowerPoint template and placed the chart...

Failing to activate the OLE object makes it unavailable to the Word document object and the procedure fails. If you know a better way to save an embedded Word object from an Excel workbook I'm all ears(eyes). BTW, just tested that latter piece about closing out the WINWORD.EXE process and it...

Microsoft Excel 2010, "ThisWorkbook" module.

Working in Excel 2010 with an embedded Word Document. I want to export(save) the Word Document Object as a .docx file in the file system folder. The following code does the job but when the object is activated it briefly flashes on the screen. I want to avoid that. Here's a sample of the code...