ole

I've got a control macro in Excel VBA that opens a database in Access, runs an Access macro, then closes the DB, before carrying on with Excel and running off a load of reports. Dim A As Object Set A = CreateObject("Access.Application") A.Visible = False A.OpenCurrentDatabase...

Hey again folks, Having a bit of an issue with an array (MyResult). Each "line", as it were, has five "columns", formatted differently (got some doubles and some strings). When I write the array using: .Range(.Cells(1, 1), .Cells(UBound(MyResult), UBound(MyCodes))).Value = MyResult Some of...

Hello everyone! I've just started playing with importing data into excel from an access database using Data / From Access / and then selecting a table. I can even edit the query by right on the data returned, clicking on Table, Edit Query and playing with the command text. So - my OLE DB...

On my PC I have no problem starting Excel, opening two files that are linked and seeing the destination file change instantly when I update the source file. However, if instead I start two Excel applications and open only one file in each the link does not work. For instance If I add a test...

Greetings, I am currently using automation to insert an excel 2007 file into a Word 2007 document using VB 6. My goal is to make the OLE window show the entire excel document (which has a chart along with cells that contain header information) in the word document. Currently, when I call...

I need code to tell me if my excel workbook has any embedded files (embedded such that I can not view unless I dbl click on the icon). Where might I find such code? :confused: Much appriciated

I have many Excel workbooks, which have embedded word objects. My goal is to write something in VBA that would save the word object as a BLOB in an Access database. Another procedure would retrieve the BLOB from the database and insert it into the Excel workbook as a new OLE Object. I can...