Solved

Watch folder program

Posted on 2013-06-12
4
523 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

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.

Question has a verified solution.

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

On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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 demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

762 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