RichTextBox recording a name, surname, telephone number and address in the Excel spreadsheet, where the name is repeated every 5-th line in the RichTextBox, the same name each of the 5-line phone every 5-th line, address each of the 5-line.
View 7 RepliesI am trying to write an app that monitora a folder, and subfolders, amd makes a copy of any file that gets saved there, (or renamed, moved etc). Filesystemwatcher does a pretty good job of it, untili someone saves an Excel spreadsheet. Excel does about 9 different file system operations just to save the file. What happens is I get events for tempo files being saved, then renamed, or deleted in a very quick succession. All I want is the final spreadsheet, but these changes happen so quickly is causes my app to crash. Anybiody have any thoughts on how to hendle this?
View 3 RepliesI found this code but I am developing a small sitemap builder for submit on yahoo so I need save all internal urls of a website in a listbox or richtextbox.
Public Function ExtractLinks(ByVal url As String) As DataTable
Dim dt As New DataTable
dt.Columns.Add("LinkText")
[Code]......
I'm trying to copy multiple excel source files into one excel file. My current code is working only for 3 source files..If more than 3 files are there, it doesn't copy the data but creates blank work sheet in the output excel file. Lets say I have a source folder with 5 excel files. Each workbook contains one worksheet with data. It copies upto 3 worksheets along with data into output excel file.
Lets say excel1 contains A as work sheet, excel2 contains B as work sheet ,excel3 contains C as work sheet ,excel4 contains D as work sheet ,excel5 contains E as work sheet .Now my output excel file should look like..OutputExcel with A, B, C, D, E along with respective data.But my current code is giving output as A,B,C worksheets along with respective data but its creating blank sheet1,sheet2 in place of D & E.
SSIS Script Task Vb.Net Code:
Public
Sub Main()
Dim filePath
As
String =
[code].....
How can I disable Save As button, I can open Ms Excel through vb net but the thing is I also want to disable the 'save as' as the Ms Excel Open.But not in Macro.. Here's my code:
Imports Excel = Microsoft.Office.Interop.Excel
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
[code].....
I am working on saving excel objects to a directory of my choosing. I am able to use a folder browser dialog to select the save location and the saveas method within the excel interop and i am able to create a file in the folder i select with the name i choose. The issue is that when i later go to open that file it is blank. no workbooks no worksheets etc . Just a seemingly blank file in the proper location with the proper name.
It should be noted that if i single click on the report icon to open it the microsoft browser window does show a tiny preview of what seems like the correct report.
eapp.Worksheets(1).SaveAs(FileName:=patient_frm.savefolder & "Lateral Postural Analysis")
I am working with a project where i am opening up excel worksheets, sending data to them and then printing the worksheet. I have been working specifically with Office 2010 and have everything working exactly how i want it to work. Recently i have been asked to make the same type of thing work for users using older versions of office.
So as a test i took one of the worksheets opened it in 2010 and saved it as a 2003 document. I went into the code switched the .xlsx over to .xls and gave it a shot. It appears that the code opens the correct file. Sends all of the data out to the worksheet and then the program bugs out.
[Code]...
In my game, there are many chapters that the character plays through. I want a savefiledialog to save to a folder (OF my choice) and then have another dialog in the main menu that can read exactly what chapter that save file was and then start the user at that chapter. What I need to know is A) How to assign a savefile with properties such as the Chapter name and B) How to save/load files with the savefile dialog
View 4 Repliesim used to C programming.
Private Sub SaveAsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveAsToolStripMenuItem.Click
timedate.Stop()[code]......
The problem is that if I save a file I get "myfile.GDL" if I overwrite that I get a new file "myfile.GDL.GDL" ect.the other problem being that the filtering in the windows save/open dialog wont show .GDL files unless I select "all files".
I developing an application that downloads some reports from a external ASP web app. I use the control webbrowser to navigate through the pages, generates and download the reports. The URL are in an array ArrURL and I have 2 situacions:[code]
View 5 RepliesI have used the following code too save a notepad file; [Code] The code saves files but only in the 'Application.StartupPath' folder, the save dialogue starts in the correct place a quizzes folder inside the debug folder but files can't be saved here or in folders inside it, even though you can browse them in the dialogue. I want it saving where navigated to in the dialogue.
View 2 Repliesim currently doing my special project in software development
[Code]...
I am dealing with survey data at the moment and i am interested in extracting data of identical 5 columns from 3 excel files and then aggregate them into one excel file.below is the code im working on, fairly new to VBA so my apologies if my code doesnt make sense to you.
Sub extraction()
Dim a As Range
Dim r As Range
Dim wbSource As Workbook
Dim wbDestination As Workbook
[Code]...
I've been programming in VB6 for years, I have decided to take the plunge into VB.net and C# 2010 but having a little problem understanding the big picture.In VB6 I could create user controls and save them as .ocx files, then use those .ocx's in other programs or on html pages. I am sure the same idea is present in VS 2010, I'm just not seeing it.Can anyone recommend a book or tutorial that will show me the big picture of all the aspects of the .net environment?
View 2 RepliesI accidentally submitted it before realizing that I probably should have selected the "Visual Basic General" forum. I am attempting to retrieve file properties of all files in a particular folder. I have used objFolder.GetDetailsOf... to retrieve the desired information of Excel workbooks saved in Excel 2003 format, but I cannot retrieve the information from files savied in Excel 2010 format.
[Code]....
I have searched the net and the msdn but cannot find code for a simple save and save as for text written within a richtextbox that needs to be saved.
View 1 RepliesI'm trying to export a datagridview to Excel and open the Excel spreadsheet (not SAVE the worksheet).
Public Sub ExcelRpt(ByVal DgvName As GridView, ByVal url As String)
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet
[code]....
I decided to to convert my excel macro in a exe file using visual studio 2010. In excel macro method find is present like this:
[Code]...
i'm trying to save an excel file after I open my excel application. This is what I have so far:
'Opens the report
xlPeakDemand.Visible = True
xlPeakDemandWorkbook.SaveAs("C:Documents and
[Code].....
When saving as an xls it works fine but when saving as a htm its a disaster Just a bunch or symbols and stuff. BUT if I go into my xls document and Save As webpage from there, it works fine!
The following code works fine but seems to leave instances of excel.exe running in the background. How do I go about closing out this sub properly?
Private Sub ReadExcel(ByVal childform As Fone_Builder_Delux.frmData, ByVal FileName As String)
' In progress
childform.sampleloaded = False
[code]....
[URL]..a good way to create Excel files without using Ms Excel,but this is C# source code,I used [URL]..to convert from C# to VB.NET,but after conversion There are some strange errors :
Error21Too many characters in character literalc:BBBXLSExportDemoXLSExportDemoExcelDocument.vb1625XLSExportDemo
Error22Empty character literalc:BBBXLSExportDemoXLSExportDemoExcelDocument.vb1633XLSExportDemo
so here is my problem im making a simple text editor (to edit a specified file by me) with a richtext box and 2 buttons load and save i have managed so far to make the load button but i have encountered a problem with the save button. once i save the text it saves te text from the richbox to the txt but the whole text is in one line here is my save code (that i use)
Dim FILE_NAME As String = "C:\test.txt"
If System.IO.File.Exists(FILE_NAME) = True Then
Dim objWriter As New System.IO.StreamWriter(FILE_NAME)
[Code].....
I need to know how to save a RichTextBox in VB .NET into another format ( not "*.rtf") but in *.txt to open It in Notepad.
View 2 RepliesI am trying to save multiple text files using a save dialog.
I can save one textbox
SaveFileDialog1.ShowDialog()
Dim File As System.IO.File
Dim Write As System.IO.StreamWriter
Write = File.CreateText(SaveFileDialog1.FileName)
Write.WriteLine(TextBox1.Text)
Write.Close()
but I don't know how to save multiple textboxes and richtext boxes. Would I have to use a screenwriter for this?
which are the control used to display word files and excel sheets inside vb.net forms ? (i have already added reference lib.)
Platform: Vb.net (framework : 3.5)
language : visual basic
I am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
How to save RichTextBox which are placed into a TabControl. So that when I type something into that RichTextBox and click the Save Button for the first "Tab" it should be saved in a notepad e.g "C:", a notepad for each Tab. And they should be loaded automatically when the program starts.
View 9 RepliesI have been working on a notepad program, and have recently been trying to check if a file is open, and if it is, save directly, not always using dialogues.Every time I try to save it though, it tells me that the files is being used by another process (my program I'm guessing)Here is my code:
Private Sub SaveToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveToolStripMenuItem.Click
If rtfopen = True Then
[code].....
In the Form of my VB .NET project I have one RichTextBox by default and 2 buttons the first button is for adding RichTextBoxs as much as the user want and the second is for saving all the texts in all the richtextboxs. Now the question is , what is the code to save all the texts in all the richtextboxs ??? I.E : The user added 3 other richtextboxs to the form and there's one richtextbox by default so the number of the richtextboxs are 4 , Now I would like to save all the texts from all the richtextboxs how do i do that ?
View 3 RepliesI want to develop an application which can Write, Save, Read text files(or html files) What I want the application to do is. When I open my application I can write stuffs and then it will save it to my hosting/server. Then, the application will read the text which I already save.. So far, I can only make the application read it by using WebBrowser control and navigating it to a specified URL. Example: [URL](or message.txt) Which I modified from the website not from the application. I want to modify the text or html files from my application.
View 6 Replies