I have an excel file which updates data in sheet when open. This data is pulled from sql server database.
I would like to make this automate. I want this file to be store in a location and daily morning(ex at 6 am) this automatically pulls the data from sql server(which already doing when open the file, but manual work for which we need to open the file manually) and save the file at same location and then close it and email this file to me.
is there a way out for this?
Because you want the file saved, closed, and emailed, the best solution is probably to use the Windows Task Scheduler (WTS) in conjunction with some VBA macros. A typical scenario:
- First morning task (WTS) opens the workbook
- Macros in the workbook (VBA) gathers the data, processes it, saves the data, closes the workbook
- Second morning task (WTS) emails the processed workbook
Gary's Student
Thanks, but i am not able to auto refresh the workbook. Steps is not working automatically it need an manual help.
for email i already have a scheduled job.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks