Excel automation from Access (2000)

[KenReay]

Hi

I have an application which automates Excel from within Access, (via VBA) basically it it creates and saves some spreadsheets.

When I initially create the spread sheet and save it (with oWs.SaveAs ..etc) all is OK, but if I need to re-create an existing spreadsheet and save it with .SaveAs I get a warning message that a file exists. I assumed there would be a oWs.Save method, but no, when I try that I get a compile error (Method not available)

Anyone know how to get around this?

Thanks in advance



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[DougP]

Does the "Save as" file already exist or ??? Which one.

DougP, MCP

 

[GrimmerII]

hmmm try:

appExcel.Application.DisplayAlerts = False

save it and put it back on true again.

Hope this is what you meant

 

[PHV]

The Workbook object expose a Save method, not the Worksheet object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244