I am using VB.net 2010 Enterprise Edition. I have an application in which I open and show an excel file. Here is a code snippet:
[code]...
When I try to browse away from the excel file using AxWebBrowser1.Navigate("about:blank"), a message box opens up asking me if I want to save changes to the file. I want to disable that message box.
[code]...
But this does not work.
At this point my program needs to load two files from excel which I have done manually in the code: Private Sub Excel_Load_L_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
where the user has to find the file path personally. In short no idea how to make that transition, any thoughts or suggestions of things to look into?
I have a vb.net program that opens up an excel workbook and runs a macro ("Report") in that workbook when a button is clicked. [code]...
View 1 Replieshow to insert a row into an excel file via vb.net?
I am familiar on how to do this inside the spreadsheet using vba - but not certain how to accomplish this within vb.Net.
BTW this issue occurs in any MS office program when the VB.Net (or even VBA) is processing information.Example: In Excel, a worksheet is displayed on the screen. I start either, a VB.Net or VBA procedure and within 30 seconds the Excel worksheet (previously displayed) blanks out. In both VB.Net and VBA,ScreenUpdating = False. My expectation is that the previously displayed screen would stay static as if I left my desk to get a cup of coffee; came back and the same ole Excel worksheet was still there?Of course, setting VBA Screen Updating = False accomplishes two goals: 1) speeds up processing and 2) saves the user from seeing unnecessary "garbage-processing" steps.Why does VBA or VB.Net ScreenUpdating = False not freeze the screen at the time of its invoking?
View 11 Repliesim using form with browse button and openfileDialog as a browse function how do i get it to return the full path of the image selected to a varibal EG File then a textbox on form EG txt_pic.txt = File also how can i set it so it only allows images EG jpg bmp png gif and ico and nothing else then how would i code it so it adds the image selected to the Resorces folder so it can be used again with out browsing for it i also want a combobox that displays all images in the resorce folder?
View 7 RepliesI have an application that opens a Excel file into a form using AxWebBrowser.Navigate. This works fine unless there is another Excel file open before I run the application, in which both excel files are opened in the same Excel application which then causes problems.
How can I ensure the AxWebBrowser.Navigate opens a New Excel application?
Imports Microsoft.Office.Interop.Excel
Imports Microsoft.Office.Interop.Owc11
Imports System.Runtime.InteropServices
[Code]....
How could i insert blank row in excel using vb dot.code?
View 1 RepliesI am creating an application which uses OleDb to connect to an Excel spreadsheet and read the data into DataTable. The problem that I am having is that some of the columns I am getting are coming up blank, I've managed to narrow down that this is because that the first few lines for that column are blank. As unfortunately this is valid in the context of the Excel spreadsheet as not all dates etc. are required to be filled in. I was wondering whether anyone knows of any way that I could go about ensuring that the columns are populated by the OleDbDataReader even if the first x number of rows have that column as blank.
View 2 RepliesI was wondering if it is possible to create a blank excel spreadsheet using a command button?
View 3 RepliesMy Visual Basic .Net 2010 application reads data from an EXCEL spreadsheet which will be generated by my "customers". The responses to Alkis last year (23 July 2011) has been a big help and got me over a hump in my application. Now I am down to the last issue - how do I detect a blank cell? Valid data is numeric, starts at a fixed cell (A5 to be specific), and will be continuous until it ends with blank cells. While blank cells appear to print a "zero", when I try to use zero as an end criteria I get a 'System.InvalidCastException'. When I put in a specific end value (-1) in the last cell all works fine but that, of course, is an invitation to a user error.What is the difference between "Value" and "Value2" and where might I find documentation that explains the difference? [code]
View 1 RepliesI would like to restrict what they see in the file upload dialog, which is set to "All Files" by default. I understand how to validate that they only uploaded a certain file type, that is not the question here. I would just like to know how to default the file type in the file selection dialog.
Is there any way to change this to "PNG only" or "*.png"?
This is using AsyncFileUpload in the ASP.NET AJAX Control Toolkit.
Is it possible to browse a zip file and search for a specified file?
Do I need to extract it, and if I do, how would I do it, and then find the specified file, and delete what was just extracted?
how can i specify dynamically by using open file dialog box
View 1 RepliesI am Importing a Excelsheet(xls) in to my Application, but the date and Number column showing blank in dataset when comes to application. The values are there in Excel. Any other way to import the excel sheet to application, so that i should get all the values same as there in the excel sheet.
View 1 RepliesI use an OLEDB connection to read from an excel database, and this loop to read in all of the data from each of the columns
While reader.Read()
For i As Integer = 0 To reader.FieldCount - 1
temp = reader(i).ToString + ControlChars.Tab
output_file.Write(temp)
[code]....
Some of the columns contain date information, which are read in fine (usually as a string "2/20/2011" or so), but the headers of those columns are read in as a blank "". The headers for all the other columns read in fine, but not for the date containing columns.
i want to learn how to open file using vb.net that should find the drive C or D. and in the reference what should i do 1st... and do you have any sample code...even it is not perfect attest i have an idea if what should i do..
View 10 RepliesI have a form with two web browsers. I have webbrowser1 navigate to a parent url and webrowser2 navigate to child url.
The page in webbrowser2 loads correctly but when I make a change to an element it doesn't also change the value in webbrowser1 as it should.
Should I be looking at cookies or something else?
if we need to browse a file from a open file option than how to select a file from the open option and only name of the file should be written on the button and by clicking on the button u should be able to open file the file can be .exe, .doc and any type of file
View 1 RepliesIn a VB.NET Windows Forms application how do I add the capability for someone to click a button or image and open a file browser to browse to a file and assign it's path to a variable so I can copy that file to another specific path?
View 2 RepliesImports System.Windows.Forms.DialogResult
Imports System.io
Dim DirectoryBrowser As System.Windows.Forms.FolderBrowserDialog
[Code].....
I am writing a program that should allow the user to press a browse button to browse their directory and save a text file with the form information they wrote in.
View 1 RepliesI want a code that when I press a button, it will allow me browse for an excel file that the content of the excel file will be displayed in a datagridview for me to click an "upload"button to insert into my database directly. Am using VS 2010 visual basic
View 2 Repliesit seems so simple but i cannot find the answer. I have a menu strip item (open...). and I have a RichTextBox1. I need to open *.txt and have it displayed in RichTextBox1. Currently I have no code behind 'open...'
View 1 RepliesIs there a way to get the select file dialog box open and putting the location of the file into a textbox without ever uploading the file?
ETA I'm using VB.NET in a web page. By using the asp:fileupload tag I can get the file location
_fudFileLocation.PostedFile.FileName_
But how do I prevent the file from being uploaded at all. We don't need it, just the file location. (The files are on a shared drive so if it's M:documents odayslunch.pdf for person A, it's the same for person B.)
how to browse to the specified file on a PC using network done by programmatically? What i mean is a program that can execute the following task:
normally we press WIndow + R (keyboard) to start command prompt. When try browse to other pc we simply key in friendPC. So the window will prompt for username and password to access the pc on the network.so programmatically, how to do this? so that when user click my button, let say btnBrowse, it will straighaway direct the user to the prompt window(username and password)? of cource, this prompt will be base on the permisson set at the destination pc.
i am creating a application to sign an pdf document..i am stuck at one place..i want the user to browse for all pdf file in the directory and display the selected pdf file from a specific folder in a "checklistbox"...he should be able to select multiple file or a specific folder from which all the pdf file must get listed in checklistbox......
View 19 RepliesI need to aquire the full path and filename of a file to add them to a database. I'm currently using OpenFileDialog and in debug it shows that when I select a file, the Filename property is the files full path with the filename. What is the best practice for extracting the full path from FileName?
View 2 RepliesI am wondering how you would go about coding a VB Project with a File Dialog box or something to that affect that could be used to have users select programs that are already on their desktop and move the icons and the program names into my application. I am sort of going for a File Program Popup Box that prompts the users to check off certain programs they want to add to my VB Application or to show a list or programs on their desktop. Is there anyway to complete this task with Visual Basic?
View 8 RepliesI'm trying to build a simple FTP uploader. How can I make it so the user can select a file to upload? See, what I want is to have a button (which I do) that a user can click, and it shows the OpenFileDialog (which I have), but then when they select a file, I want its path to be shown in a text box.
View 4 Replies