Solved

Watch folder program

Posted on 2013-06-12
4
488 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
Comment Utility
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
Comment Utility
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
Comment Utility
0
 

Author Closing Comment

by:DJ_Consulting
Comment Utility
This is exactly what i needed to get the right direction
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now