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 - UK
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 - UK