Question Locked

How to read an Excel file without opening the file

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I would like to know how to read a set of data in an Excel file, either with the PC or via LAN, without opening the Excel file using Excel VBA programming.
No writing is required.

Next question: Is it possible to write a data into Excel file without opening the file?

Please advise anyone.

Roy

2 replies

by calljamestan

What you can do is open Excel using Getobject/Createobject DDE functions.
These will let you open the file without displaying the Excel GUI.

Does this meet your needs.

This discussion is closed to new replies.