Hi,
I have a process and needs to find a short cut.
I have around 20 users.These folks uses a custom crystal reports to export field from a database into excel files. All the excel files are saved in their own local machine.
Ex.
C:\employee1.xls
C:\employee2.xls
C:\employee3.xls
From here they open the excel sheets and do what they need to. Data modifications, corrections and etc.
Exactly at 2pm in the afternoon a custom application is ran and searches through all of the defined user machines, it merges all the data into an online database. The other thing that the application does is it opens a custom word document and saves it into each user's desktop that tells tell how many company they had processed for the day.
I need a macro that is embedded into the word document so that at 3pm when they open the word document, the macro will clean out all the excel sheets from their c drive. If the document is not created on the user's desktop, no files should be deleted. Yes, I tried running a batch file but it wasn't working out.
Any help? Thanks.
Bookmarks