Create Installation File With Just An Excel In It?
May 16, 2009
I 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..
View 2 Replies
ADVERTISEMENT
Feb 18, 2011
I have an excel-file that is being populated with certain information and is used as a base for a printing form...
I need to include that file in the installation and reference to it when populating the cells with some information. So, how do I include that file when installing the project?
( I tried already to change the 'Build Action' to 'Content' )
View 2 Replies
Mar 9, 2010
I have vb.net project (visual studio 2005) and ms-sqlexpress as database. i want to make file set up that contain vb.net exe file and other necessary files and installation of ms-sqlexpress.
View 4 Replies
Oct 28, 2009
how to create an Installation file in VB.Net. I create via Setup Project in Setup & Deployment . But how i add Shortcuts , Licence agreement, Serial no and Welcome notes.
View 2 Replies
Aug 31, 2010
I want to create personal folders during installation. I did the following steps:
Right click on your setup project ->
View -> File System
Right click on node "File system on
[Code]....
I know the above steps are correct and should work because i did it in the other application (solution) and worked fine. When i did same exact steps (of course i changed the folder name to be created), the application gets deployed but when i install, i don't get the Personal Folder under Documents? I wonder why did it work with my first solution and didn't work with the current one!
View 1 Replies
Jun 24, 2009
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 Replies
Feb 12, 2009
Is there a way in VB .NET to create an Excel file without having Excel installed?
View 7 Replies
Jan 8, 2009
SELECT * 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 Replies
May 22, 2009
how can I create an instalation form?
View 6 Replies
Apr 8, 2009
In the below code I am just trying to Create a excel work book, fetch some data from a sqlTable and insert it into a excel xls file. I am using Visual Studio 2008 Professional and Office 2003
The below program errors out at the "oQryTable.Refresh(False)" line of code towards the bottom
View 3 Replies
Jul 27, 2011
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
Jul 15, 2009
I'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 Replies
Feb 15, 2012
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 Replies
Feb 16, 2012
I posted this on the Deployment forum, but you guys reply so much faster
Quote:
How can I create a folder on my Application Installation Path upon installing my application?
View 5 Replies
Aug 14, 2010
I 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.
View 5 Replies
Jan 11, 2009
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 Replies
Mar 28, 2011
I 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 Replies
Sep 24, 2009
I want to create vb.net dll for exe ie displaying error in message box after installation....For example if connection file is not correct after installation then it should display in error message for that db connection is failed.....It should happened after installation....
View 6 Replies
Sep 12, 2010
I have developed a windows application in VB 2008. Now I want to make an Installation Package (setup) of my Project. But I don't want to create only the Setup. I want to include the .Net Framework 3.5 and Crystal Reports and all the files that are necessary to run my Application. so that when I run that setup (installation package of my application) all the necessary files installed automatically.
View 1 Replies
Oct 22, 2010
My 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 Replies
Jan 13, 2010
I created a Visual Studio 2005 application that works and installs on other user's computers, but not the way I want.
1. I want to create a single file that I can distribute to any user so when he clicks it, the application will be INSTALLED.
2. When it installs, it chooses to do in its own location. It does not give the user an option to save or install in a specific folder (where the application will be used because other files are there). How do i allow the user to save the the application in a specific folder?
3. I would like a single file that the user clicks to RUN the application. Is that the in*.exe?
View 1 Replies
Aug 3, 2009
I 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?
View 6 Replies
Mar 5, 2010
I 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 Replies
Jun 24, 2010
I can add a folder in the setup/deployment project and it gets added when my project is installed. when I do it by writing code, I get a message "access is denied", but the programme will continue to work. I eventually worked out that I had to right click the exe file (in programfiles) and run as administrator so that the directory is created (as the form loads).
View 3 Replies
May 24, 2009
I just made an application using MySQL for the database. I use WAMP.Can I combine WAMP and my application installation into one packet installation ?
View 2 Replies
Aug 25, 2009
I 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
View 1 Replies
Jan 9, 2012
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.
View 1 Replies
Jun 2, 2010
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
View 3 Replies
Mar 14, 2010
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]....
View 2 Replies
Jun 30, 2010
I am creating a windows application setup project using Visual studio 2008 setup project. This setup will have following steps[code]...
View 1 Replies
