JayPSC

Using VB to access a Excel spreadsheet & return data to another txt file but when I close the Excel sheet down when I've finished with it, I get a dialog box asking if I want to save the sheet, how do I turn this dialog off??
Sure I've done this before but it's been a couple years since I've done any coding & I've forgotten most of what I knew lol.
Jay

rmn

What is VB?

GaryK

I dont use VB6 (spawn of the devil I tell ya!) but have doen OLE automation more with word than excel. You should be able to issue a close command with DoNotSaveChanges parameter.

My code would be:
ovDoNotSaveChanges := wdSaveOptions(wdDoNotSaveChanges);
FWord.ActiveDocument.Close(ovDoNotSaveChanges, EmptyParam, EmptyParam);

I use something called late binding when I do COM so I have to do a little extra coding but if you add the excel type library (in your office folder) via the VB IDE you should get all the commands and more importantly the code completion will give you the correct syntax.

Gary

bob269

something along these lines should work

ActiveWorkbook.Close savechanges:=False

or

Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True

JayPSC

Thank you SN to the rescue again lol