Saving into Excel

Saving into Excel

• Prams

  Correct me if I'm wrong but if you save text to a text file.

  All these solutions show how to save text to an excel spreadsheet which is I would assume what your trying to do.

  Your not trying to do something weird like embedded text files within a excel file. Basically whatever your trying to achieve, if you can open excel and do it manual, then you can almost certainly automate the process and write an application to do it.

  I think its the addition word "files" which is not needed that confuses things.

  
  

• CSharpNewbie22

  IceAngel89:

  Try the following code can hope that helps:

  Dim oExcel As Object

  Dim oBook As Object

  Dim oSheet As Object

  'Start a new workbook in Excel

  Set oExcel = CreateObject("Excel.Application")

  Set oBook = oExcel.Workbooks.Add

  'Add data to cells of the first worksheet in the new workbook

  Set oSheet = oBook.Worksheets(1)

  oSheet.Range("A1").Value = "Last Name"

  oSheet.Range("B1").Value = "First Name"

  oSheet.Range("A1:B1").Font.Bold = True

  oSheet.Range("A2").Value = "Doe"

  oSheet.Range("B2").Value = "John"

  'Save the Workbook and Quit Excel

  oBook.SaveAs "C:\Book1.xls"

  oExcel.Quit

  
  
  

• m0nkeyforce

  this is for my school project and i tying to just save a "report" of what my program generates(output). But thanks. i'll try the code
  
  PLEASE HELP!!:
  And anyone knows how i can stream(if possible) video from a web cam and compare the pixels in it i am doing another project (also school). Trying to detect stationary objects. Opposite from motion. and help like sites can help. but i may need to do most of it myself since its for school. or any ideas about what else i can do. This shouldn't be in this post but its due next week! HELP! any other alternatives also can. Spotty, Bruno Help ! u have helped me a lot already thanks. Please help
  
  

• kangalert

  Hi,

  See these articles.>>

  Check if EXCEL is on the system.>>

  http://www.devx.com/vb2themax/Tip/19507 type=kbArticle

   

  How to open a spreadsheet.>>

  http://www.c-sharpcorner.com/UploadFile/mgold/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET11282005034134AM/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET.aspx

   

  How to do some cell editing etc,

  not just for the EXPRESS edition.>>

   

  http://www.codeguru.com/vb/gen/vb_general/ideincludingvisualstudionet/article.php/c12061__1

   

   

   

  Hope that helps.

   

  You can't say i didn't do a bit of searching...LOL!!

   

   

   

  Regards,

   

  S_DS

   

   

  
  
  

• Fox Me Up

  IceAngel89,

  I have no idea if you can save text into excel spreadsheets but you can get a excel spreadsheet built into your program and you'll be able to save it through that I believe. Not fully sure on it.

  Regards,
  AliQ

  
  
  
• Saving into Excel