Michael515
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 136
Hi,
I'm trying to have an excel open itself up in the background (so I don't have to actively open it) and then once open run a task where it refreshes the workbook (I have created a refresh workbook button labeled "Refresh_Workbook()" and then save itself uniquely each time it does that (so eventually it has multiple file names with a time stamp). This is the code I'm currently using:
Let me know if you have any questions or comments.
I'm trying to have an excel open itself up in the background (so I don't have to actively open it) and then once open run a task where it refreshes the workbook (I have created a refresh workbook button labeled "Refresh_Workbook()" and then save itself uniquely each time it does that (so eventually it has multiple file names with a time stamp). This is the code I'm currently using:
Code:
Private Sub Workbook_Open()
Workbooks.Open Filename:="C:\Users\Person\Desktop\My Documents\WorkbookRefreshProject.xlsm"
Application.OnTimeValue ("10:08:00"), "Refresh_Workbook()"
ActiveWorkbook.SaveCopyAs ("[URL="file://\\filepath\Feed"]\\filepath\Feed[/URL] Program\FormFLow to C:\Users\Person\Desktop\My Documents\WorkbookRefreshProject-" & Format(Now(), ("mmddyyyy") & ".xlsm"))
End Sub
Let me know if you have any questions or comments.