another excel prob!!!!

**nswan** · Mar 7th, 2001, 11:28 AM

I have managed to open excel through VB 6, managed to select cells. Now I need to save it!! When I try to do it, it comes up with the save changes box. Can I automatically set this to yes?

Nick

**xhomerx** · Mar 7th, 2001, 11:42 AM

Application.DisplayAlerts = False

**nswan** · Mar 7th, 2001, 11:48 AM

application.saveworkbook come up with an error saying you can't save it under the same name as it was opened!!!!

**nswan** · Mar 8th, 2001, 03:41 AM

can anyone help????

**TheOnly** · Mar 8th, 2001, 09:06 AM

Hi nswan !!!

to save a already saved workbook use

Code:

objExcel.workbooks("myworkbook").save

to save a new one

Code:

'avoid any still exist message and filesavas
popups
objexcel.displayalerts = false
'save the workbook
objExcel.workbooks("myworkbook").saveas "c:\temp\hugo.xls"

-cu TheOnly

**nswan** · Mar 8th, 2001, 09:20 AM

i'll love you forever. just when i had given up all hope as well!

Thanks
Nick

**atif** · Mar 8th, 2001, 10:16 AM

Code:

Application.SaveChanges = True

OR IF YOU WANNA CLOSE IT AFTER SAVING IT THEN

Code:

ActiveWindow.Close savechanges:=True

**Dmack** · Mar 8th, 2001, 10:36 AM

activewindow.close(1)

Thread: another excel prob!!!!

Thread Tools

Display

OR......

Posting Permissions