Create and write file vbscript

Improve this question. Maddy Maddy. Which version of Excel? What flavour of VBscript? Where are you planning on running the VBScript from? YogoZuno,I am using VB 6. Can u please suggest me any good link where we could study vb scripting by ourselves. Add a comment. Active Oldest Votes. Application" objExcel.

Add objWorkbook. SaveAs strFileName objExcel. Improve this answer. Shoban Shoban Thanks a lot shoban. Can u suggest me a better link where we could learn vb scripting — Maddy. Close objExcel. CJ7 MD5 MD5 10 10 silver badges 13 13 bronze badges.

CreateObject "Excel. That fixed it. Thank you for your help. Horner Ekkehard. Horner Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. WriteLine textBox. Text FileWriter. WriteLine comboBox. ToString FileWriter. WriteLine radioBtn. However if you want you can first call Flush to have the data written out. This step is optional however as the Close function will call Flush if needed. Flush ' optional as close will flush FileWriter.

Close Reading Data from a File The process for reading information out of a File is similar to the writing process. To see the full example of how the data is processed please view the full source code below. Close A complete sample Save and Write Class For those that learn better by example below is a Simple Class that holds a complete example of saving data to a File from a Form in addition to loading the saved data from the form and setting the components to the correct state.

Imports System. Object, ByVal e As System. EventArgs Handles MyBase. EventArgs Handles CloseButton.