Entering data to a spreadsheet without opening it

T

thereuare

Board Regular

Joined

May 28, 2002

Messages

232

• Dec 23, 2002

• #2

Turn off on-screen updating?

 

Upvote 0

Richie(UK)

MrExcel MVP

Joined

May 17, 2002

Messages

3,329

• Dec 23, 2002

• #3

Hi brett,

Although there are methods for reading from closed workbooks, I don't believe that it is possible to write to a closed workbook. The best option, which appears to be what you are alreay doing, is to switch off screenupdating, open the workbook, do whatever needs doing, save and close, switch screenupdating back on again.

Let us know if you come up with an alternative! :wink:

 

Upvote 0

D

dk

MrExcel MVP

Joined

Feb 15, 2002

Messages

2,942

• Dec 23, 2002

• #4

Hi,

One way of writing data to a workbook without opening it is to use ADO (ActiveX Data Objects). Check this recent post for one example:-

http://www.mrexcel.com/board/viewtopic.php?topic=33766&forum=2&2

and here:-

http://support.microsoft.com/default.aspx?scid=KB;en-us;q278973

 

Upvote 0

S

syed_mushraf

Active Member

Joined

Oct 13, 2002

Messages

265

• Dec 23, 2002

• #5

hi, from where we can get screen on-off. plz explain thnkx

 

Upvote 0