View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Snedker[_2_] Snedker[_2_] is offline
external usenet poster
 
Posts: 5
Default More help on closing Excel.Application

Okay - it seems I haven't explained myself properly, so:

Would someone show me a VBA example of:

1.
Open "C:\mywork.xls" using the Excel.Appliction object

2.
Enter "Hello World" into cell A1

3.
Releasing connections to the open xls-file, but leaving it open for
further work.

4.
The code should be able to be re-run an infinite number of times, each
time opening "C:\mywork.xls" in a new instance of Excel.


Help greatly appreciated! Thx in advance.

/Snedker