write a program to automate

[g.ganiraju]

Hi All,

I am new to this IT fileld.can you please help me to write a program for the following requirement.



Please dind the requirement.
1. wnat to connect to remote desktop .
2. There we can find one more DB like AS-access. This one contains one file( ltake it as "XYZ" i)n some particular path(G:\Sales\XYZ.dat file).
3. want to save this file in share folder (D:\Products\abc.txt).
4. this share folder contains some "abc.txt" file.
5.want to replace the data which XYZ contains.
6. It is already having one ".XLS" file in share folder. want to delete it. ( because while running the exporting data the ".XLS" file created daily)
7. now in share folder we have one ".mdb" file.If we click on that it will ask like "create Report"," Exit".
8. we should click on "Create Report"
9.then one pop up will come like "All the exisiting data will be lost",then press "OK"
10. Again one window will open. It contains 2 buttopns. 1. Import Data 2. Export data.
11.Click on Import data. Then it will ask for "Password"
12.After giving the password it will import the whole data. ( It's taking around Hr time)
13. After that one pop up will come says " Import completed". then press OK and then click on "Export data"
14.After clicking this it will generate ".xls" file in share folder.
15. after that open that ".XLS" file and then Goto Tools --> Macros --> Macros, to run the Macros from Excel sheet.

16. Run the macro - "PERSONAL.XLS!macNewEFG".

17.Once done, save the ".xls" as "Report - <Month 'YY>.xls" in share folder.
18.Send then this generated report to respective mail-ids automatically.

daily manually we are doing this process. But I am planning to do it automatically
so can you please suggest me for doing this.

[ajetrumpet]

you need to pay for this.