button for saving all workbooks
in [Programming]
|
Prev: Find and replace
Next: Type Mismatch Error
From: USH on 17 May 2010 11:01 hello ! anybody anybody knows that excel has a "SAVE" button with a Floppy icon, int the File Menu.. when you press this button you save the current workbook.. What if i have to save all open workbooks ??? tx !! paolo
From: JLGWhiz on 17 May 2010 18:03 same button. "USH" <USH(a)discussions.microsoft.com> wrote in message news:4AB6F206-E52F-4B41-8516-097168D0E3B4(a)microsoft.com... > hello ! > anybody anybody knows that excel > has a "SAVE" button with a Floppy icon, > int the File Menu.. > > when you press this button you save the current workbook.. > > What if i have to save all open workbooks ??? > > tx !! > paolo
From: USH on 18 May 2010 08:49 maybe its a lot of open workbooks !! and for some special reason i cant use autosave.. "JLGWhiz" wrote: > same button. > > > "USH" <USH(a)discussions.microsoft.com> wrote in message > news:4AB6F206-E52F-4B41-8516-097168D0E3B4(a)microsoft.com... > > hello ! > > anybody anybody knows that excel > > has a "SAVE" button with a Floppy icon, > > int the File Menu.. > > > > when you press this button you save the current workbook.. > > > > What if i have to save all open workbooks ??? > > > > tx !! > > paolo > > > . >
From: JLGWhiz on 18 May 2010 09:48 Maybe this will help: http://www.dummies.com/how-to/content/how-to-save-files-in-windows-xp.html "USH" <USH(a)discussions.microsoft.com> wrote in message news:9FC761E0-C4EE-45D6-AF4C-451EED81B7F2(a)microsoft.com... > maybe its a lot of open workbooks !! > and for some special reason i cant use autosave.. > > > > > "JLGWhiz" wrote: > >> same button. >> >> >> "USH" <USH(a)discussions.microsoft.com> wrote in message >> news:4AB6F206-E52F-4B41-8516-097168D0E3B4(a)microsoft.com... >> > hello ! >> > anybody anybody knows that excel >> > has a "SAVE" button with a Floppy icon, >> > int the File Menu.. >> > >> > when you press this button you save the current workbook.. >> > >> > What if i have to save all open workbooks ??? >> > >> > tx !! >> > paolo >> >> >> . >>
From: Gord Dibben on 18 May 2010 13:55
Don't know what autosave has to do with it but add this macro to your Personal.xls NOTE: will save all open workbooks without asking "do you want to save?" Sub saveall() Dim wb As Workbook Application.DisplayAlerts = False For Each wb In Application.Workbooks wb.Save Next Application.DisplayAlerts = True End Sub Gord Dibben MS Excel MVP On Tue, 18 May 2010 05:49:01 -0700, USH <USH(a)discussions.microsoft.com> wrote: >maybe its a lot of open workbooks !! >and for some special reason i cant use autosave.. > > > > >"JLGWhiz" wrote: > >> same button. >> >> >> "USH" <USH(a)discussions.microsoft.com> wrote in message >> news:4AB6F206-E52F-4B41-8516-097168D0E3B4(a)microsoft.com... >> > hello ! >> > anybody anybody knows that excel >> > has a "SAVE" button with a Floppy icon, >> > int the File Menu.. >> > >> > when you press this button you save the current workbook.. >> > >> > What if i have to save all open workbooks ??? >> > >> > tx !! >> > paolo >> >> >> . >> |