Add Data Without opening workbook

[pgjoshi]

I want to add, modify the data in a Data workbook from other workboo
without opening the Data Workbook. The size of Data workbook is more.
know the hide command but I don't want to open the data file. But
want to be able to give any command to data workbook through VBA
Please guide me.

Prasad Josh

 

[Frank Kabel]

Hi
don't think this is possible. Though you can read (with some effort)
data from a closed workbook within VBA writing to a closed workbook is
a different thing
So I'd open the workbook (and hide the output)

 

[onedaywhen]

You can query a (closed) Excel workbook as a Jet data source using sql
via ADO, assuming it is set out in 'database' form i.e. rows of
columns, preferably with column headings.

Supported Jet SQL syntax:

UPDATE: amend non-formula cells
INSERT INTO: append row to a table (adds row to bottom of the Range)
DELETE: not supported
INSERT INTO..SELECT: copy data between tables (Ranges)
SELECT..INTO: copy data to new table (Worksheet)

--