D
debbie
The basics of my application:
It takes a tab delimited .txt file created from exporting a report
from Quicken, and creates an Excel workbook, doing all kinds of
sorting, calculations, and formatting based upon user input.
Besides selecting menu options from my custom menu, I would like to
give the option to run my wizard on the event that a any .txt file in
a specified directory is updated or added.
I have a few ideas based upon all the documentation I've read and
searches I've done:
-Use Automation/OLE to access an object in a system or Quicken
library, and an event associated with that object. I've attached a
few references to other libraries that might have something I could
use. But there are so many I don't know where to start. And I can't
see the newly attached libraries of objects in my object model
reference (not used to my new Excel 2007 environment).
-Something totally different, maybe create a Connection to a
particular .txt file (this way it would only work for one file being
updated rather than a new file created in that directory), and use the
IRTDUpdateEvent.UpdateNotify?
-Could I use the workbook Sync event somehow?
Also, I'd like to somehow keep this small part of the application (the
part that displays a simple dialog box that asks the user if she wants
to run my application for the file that was just created or updated,
upon the event of a file being added or updated in a particular
directory) running/available, without the user opening Excel.
It seems like it would be a common need, to run an event handler
procedure upon the event of a non-Excel file being created or updated,
but I haven't found any questions about it.
I would sure appreciate any advice from someone who has done this or
knows how to do it... thank you.
It takes a tab delimited .txt file created from exporting a report
from Quicken, and creates an Excel workbook, doing all kinds of
sorting, calculations, and formatting based upon user input.
Besides selecting menu options from my custom menu, I would like to
give the option to run my wizard on the event that a any .txt file in
a specified directory is updated or added.
I have a few ideas based upon all the documentation I've read and
searches I've done:
-Use Automation/OLE to access an object in a system or Quicken
library, and an event associated with that object. I've attached a
few references to other libraries that might have something I could
use. But there are so many I don't know where to start. And I can't
see the newly attached libraries of objects in my object model
reference (not used to my new Excel 2007 environment).
-Something totally different, maybe create a Connection to a
particular .txt file (this way it would only work for one file being
updated rather than a new file created in that directory), and use the
IRTDUpdateEvent.UpdateNotify?
-Could I use the workbook Sync event somehow?
Also, I'd like to somehow keep this small part of the application (the
part that displays a simple dialog box that asks the user if she wants
to run my application for the file that was just created or updated,
upon the event of a file being added or updated in a particular
directory) running/available, without the user opening Excel.
It seems like it would be a common need, to run an event handler
procedure upon the event of a non-Excel file being created or updated,
but I haven't found any questions about it.
I would sure appreciate any advice from someone who has done this or
knows how to do it... thank you.