Automating Excel Macro to run??

  • 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 email

    I 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

  • You could write a DTSX package which extracts the data, performs manipulations (within the package) and sends the output to an Excel file and email it to your recipient.

    In what format do you receive your source data from?

    Also since you are using a DTSX package it might be better to perform your data manipulations within a DTSX rather than using Excel macros.

  • The source data sits on a network drive and is in Excel format. I format it using my macro into a CSV format

  • Well you can use an Excel connector to read the data from your source Excel file and possible insert it into a table and do some SQL manipulations to your data and then output to another Excel file.

    Im not sure if you can do manipulations like that without putting it in a db table.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply