Looking for sime guidance

  • Thread starter Thread starter Stephen Plotnick
  • Start date Start date
S

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
 
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
 
Back
Top