Looking for sime guidance

[Stephen Plotnick]

I'm looking for the best way to do a new project.

I'm fairly good at VB 2005.
I'm really good at Excel, including 2007.
I've never done macros in Excel but if that is the option needed I would
learn.
I read about VSTO SE and if this is an option I would learn.

Here is what I'm trying to do.

I'll have several text files.
I need to combine fields from these text files and do some calculations,
etc. I would do all the combining of fields from the text files and
calculations prior to getting the data into Excel. I would pre figure all
the cells in each row that I need into a spreadsheet. The number of columns
will not remain the same but by the time I get the data into Excel I will
know the number of columns, and the answer to each cell. I'm actually doing
all the work and letting Excel create the report, including pie charts, etc.

I want to get this data into Excel and do several special formatting
including the new conditional formats.

I want to name the excel file; this name would be unique for each process.

Thanks,
Steve

[Robin Tucker]

Hi Stephen,
You need to use office automation (controlling Excel from your VB.NET
application). There are loads of guides/examples around (google:
VB.NET+Office+Automation) or sometimes its just as useful to replace VB.NET
with C# as apart from syntax they work in exactly the same way.


Robin

[Stephen Plotnick]

Thanks for the information.

Steve
"Robin Tucker" <rt******@removehotmail.comwrote in message
news:f2*******************@news.demon.co.uk...

Hi Stephen,
You need to use office automation (controlling Excel from your VB.NET
application). There are loads of guides/examples around (google:
VB.NET+Office+Automation) or sometimes its just as useful to replace
VB.NET with C# as apart from syntax they work in exactly the same way.


Robin