• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

Watch folder program

Working on a program that watching a folder for specific xl files and when a new file hits the folder, I need it to automatically open itself in excel.   No idea where to start.
0
DJ_Consulting
Asked:
DJ_Consulting
  • 2
1 Solution
 
xtreminatorCommented:
can you brief some more ?

is that program file tracking program that watches file behavior ? like new file auto open in folder ?

if i am right and close to your requirement. you can start thinking by searching(search function)  for excel file in particular folder. compare the created  file date and time with current date and time to open newly hit file in folder.
0
 
DJ_ConsultingAuthor Commented:
I created another program that saves csv files from a different machine to a protected network folder.   I have excel set to run a macro automatically that processes this file and emails it to the appropriate people.  

I want to create a vb program that will always run on a certain PC and when it detects a new file written to the network folder, it would open this file in excel with no user interaction.
0
 
DJ_ConsultingAuthor Commented:
This is exactly what i needed to get the right direction
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now