Auto run macro on *.csv file open

I have a *.CSV file that opens/updates information for part measurements.
Current macros have previously closed all but the Personal macro workbook.
When a new part is measured, and it's data sent to the CSV file, I need a
method of automatically running macros when this CSV file opens. The CSV
itself will not store a self-start macro, either due to Excel constraints, or
due to the setup of the sendig program. Can someone help me set up a macro
in the Personal workbook that will begin after this specific CSV opens? I am
using Excel 97.

Thank!
--
CPPoe

What process is opening the csv file? Where does it open - in Excel ?

Tim

--
Tim Williams
Palo Alto, CA


"CP Poe" <[email protected]> wrote in message
news:[email protected]...
> I have a *.CSV file that opens/updates information for part measurements.
> Current macros have previously closed all but the Personal macro workbook.
> When a new part is measured, and it's data sent to the CSV file, I need a
> method of automatically running macros when this CSV file opens. The CSV
> itself will not store a self-start macro, either due to Excel constraints,
or
> due to the setup of the sendig program. Can someone help me set up a
macro
> in the Personal workbook that will begin after this specific CSV opens? I
am
> using Excel 97.
>
> Thank!
> --
> CPPoe

Nikon E-max software sends the CSV to Exce. If Excel is not previously
opened, my macros will not run at all. I have Excel open in the background
with no files except the hidden Personal macro file open. E-max sends the
information to Excel in a CSV.

"Tim Williams" wrote:

> What process is opening the csv file? Where does it open - in Excel ?
>
> Tim
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "CP Poe" <[email protected]> wrote in message
> news:[email protected]...
> > I have a *.CSV file that opens/updates information for part measurements.
> > Current macros have previously closed all but the Personal macro workbook.
> > When a new part is measured, and it's data sent to the CSV file, I need a
> > method of automatically running macros when this CSV file opens. The CSV
> > itself will not store a self-start macro, either due to Excel constraints,
> or
> > due to the setup of the sendig program. Can someone help me set up a
> macro
> > in the Personal workbook that will begin after this specific CSV opens? I
> am
> > using Excel 97.
> >
> > Thank!
> > --
> > CPPoe
>
>
>

You'll need to set up an event handler to catch the workbook_open event of
the Excel application object.

Chip Pearson has an excellent introduction to this:
http://www.cpearson.com/excel/AppEvent.htm

--
Tim Williams
Palo Alto, CA


"CP Poe" <[email protected]> wrote in message
news:[email protected]...
> Nikon E-max software sends the CSV to Exce. If Excel is not previously
> opened, my macros will not run at all. I have Excel open in the
background
> with no files except the hidden Personal macro file open. E-max sends the
> information to Excel in a CSV.
>
> "Tim Williams" wrote:
>
> > What process is opening the csv file? Where does it open - in Excel ?
> >
> > Tim
> >
> > --
> > Tim Williams
> > Palo Alto, CA
> >
> >
> > "CP Poe" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have a *.CSV file that opens/updates information for part
measurements.
> > > Current macros have previously closed all but the Personal macro
workbook.
> > > When a new part is measured, and it's data sent to the CSV file, I
need a
> > > method of automatically running macros when this CSV file opens. The
CSV
> > > itself will not store a self-start macro, either due to Excel
constraints,
> > or
> > > due to the setup of the sendig program. Can someone help me set up a
> > macro
> > > in the Personal workbook that will begin after this specific CSV
opens? I
> > am
> > > using Excel 97.
> > >
> > > Thank!
> > > --
> > > CPPoe
> >
> >
> >

Thank you.

"Tim Williams" wrote:

> You'll need to set up an event handler to catch the workbook_open event of
> the Excel application object.
>
> Chip Pearson has an excellent introduction to this:
> http://www.cpearson.com/excel/AppEvent.htm
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "CP Poe" <[email protected]> wrote in message
> news:[email protected]...
> > Nikon E-max software sends the CSV to Exce. If Excel is not previously
> > opened, my macros will not run at all. I have Excel open in the
> background
> > with no files except the hidden Personal macro file open. E-max sends the
> > information to Excel in a CSV.
> >
> > "Tim Williams" wrote:
> >
> > > What process is opening the csv file? Where does it open - in Excel ?
> > >
> > > Tim
> > >
> > > --
> > > Tim Williams
> > > Palo Alto, CA
> > >
> > >
> > > "CP Poe" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I have a *.CSV file that opens/updates information for part
> measurements.
> > > > Current macros have previously closed all but the Personal macro
> workbook.
> > > > When a new part is measured, and it's data sent to the CSV file, I
> need a
> > > > method of automatically running macros when this CSV file opens. The
> CSV
> > > > itself will not store a self-start macro, either due to Excel
> constraints,
> > > or
> > > > due to the setup of the sendig program. Can someone help me set up a
> > > macro
> > > > in the Personal workbook that will begin after this specific CSV
> opens? I
> > > am
> > > > using Excel 97.
> > > >
> > > > Thank!
> > > > --
> > > > CPPoe
> > >
> > >
> > >
>
>
>