I have a small application that is supposed to take data out of a running Excel Spreadsheet and perform some basic functions on it, copy it back to a new worksheet, and save it. My question is, how do I initialize my xlApp object to the already open and running Excel application. I have examples of creating a new Excel.Application but do not want to do it that way. The user will already have Excel, the workbook, and worksheet open. If I can get my xlApp object to equal the running and open Excel then my xlWorkbook and xlWorksheet objects can just equal the active ones of each of these. Any pointers you can give would be immensely helpful. Thanks in advance.
Greyeye
Excel and VB.NET Windows Forms
Hot Topic
- Displaying text in a ComboBox when SelectedItem is null
- Is it possible to show a form inside a tab control or others(excpet MDI parent)?
- Why does a windowsControlLibrary does not show in toolbox when inside a solution Folder?
- Can someone tell me how to add a simple white space using C# in string... forget the code...
- Strange form issue.
- Super simple question about adding a row to a DataGridView
- Getting rid of the Focus Rectangle on a button
- Redrawing buttons...using inheritance
- Exposing User Control Properties and Methods to IE
- something simple..
Windows Forms
- BackgroundWorker and BindingSource Threading question
- Custom forms & GraphicsPath
- Moving Data Between Databases
- printing
- Selecting both files and directories with OpenFileDialog?
- Multiple forms and a DataSet
- Precision data
- Radio button custom control
- Form maximize/minimize click event
- Creating deployment projects
Excel and VB.NET Windows Forms
hseb
Greyeye