C# windows form and EXCEL vba question

[Jason Huang]

Hi,

In my C# 1.1 Windows form project, I would like to export record to Excel
2000 spreadsheet Record.xls.
I also need to do some data manipulation in the Record.xls.
How do I call the VBA from my C# windows from project?
Thanks for help.


Jason

 

[Marc Gravell]

To be honest, the simplest way to export to a spreadsheet is to simply
write the data as CSV. Apart from being simple, it doesn't require the
client exe (Excel), and it will be usable from anywhere. xls is not a
trivial format to write natively; you'd either need a helper utility
(which you might struggle to get for 1.1), or you should be able to
use interop to automat Excel directly by adding a COM reference or
using tlbimp to generate an interop assembly; xlsx is easier to write,
but still *much* harder than CSV.

Marc

 

[Chris Crowther MBCS]

How do I call the VBA from my C# windows from project?

If you mean how do you run a macro in the excel workbook, you need to
call the Run() method on your Microsoft.Office.Interop.Excel.Application
object:

http://msdn2.microsoft.com/en-gb/library/microsoft.office.interop.excel._application.run(VS.80).aspx

I'm assuming you already know how to use the Office PIAs to start an
instance of Excel and push data in to it.