LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default open new excel sheet

You'll have to know how to convert the VBA to C#;


CreateObject Function Example
This example uses the CreateObject function to set a
reference (xlApp) to Microsoft Excel. It uses the
reference to access the Visible property of Microsoft
Excel, and then uses the Microsoft Excel Quit method to
close it. Finally, the reference itself is released.

Dim xlApp As Object ' Declare variable to hold the
reference.

Set xlApp = CreateObject("excel.application")
' You may have to set Visible property to True
' if you want to see the application.
xlApp.Visible = True
' Use xlApp to access Microsoft Excel's
' other objects.
xlApp.Quit ' When you finish, use the Quit method to
close
Set xlApp = Nothing ' the application, then release the
reference.





-----Original Message-----
hello,

i'm coding in .net visual c#... how do i open a new excel
spreadsheet and write some strings to it?
.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ON OPEN VBA Code input incorrectly now excel sheet wont open mmartin New Users to Excel 1 February 16th 11 11:33 PM
why, when i open a work sheet does a blank sheet open as well John Excel Discussion (Misc queries) 2 July 7th 07 06:20 PM
When I open Excel I want it to open on Sheet 1 traveye Excel Discussion (Misc queries) 7 January 24th 07 12:03 AM
CANT OPEN EXCEL SHEET Inquiry Man Excel Discussion (Misc queries) 2 February 9th 05 03:16 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi[_5_] Excel Programming 1 May 2nd 04 03:50 PM


All times are GMT +1. The time now is 07:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"