while creating Excel files in vb.net, all is fine, except when I want to close my PC and there are many popups to save or delete "bookx.xls". How do I prevent these blank books from being made??
View 2 Repliesit seems that every Excel workbook I create in Vb, Excel automatically creates a ghost book with the name Bookn.xls where the n is incremental. After a lot of processing, I could have 20+ blank books open and running in taskmanager!
View 7 Repliesi am new to vb.net programming i am trying to access excel worksheet pre defined with name Books.xlsx through vb.net i have taken a form with one command button i wrote below code in that:Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices
[Code]...
i am new to vb.net programming i am trying to access excel worksheet pre defined with name Books.xlsx through vb.net i have taken a form with one command button i wrote below code in that:
[Code]...
I'm starting a new project to handle info from some text files, a kind of sorting module so I'd like to give it a try using LINQ but looking for a book I realized that there are more c# books than vb, so I wonder if c# have better support or if it is more suitable than vb.
You think there is some advance on use c# or vb.
where X, Y, Z, F1, F2, F3 can be as small as 1 digit or as large as 3. There is a space between each value.I need a loop where I can write these digits to an excel document where:The first X goes into A2, the first Y goes into B2, the first Z goes into C2...The second X goes into A3, the second Y goes into B3, the second Z goes into C3...And this continues for as long as the program is run.
View 2 RepliesSo i am trying to add new worksheets to excel...not a problem there, but then I had a thought: What I really need is the proper code to add new worksheets on open that are named all of the dates in the current month minus saturday and sunday dates. That is what started to throw me for a loop. so i started with
set
newsheet = worksheets.add
newsheet.name = date
$
I have an Access 2007 database connected to SQL Server 2005. I want to use VB to create an application that will retrieve and manipulate data in our SQL database. I'm familiar with VB and I'm familiar with Access. What I don't know is how to get started creating forms in VB that's accessible through Access. Are there any books out there that will help me get started?
View 3 RepliesWhat would you recommend as the "best" VB.NET and C# books for learning Design Patterns?eferably books that actually give examples of when to use the patterns. I need torecommend some books to a group of C# and VB.NET developers.
View 19 RepliesI am able to place a single series of chart data with my code but I cannot for the life of me figure out how to add a second series. I can add the Series ... I can Select the series but cannot with out errors figure out how to put data the the series' that I am creating ...
Ol' Mitch
xlApp.ActiveChart.SeriesCollection(1).Values = Rng1 <-- Error
xlApp.ActiveChart.SeriesCollection(2).Values = Rng2 <-- Error
[Code].....
Ive got a report which runs but I need to manually set the pg breaks. Its quite a big report and its not always the same length. I need to print columns A to Q. Rows 1 to 5 are headers then I need to count down 45 rows and set pg break and keep counting down 45 rows until the end of the report.
View 1 RepliesI never touched the crystal reports topic before but i hae been through certain articles and found that i't not hard as it sounds. however, i need names of some good books on this topic..
View 2 RepliesAre there any books written with the focus on how to control MS Office (Excel, Word, Powerpoint) through VB.net applications? I only have checked the book Professional Excel Development that shows a little bit on automating Excel from VB.net. I would need a much more comprehensive book (or links to web learning pages) on the issue.
View 6 RepliesI am looking to write my own media library and was wondering are there any free .Net APIs out there to identify a product based on a given barcode? As a secondary point are there .Net APIs to return cover art for books, CD, games etc based on a barcode.
View 3 RepliesI'm looking for some good quality OO books, if any exist for VB .Net
View 10 Repliesim tring to switch to vb.net i guess thats the only way im going to learn how to make phone apps.when i bought vb6 i thought ms would send all the books involved , maybe in pdf formate.
View 2 RepliesIt has been nearly 4 years since I have started developing with .NET - mostly with ASP.NET and SQL Server. I rarely got any time to work with Desktop application but now I want to get lower level knowledge of windows application - I mean hows window application works (Hows form is drawn, what kind of lower level objects are being used, how user control detect keystroke and up to what hierarchical level etc.)
View 3 RepliesI want to add data to a column in excel but I need to do it without inserting a row. I want to type the data in the top cell, execute an event, have all of the data shift down, and then clear the cell that I typed the data in. I can't insert a row because I have calculations that are based on each individual cell in the list in adjoining columns. I can get this to work by inserting a row but can't get the loop quite right without doing it this way.
View 3 RepliesI'm trying to figure out what would be the easier method for what I'm trying to accomplish. What I have is in, on the main form, a datagridview that is bound to an xls file. I then have another form that the user can import/paste data to another dgv. This content then needs to be appended to the end of the main form's dgv. Would it be easier to add it straight to the dgv and then save it to the excel file or save it to the excel file and reload the dgv? Or does it matter? I'm not exactly sure how to do either method but I figured I would start here.
View 1 Replieshow to add further items to a dropdown control on the ribbon.
So far I have been able to create a number of items manually and then afterwards change the label of these items using
Globals.Ribbons.Ribbon1.DropDown1.Items(i).Label
Furthermore I found that some recommend using this to add further items to the dropdown control. But I am having a hard time trying to understand how to use it.
Globals.Factory.GetRibbonFactory.CreateRibbonComboBox.Items.Add
I would like to see a sample of how others have done it.
I am working on some code to take a csv file, save it as xls, then chunk the data down into a series of new worksheets. However I am having problems with saving the changes and I really can't pin it down. The code is as below
[Code]...
I have tried a lot to search a book which has good discussion about sending SMS through vb2010 application.I have tried in Google,Bing, Google Books etc. but couldn't find any book which can teach me how to sent sms through WEB API..
View 8 RepliesI would really love to work on some .NET programming and SQL(what my job will consist of). You can never learn too much programming .I've finished the VB book I had in class last semester and would like some either websites or book recommendations. I would like the website/book to have a problem and have me make the program however I see fit. Also, Are there books/websites out there that incoprorate databases with .NET programming? I'm having a hard time finding that.
View 1 RepliesI'm creating a rather large and complex application and was wondering if any of you had any recommendations for good books on application and project architecture. Multi-user - database - heavy interaction with windows api for shell extensions.Not the standard maintenance or reporting app I usually write!
View 2 RepliesI have an application which exports data from an Access 2007 database to an Excel 2007 worksheet automatically draws some graphs. I don't have any problems with generating the excel sheet and the graph, but i would like to also add the Date as a footer and a user name which will depend on a Login Form used to login to the application.
View 1 RepliesThis may be a lengthy explaination, but I am hoping to make myself clear.I have an existing Excel file that is created using the following code:
Dim warnings() As Microsoft.Reporting.WinForms.Warning = Nothing
Dim streamids() As String = Nothing
Dim mimeType As String = Nothing
[code].....
I am trying to open an excel file and write to it as data becomes availableI can create an instance of excel and write to the selected worksheet once. But, I can't seem to write back to the existing file. I keep on getting a null reference error when I try to send new data to the file.The function I am using will run once, but when it returns to the main form, I lose the values of xlApp and xlWorksheet. It appears that going in to the function makes the original values null.
View 2 RepliesI am trying to add some style properties to a column but the code I am currently using doesnt seem to work at all?
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook = oApp.Workbooks.Add()
Dim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet)
Dim style As Microsoft.Office.Interop.Excel.Style
style = oWB.Styles.Add("Style1")
[Code] .....
It's still the same as "default" would look when just opening up excel for the first time.
I'm a VBA programmer and can do Office integration in Office applications.I'm programming in VB in VSTS 2008 and following these steps to create an Excell application at runtime: [URL] but it is not working.The issue I'm having is when I add the reference, the library is not recognized by VBE intellisense and compiler, so: the code doesn't run.When I use late binding technique and declare variables as objects, the code runs OK, but I don't want that way.I tried adding the references in two different ways:
1 - Menu Project / Add Reference / tab COM / Microsoft Excel 11.0 Object Library / OK
2 - Menu Project / VB Properties / References / Add / Microsoft Excel 11.0 Object Library
Both methods didn't work.
I can download the vb.net 10 Language Specification from Microsoft here 600+ Pages is a lot to print out. So I want to know is there a Dead Tree version (A book)? If so, where can it purchased?
View 2 Replies