Hi I have some text code below which runs on clicking a
button on a form in VB6.

However, the user is prompted to save the file on the
interface.

I want to save the file and have no save message
displayed. How do I do this?

#############################

Dim xlsApp As excel.Application          
Set xlsApp = excel.Application

With xlsApp
   '.Visible = True
   .Workbooks.Open ("C:\Test.xls")
   .Range("A1").Value = "Cell1"
   .Range("B1").Value = "Cell2"

End With

xlsApp.Workbooks.Close
xlsApp.Quit
######################

16 Jun 2003 04:45:15 -0700 bearing the following fruit:

Please do not multipost, this has already been answered.
The answer would have appeared here if you had crossposted.

J

--
If you have a lot of tension and you get a headache,
do what it says on the aspirin bottle:
Take two and keep away from children.  (Barbie Jo)

[Abolish the TV Licence - http://www.tvlicensing.biz/]