Automatically Detect excel document in designated directory

[brucelim80]

hi,
Can anyone help me with this scenario?
I need to write a program that automatically detect any excel file in the designated directory and convert it into pdf and place it into another folder.

Does anyone got any idea how to do it using VB.net?


Thank you,

Regards,
Bruce

 

[jmcilhinney]

What does "automatically detect" mean? Do you mean that it should detect an XLS file when it's created, or when you start your app, or when you press a button, or something else? As for converting it to a PDF you wiull need either Adobe Acrobat installed or some third-party application or component. iText# is a free .NET component that should do the job, although I've never actually used it myself so I don't know exactly what its capabilities are.

http://www.google.com.au/search?cli...s&hl=en&q=itextsharp&meta=&btnG=Google+Search

 

[brucelim80]

HI thank for your reply.

Automatically detect in my context mean that any incoming file is created under the designated folder or directory.

Do you know how to do it?
Thank you

 

[jmcilhinney]

You would use a FileSystemWatcher. You can create on in code or you can add one to a form in the designer. It has filters to specify which folder and files will prompt an event to be raised and various events for different types of occurrences. I'd suggest that you read the class overview and member listing before using one.