Excel Macro/VBA Experts

Peeps, Please help on how to create a macro which itself clicks a particular button in toolbar in excel on every Friday 4 pm and saves the output file in a particular folder.

And has 0 human intervention.

5,785 WSO Academy Investment Banking Session Reviews: 4.82/5

Georgetown McDonough School of Business

Class of '29 Jul 2026 Cohort

5.00/5

Investment Banking Mock Interview

“Julius was an excellent mentor and made the mock interview feel both challenging and constructive. He asked realistic investment banking questions and did a great job explaining not only what I could improve, but why certain answers were stronger. His feedback was specific, actionable, and immediately useful, particularly around structuring my responses and communicating my thought process more clearly. I also appreciated how approachable and encouraging he was throughout the session. I came away with several concrete takeaways that I can apply to future interviews, and I would absolutely work with Julius again. ”

SDA Bocconi School of Management

Class of '25 Oct 2026 Cohort

4.70/5

Investment Banking Full Resume Review

“The mentoring sessions were extremely valuable and played an important role in improving both the quality and the overall presentation of my CV. The mentor took the time to go through every single aspect of the document in great detail, providing clear and practical feedback on the content, structure, wording, and overall positioning of my experiences. One of the most valuable aspects of the sessions was the mentor’s ability to understand the specific requirements and expectations of the Investment Banking industry. Rather than simply making general improvements, he carefully reviewed each section of my CV and helped me identify how to better present my academic background, professional experiences, skills, and achievements in a way that is relevant and attractive to Investment Banking recruiters. The mentor also completely restructured the CV, helping me move from an initial version to a polished final format specifically suited to Investment Banking applications. The final result was much more concise, professional, and impactful, while ensuring that the most relevant information was clearly highlighted. His attention to detail was particularly helpful in improving the wording and making each bullet point more focused on achievements and measurable impact. Another aspect I particularly appreciated was his responsiveness. He was extremely quick in answering my questions and providing feedback, which made the entire process very efficient. Whenever I had doubts or needed clarification, I received a prompt and detailed response, allowing me to continuously improve the CV without unnecessary delays. Overall, the mentoring sessions provided significant value and gave me a much clearer understanding of how to position my profile for Investment Banking opportunities. I am very satisfied with the final version of my CV and with the level of guidance and support provided throughout the process. I would highly recommend this mentoring experience to anyone looking to strengthen their CV and prepare it effectively for a career in Investment Banking.”

See All 10,803 WSO Academy Reviews

2 Comments

roamingredcoat

IB

4y

Clicks a button - Like in the excel toolbar or some sort toolbar set-up in the sheet? If on the excel toolbar, then calling the function directly would be best. Trying to run this in the background? Like open excel, run function, save, and close? Also, just saving down the existing workbook or need to create new workbook for that day/time?

Reply

Quote

Report

Other

high hopes

PE

4y

Nemo autem fuga et. Minima consequatur eaque consequuntur excepturi debitis aspernatur sint dolores. Illo quos autem omnis optio. In ut aut ratione. Modi reiciendis sapiente nisi officiis. Ipsa et asperiores voluptatum dignissimos tempore eaque repellendus. Temporibus aut sunt eum laborum temporibus.

Voluptas itaque recusandae ex quod consequatur vero esse. Iure nisi et quos dolores sit unde dolore. Ea dolorem voluptatibus nesciunt voluptatibus aut quidem harum. Quod voluptas dolor et numquam ratione repellendus.

Nam qui id dicta corporis. Qui facere pariatur porro aut quia est sit. Praesentium facere sed sed in quidem tenetur. Atque quam est velit eveniet perferendis et. Exercitationem ut debitis delectus debitis est. In rerum magnam expedita nesciunt enim.

Magnam sed voluptates alias voluptates dolorem. Nemo accusantium in odio ex qui laboriosam autem. Illo fugit et consequatur distinctio dolor tempore distinctio ut. Pariatur sint minus distinctio molestiae dolor sed. Delectus architecto id sed ut est animi. Delectus recusandae rem qui error ut rerum.

Reply

Quote

Report

Other

Authored by: Certified Private Equity Professional - 1st Year AssociateCertified Private Equity Pro

+211	Just One More Year	17	4h
+173	Piper Sandler in talks to acquire PWP	74	5d
+124	UBS Appears to be Exploring Sale	19	2d
+87	Paradise Is Paradise	8	9h
+77	Drunk VP. How to manage?	27	1d
+38	How do I take my foot off the gas? (AN1)	4	1d
+38	Lazard US Views 2026/2027	13	1d
+32	M&A is Paradise	1	6d
+25	Why did EVR succeed vs GHL or PWP that ended up getting acquired?	7	3d
+24	HR is starting to worry me, do I throw a hail mary during an upcoming chat with an MD?	4	51m

1	redever	99.2
2	kanon	99.0
3	BankonBanking	99.0
4	Secyh62	99.0
5	DrApeman	98.9
6	dosk17	98.9
7	CompBanker	98.9
8	Betsy Massar	98.9
9	GameTheory	98.9
10	numi	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Macro/VBA Experts

Score Breakdown

Feedback

Score Breakdown

Feedback

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Macro/VBA Experts

See All Comments - 100% Free

Trending Content - Investment Banking Forum