One of our clients have requested a way to generate reports from dat
exported into Excel by a program they're using.

The exported data will reside in an Excel file as raw data in a coupl
of cells. One row of cells is supposed to be one row of text in th
report. So the mapping should be easy.

The thing I'm not sure about is how users should activate the "repor
generator". I know enough VBA, so that's not the problem. What I don'
know is where to implement it. It needs to be really simple for them t
use. Should I write a template? a macro? Can they install a new butto
on their Excel toolbar? Is it called a module? I'm totally lost.

Ideally, I would like for them to open up the raw data Excel file an
then just push a button in Excel to generate the report. I don't wan
to have them first open up "my program" and then import the raw data.
Does this make sense?

Thanks in advance

--
phreu
-----------------------------------------------------------------------
phreud's Profile: http://www.excelforum.com/member.php...nfo&userid=983
View this thread: http://www.excelforum.com/showthread.php?threadid=31483