Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ridders
Starting Member
1 Post |
 Posted - 2008-07-31 : 06:53:22
|
| Hello all - my first post here so please be gentle!!!I have an excel macro that runs performs well. Basically I get data from a remote computer which is stored on a drive on my network. The macro then runs by me clicking a button in excel which reformats data etc. I then send the reformatted data to a client via emailI was wondering if it was possible to run this procedure automatically without any intervention from myself. The data comes in at 6am, so could I get the procedure to run at say 7am and automatically send the data to the client's FTP server? Do I need some sort of DTS package?Is this possible to do in excel? Will I need to have my PC on all the time for me to do this?Any help much appreciated |
|
|
pootle_flump
1064 Posts |
Posted - 2008-07-31 : 07:06:13
|
| HelloDoes this have anything to do with SQL Server? If not then you are on the wrong bulletin board. |
 |
|
|
|
|
|
Automatically run macro and send via email