I want to create an excel spreadsheet but, I want it to prompt me for the file name and where to put it. Once it is opened, I know how to interface with it. I only need to create a new file with a prompted for filename and location.
View 1 Replies
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]...
how can I create an excel file in excel 2003, open it, add workbook, write into it, save it and close it by visual basic 2008.
View 2 RepliesIs there a way in VB .NET to create an Excel file without having Excel installed?
View 7 RepliesSELECT * INTO [supplierexp] FROM [supplier] IN '' [ODBC;Driver={SQLServer};Server=(local);Database=sh op;user name='shop';password='abc123';Trusted_ Connection=yes];"For above code im getting error like ODBC--connection to '{SQLServer}(local)' failed. Im using the valid username and password only.How to remove the error
View 1 RepliesI'm trying to allow users to add a volumetric sheet to an existing excel spreadsheet. I need it to check to see if the requested tab name currently exists and if not then to create the sheet and be able to populate it with the proper information. Also, how do I reference back to the active worksheet once it is created.[code]...Create and name a new worksheet within an excel file?
View 10 RepliesI have an excel file with few macros written in VB language..
Now I want to create an installation file that will install this Excel file onto clients machine at a predefined (or user chosen) location just how a normal installation file works.. I also want the user to put a serial code that will be validated (don't know how)..
I think making an installation file in VB.NET is possible. My question is can I make installation file with just an excel in it and the feature of validating serial code using VB.NET?.. If it is possible that would be great.. otherwise what other solutions do I have..
I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. How can I create a sample template using vb.net code?
View 6 RepliesI want to create the Excel Document (.xlsx) with vba code integrated . by program vb2008
Because I want to sort the data in some column of table when i click header of the column.
I've found ways to read from a .txt file into Excel, but (having created and loaded an Excel sheet via vb.net 2008) I want to do the opposite which is to read each cell and row into a .txt file csv format like this: "Surname","Andrew","2","Mr","Hon.Member","PERCUSSION" I guess I need some way of knowing when the last row of data ends. Once in a .txt file I can load data in a variety of ways into several ListBox/s and labels without loading and reading the original Excel file.
View 3 RepliesI would like to generate an Excel file using a database query in VB.Net. How can I do it? To be more precise: I would like to "bind" a query (much like binding a query to a GridView) to an Excel file such that the rows in the table occupy corresponding cells in a new Excel file, and save the file to my computer. And then, mail that file to someone. While I can handle the mailing part, it's the creation of such a file that I need help with. Anyone know how to achieve what I want to achieve? PS: I need to do this in VB.Net and I'm using SQL Server 2008.
View 3 RepliesMy application is supposed to parse a text file (relatively easy) and create an excel spreadsheet report. Should I write a stand alone VB.NET application that saves the excel file, or should I use VSTO? I am unsure if there are any differences in terms of ease of development, usability issues, API functions available, etc.Are there any other programming languages/interfaces/libraries that will allow me to rapidly develop an involved excel spreadsheet? I am talking about things like functions, graphs, etc.
View 3 RepliesI am using it in conjunction with SQL2005. I am trying to replicate some simple activex script to create a new excel file that can be used as a data dump from a database.
[code]...
I have changed the file location references to make it easier to read. I have googled all morning but cannot find something that helps me. I think it has something to do with references?
I do one project in visual basic 2010.In visual basic 6 project can be make Package and deployment (setup file or install file) file using Package and deployment wizard.But in visual basic 2010 express edition does not have Package and deployment wizard.how to make Package and deployment (setup file or install file) file in visual basic 2010 project?
View 4 RepliesI want to save the data in a CSV fileas a new file in XLS format so that it can be opened later as a true Excel spreadsheet.
View 7 RepliesI using Microsof Visual Basic 2008 Express Edition. I need to create a form like: 2 buttons are open and save existing .xls file which each generation can choose a different.2 textbox that can be entered on the column
and last button to when choose two columns, to find duplicates values and mark different color same values. Is it possible?
At the moment Excel file opens, but the comparison does not require the introduction of the columns
I'm creating a reporting web page as part of a standard VB.NET web application. The page is data driven, with jquery making calls to a web service local to the application to get values of elements that are dynamically created in the DOM. Ultimately these dynamic elements and their values are all wrapped up in a JSON object, so that part of the client side is fine.
Right now, I can pass that JSON object to a method in the web service which creates an SQL Data adapter from the values and queries a database. My ultimate goal is to have this client JSON data be used to query the database and construct an excel file to send back to the user, or failing that a CSV file.
It's my understanding (from working with PDF file generation) that this type of function can only be done on the server side of the web application, not even from the web service (i.e. I can't have the web service return an array of bytes and have JavaScript/jQuery present that as a file).
So, how do I go about this? Now I have my JSON object on the client side, where should I be sending it, how, and how do I go about returning my file?
I've read about either storing the JSON in a hidden field and having the server take the elements value and go from there, or using AJAX to send the JSON to the server just before a postback is made to fire off the server-side function to run the query and return the data.
I just need a little guidance, and a little help understanding where to use the hidden field, or what I am actually doing with the pre-postback AJAX call.
i need to create an application(VB.net or VBA) which will convert text file contents into excel. u the contents fromt he text file have delimiters(special characters).The condition is while converting it should remove all the delimiters and paste teh content between two delimiters in to one cell.For Eg:
Text fiel content
|WGS|123123123|[Rxxxxx~CXXXXXCCCC~ADVANCED PPPPPPPP ASSOC
Excel sheet content:
WGS 123123123 Rxxxxx CXXXXXCCCC ADVANCED PPPPPPPP ASSOC
I have a windows form and I am attempting to create an excel file from a datatable that has already been created and i'm hitting a snag - the error is: The ':' character, hexadecimal value 0x3A, cannot be included in a name."I have a button to start the Export process, here's the
'here's all my imports for the form
Imports DocumentFormat.OpenXml.Packaging
Imports System.Text
[code]....
with VB.net 2010, i would like to export a text file (with ; separator and variable length lines) to excel 2010
View 3 Replieshow to create a program that can access information held in an excel database and show it in a simple form.
View 2 RepliesDim excel As New Microsoft.Office.Interop.Excel.Application()
Dim wb As Microsoft.Office.Interop.Excel.Workbook = excel.Workbooks.Open(txtFileLocations.Lines(w))
Dim ws As Microsoft.Office.Interop.Excel.Worksheet = TryCast(excel.ActiveSheet, Microsoft.Office.Interop.Excel.Worksheet)
when the program tries to opens an excel file, it always throws me an error "Office has detected a problem with this file. Editing may hard your computer" and my program crushes.......The problem appears on the SECOND line, on DIM wb...blahblah.. i went to the office and unclicked the "protected view" checkboxes.. but it still throws me those errors. my guess is that the office i have in the computer is not the same as the one that my program uses to open excel files (i mean, i loaded/imported some excel.dll files in the program so i guess that will be the one) But how do i make the program not care if the excel file is "potentially dangerous"?
[Code]...
when the program tries to opens an excel file, it always throws me an error "Office has detected a problem with this file. Editing may hard your computer" and my program crushes. The problem appears on the SECOND line, on DIM wb.
[Code]...
I would like to be able to have my users open an Excel file and include their add-ins they have installed and usually show up when Excel normally starts. Using this code, Excel opens with no add-ins visible:
vb.net Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
Try excel = New Microsoft.Office.Interop.Excel.Application
wb = excel.Workbooks.Open(filelocation & "checks.xls")
excel.Visible = True
[Code]...
Is there a property to allow add-ins when opening an Excel file?
Is it possible to preview an excel file in the printpreview control? if yes, please give me some guidelines.
View 5 RepliesI have a text file with the following contents:
China,Asia,100000,3500000
England,Europe,20000,49494
USA,North America,430933,33943
Brazil,South America,754744,74744
How can I export all these under the headings to Excel:
Country Continent Population Area
I am using Microsoft OpenXml SDK 2.0 to create Office 2007, 2010 files, specifically a very simple excel file. It has a simple header which is merged with 6 cells to center. Bold font size 16. There are 6 columns and each has a header. Bold font size 14. There are rows of data related to each 6 columns. I am looking for decent examples of OpenXml SDK 2.0 to get started.
View 4 Repliesi having trouble with exporting data from a dataset into an excel file, mainly i have included references to excel 12.0 and included the import line:Imports Microsoft.Office.Interopand i try to export a dataset to excel using a button that contains the following:
Dim row As Integer
Dim col As Integer
Dim rowCount As Integer
[code].....
I have read some of the other posts on this and seem to be a little different than my situation. Trying to print out some reports into an excel document on the clients machine - of course it works fine on my local (heard that before right). I went in and set my references Ms.Office.Core and Ms.Office.Interop.Excel to 'Copy Local' = True so the .dll are in the servers bin folder.
[Code]...
