How can i Refresh, Save and Close all worksheets in Single Click

3 views
Skip to first unread message

Pratibha Sharma

unread,
Sep 9, 2015, 10:08:35 AM9/9/15
to Excel VBA Lab
Dear All,

I have a query.

20 sheets are in 1 workbook and i want to refresh all worksheets in 1 go, then save all worksheets and Close.

Kindly help.


Rgds
PS

Ashish Kumar

unread,
Sep 10, 2015, 7:15:22 AM9/10/15
to Excel VBA Lab
Dear Pratibha,

Check this....!





Regards
Ashish Kumar
Resolved.xlsm

Ashish Bhalara

unread,
Sep 10, 2015, 7:56:45 AM9/10/15
to Excel VBA Lab
Hi, Ashish Kumar, you make a exact coding for save & Close all workbooks.

Regards
Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
 To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/27839cfe-940f-4be8-8261-0cc55e97c135%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Ashish Kumar

unread,
Sep 10, 2015, 8:05:07 AM9/10/15
to Excel VBA Lab, excel...@googlegroups.com
Dear Ashish Bhalara,

Thanks for acknowledge.


Regards
Ashish Kumar

Vaibhav Joshi

unread,
Sep 10, 2015, 8:54:10 AM9/10/15
to Ashish Kumar, Excel VBA Lab
Great Work Ashish Kumar..

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/7c32f624-cb3e-499d-8301-41d701a7619f%40googlegroups.com.

Ashish Kumar

unread,
Sep 10, 2015, 8:58:00 AM9/10/15
to Excel VBA Lab, kumar.a...@gmail.com
Dear Vaibhav Sir,


Thank you :)

Thanks for ack.



Regads
Ashish Kumar

Vaibhav Joshi

unread,
Sep 10, 2015, 9:00:17 AM9/10/15
to Ashish Kumar, Excel VBA Lab
Dear Ashish

You are doing great job..

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/a792b4cc-8e71-4af7-8b9c-1d78ae142155%40googlegroups.com.

Ashish Kumar

unread,
Sep 10, 2015, 9:03:35 AM9/10/15
to Excel VBA Lab, kumar.a...@gmail.com
Dear Vaibhav Sir,

Thank you. It's possible, only because of your guidance, support and blessings :)

Regards
Ashish Kumar

Ashu K

unread,
Sep 11, 2015, 8:30:02 AM9/11/15
to Excel VBA Lab, kumar.a...@gmail.com
Dear Ashish Sir,

It's superb :)


Thanks & Regards
Ashu Kenith
Reply all
Reply to author
Forward
0 new messages