Hi all - I have an Excel Workbook with several sheets. Theses sheets draw there information from a hidden sheet which is automatically updated daily. This Workbook is then sent to various people daily and I'm trying to automate the process. However, I must open the Workbook daily to allow the cells to re-calculate, save it, then send it. Is there a way via VB code to open the workbook, update the cells, then save it with the same name?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Manipulate Existing Excel Workbook
- Thread starter caper1175
- Start date
Similar threads
- Locked
- Question
