Editing Existing Excel File, Without Opening Excel

[kbdavis]

I have a (non-MS office) VBA project I am currently working on, and currently, in this project, I have set Excel as an object, where the current Excel file I am using needs to be currently opened. I have seen a method using:

Please Login or Register  to view this content.

that may allow me to do what I am needing to be done, however, I can honestly say I have used this before.

So, very briefly if anyone could assist me, here are the exact steps I need to happen and maybe someone could point me in the right direction...

Lets start by saying the Excel file I need is: C:\User\ExcelFile.xlsx

1. Excel starts from A1 then goes down the column until it finds the next empty cell
2. Value of this empty cell = iVal1
3. Same row, now column B = iVal2
4. Same row, Column C = iVal3
5. Same row, Column D = iVal4

So I believe the way I use the Open function is:

Please Login or Register  to view this content.

but once it's opened as #1, how do I manipulate the values as described in the above list?

And a quick note... Keep in mind I am not using Excel to manipulate this Excel File. So I currently have this function in a module:

Please Login or Register  to view this content.

however, there is no guarantee I will even have Excel open at all, so instead of GetObject, I will probably need to CreateObject instead - but if you assist in the matter if you could kindly implement the object appXL where necessary I would be extremely grateful (I'm okay with a With appXL statement as well btw)!

[Leith Ross]

Hello kbdavis,

Opening an Excel workbook using the Open statement will not work for editing Excel files with xlsx or xlsm extensions. The newer files are zipped XML files. Excel files with an xls extension are in Binary Information File Format (BIFF). Even if your version of VBA supports ADO objects, you will be able to read but not change the file data.