Solved

Watch folder program

Posted on 2013-06-12
4
519 Views
Last Modified: 2013-06-13
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
Comment
Question by:DJ_Consulting
  • 2
4 Comments
 
LVL 11

Expert Comment

by:xtreminator
ID: 39241840
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
 

Author Comment

by:DJ_Consulting
ID: 39241865
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
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39242316
0
 

Author Closing Comment

by:DJ_Consulting
ID: 39244751
This is exactly what i needed to get the right direction
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question