VBA to saveall & close all

[amb2301]

Hi Friends,
i need a VBA to save all (word,excel,powerpoint,notepad) & close all at once,
Requesting VBA legends to help me on this, as it is urgent.

Thanks in Advance.

[kev_]

Welcome to the forum
Why is it urgent?
You already have a workaround....

[kev_]

Try this for Powerpoint, Word & Excel
- you may need to modify the code if you usually have multiple instances of applications open

VBA goes in Excel:

Please Login or Register  to view this content.

REfs.jpg

[amb2301]

Hi Kev,
Its working perfectly, thank you so much for your help !!!

But the problem is here in some of the systems, we don't have access to TOOLS-REFERENCES(it was grayed out), so is there any alternative codes to make it work on remaining systems also?


Thanks Again for your help

[kev_]

References may be greyed out because running the macro without the references would cause a VBA error which (in turn) results in option being greyed out.(references option is always greyed out in error debug mode).
If so, the option should become available after resetting.

Are you pasting the code into different files? Try sharing a common file which already has the relevant references.

[amb2301]

hi kev,
In some of the computers we dont have the access for TOOL---REFERENCES options ....actually it is hidden, its not in debug mode.
anyway thank you so much for your reply & help

[kev_]

One way to solve this problem is to use a separate file containing application-specific VBA only.
Word and Powerpoint files should already contain the references needed for their own VBA

The code needs modifying slightly:

Please Login or Register  to view this content.

[amb2301]

Hi Kev,
Thank you so much for your reply,
so can i save the programs separately for word,powerpoint & excel, then call each program one by one ,
so that will it happen?

Thanks.

[xlnitwit]

If you make two small changes to the declaration, the references are unnecessary- the code is mostly late bound anyway

Please Login or Register  to view this content.

[amb2301]

If you make two small changes to the declaration, the references are unnecessary- the code is mostly late bound anyway

Please Login or Register  to view this content.

Hi xlnitwit,
Its an awesome work done by you....Thank you so much for your Help!!!

Can you please help me in adding following things with that ..
1. if some read only files available (excel,word,powerpoint ) has to be cancelled without saving.
2. if we are working on a new file,then its getting stopped with prompt SAVE AS, it there any ways to save that file in desktop & get closed while running this macro?

Awaiting for your Reply.

Thanks

[xlnitwit]

What do you mean by "cancelled" in point 1? Cancel the whole process, or just not save the file, or something else?

[amb2301]

sorry for my poor english.......i mean to say just cancel it(not to save read only files)
rest all other macros to work as it is.

[xlnitwit]

Untested but perhaps this will do the job

Please Login or Register  to view this content.

[amb2301]

Untested but perhaps this will do the job

Please Login or Register  to view this content.

Hi xlnitwit,
Excellent work.......its working perfectly........Thanks a Ton for your Help

[xlnitwit]

You're welcome- though kev_ did most of the work here; I merely tweaked a couple of parts!

[amb2301]

Thank you so much Kev_ & xlnitwit .........Both of you made my work so easier..........My Hearty Appreciations to both of you !!!!

[amb2301]

Hi Both,
In simillar way i have one more incomplete task with me, i am in need of your helps.....i was already posted in the name "Auto fill Already opened webpage credentials"
Requesting you to please extent your help on that thread.

Thank you so much successful completion of this thread!!!!