am developing an application automatingExcel 2011 from Visual Studio2010 with Visualasicthe problemis that I can call other subroutines.I developed the following subroutine to addformatting to the selected ce
View 3 Replies
I have been learning vb.net for about 6 months now and I red few books about basic visual programming as most to them have information about the basic concepts like what is Object oriented programming, subroutines, functions ,inheritance etc and bit about ADO connectivity to database. Having said all that I think I have good concepts about all these things but now I want to proceed further but can't find appropriate text books or online tutorials.
View 2 Replies1. If i have 2 projects in the same solution, how do i use one to open the other?
2. How would I open a form as Invisible and be able to still call subroutines from it?
Visual Studio 2008, Standard Edition VB.NET I have only limited experience using the background worker, and all that I've done with it thus far was fairly straightforward and worked fine.
I am now looking to run a process in a background worker which calls various functions and/or subroutines, but of course it generates an error indicating that it's on the main thread (or something like that - I don't recall exactly, but that was the crux of it).
As it is right now I have a bit of code that kind of looks like this (a little paraphrased but Im sure you get the idea)[code]I thought for sure the above would work but it still seems that I am missing something, when I open the excel sheet nothing was printed. This would cut down the lines of code that I have in half easily, so I would love to find a solution for this [code]But the excel sheets still do not update with the new information.
View 1 RepliesI do an application for taking screenshots during the game (CoD2), currently I have made the program but it does not take screenshot of games!
View 5 RepliesCan VB.NET be used to develop games in Microsoft Excel? Have seen interesting games such as Batman that run in Excel and would like to know what programming language is used for that.
View 5 RepliesI have designed a application in MS Excel 2008 on Windows XP using Visual Basic Application (VBA).Each and every thing is going fine on my side.My client is using MAC OS and MS Office for MAC. When i deployed my application to Client end one serious problem comes arise.
The problem is that when my client is opening this project he is getting it into the Design Mode.
[Code]...
I am working on Excel programming . Can you suggest the best publications for the beginner in Excel Programming.
Tasks Ahead:
To create a comboBox dynamically in Excel Worksheet Write events for comboBox_ change/click Dynamically changing the items in the combo Box
Can anyone point me in the right direction for a good book or web site for Word and Excel Programming for VB. I'm not talking about VBA, I need to "work" with them from within my program not from within word or excel. I need to upgrade programs that were looking at Office 2000 and we're going to 07 or 10 not sure yet but figured I could at least get a bit of a jump on things.
View 2 RepliesI have a C# API for interacting with a DB that i have set up. I need to return data to users in excel via hitting this API which calls a sproc on the DB.The problem i am having is in returning the data from the c# method, i'd like to return a datatable object, but maybe this isnt possible. I have the .Net class registered and i can see that it is called from the module in excel, it works if the return type is an int or string, but what do i have to do to be able to have the method return a datatable and be able to output its data to a sheet?[code]...
View 4 RepliesI have an excel document that has a button that i need to activate through vb.net.
View 5 RepliesI open an Excel workbook from VB.Net and then want an event in the workbook (such as pressing a button) to activate code in VB.Net. How do I accomplish this type of callback?
View 1 Repliesi have an excel template and there was a chart there, I was confuse on how can I call that chart when I'm coding in vb.net.. how can I call the chart for me to set the new value to fill the chart..
View 1 RepliesI have an Excel workbook which I created a sub-routine to insert data from the selected worksheets to a Sql database with the Sql stored procedure. I tested the sp using the Sql Management Studio and it works fine. However when I tried to call that store procedure and it failed. [Code]
View 1 RepliesExcel call to Sql Stored Procedure
View 2 RepliesJust wondering if anyone has any tips on calling some sort of visual studio app (untimately a form) from within excel. so something along the lines of having a button in excel which calls this dll/ocx and opens a form for data populating.
View 1 RepliesI have a vb.net app that retreives data from a MS SQL 2005 database. I have it creating an Excel 2003 workbook. In a cell of a Worksheet, I want to "Call" or make active my vb.net App via a key combination (Alt->V) and have the workbook/worksheet pass the Row number / Column to the vb.net app that will get the data and post back to this Cell. This combination (vb.net and Excel) is my report builder app. So I want to go back and forth between vb.net and Excel, passing the needed data from each. How can this be done?
View 19 RepliesI am using $.ajax call for download excel from .aspx page. But ajax throwing an error after Response.End. This is the code I used. Control is processing till Response.End() then alert(textStatus); giving parser error.
MasterPage.Master
$.ajax({
type: "POST",
[Code].....
I am using $.ajax call for download excel from .aspx page. But ajax throwing an error after Response.End. This is the code I used. Control is processing till Response.End() then alert(textStatus); giving parser error.
MasterPage.Master
$.ajax({
type: "POST",
[code].....
i m working on a payroll software, and for user facility i want to provide calculator and Microsoft excel file with our module, so there is no need to explciltly open the calculator,,whenever it is required,,,,,i want the code that provide me calculator by clicking a tool strip button on mdiform?
View 3 RepliesI'm looking to call an excel macro (excel version 07) within a separate visual studio application (visual studio express 2010). Basically, a user clicks a browse dialog button to select a xls or xlsm file which is then added to a listbox. Next, I would like the macro to run when another button is clicked. The macro looks at the first column in excel and moves the listed .tif images from one folder to another. I referenced the excel libraries, but seem to be getting hung up on a few code statements (''''ERROR see code below). I would like to run the macro within visual studio for any selected excel file or add the macro somehow to the selected excel file and run it.
'Here is the button click procedure
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
filenames = lstFiles.SelectedItem
[Code].....
I'm trying to export a listbox (lets call it Listbox1) to excel 2007 and I'm having some trouble with it. Listbox1 contains just one column of items but the list itself is able to contain more 30 items.I have this script and it does something but, the most important thing doesn't show up: The list as in listbox1...
'Dim oExcel As Object
'Dim oBook As Object
'Dim oSheet As Object
[code]....
I have recently taken a liking to programming, and have programmed a few games in C#,my friend has asked me to program an application for him to use in his shop. But I have no idea of what language is best suitable?
View 8 RepliesI recently added three subroutines to a form, and as a result of adding only the three subroutines, I have noticed some weird behavior in the form and I can't pin down why these three subroutines would cause it.
View 16 RepliesTo detect 'death of player' I am using the mouseleave event of my picturebox background (background1). Unfortunately this triggers both when the mouse enters an 'evil' and the 'points' and ends the game without the player being able to collect points.
The obvious way to solve this would be to swap detection to entering evils.
Unfortunately I am dynamically creating my 'evils' and do not know how to also dynamically create subs to deal with MouseEnter. Here is my code for generating the 'evils'
'The number of evils (asteroids)
Dim evilcount As Integer
'A count for use with comparison to evilcount
[Code]....
I'm struggling with an event related to my communications class.I'm calling a 'DataChange' function via event handler any time I receive new data over my serial connection. I then proceed to load that data into a DataGridView, perform some formatting, etc for the users. I'm getting a ton of problems due to the frequency at which the DataChange event is called and seems to steal the focus out of othert subroutines and functions mid-process.For example, I'll attempt to transmit data back to the serial device. After I format the data, but before I can actually call the Send function from my library the focus is directed back to DataChange and I never actually transmit my data.
Is this a problem best addressed by threading the DataChange related routines, unhooking the DataChange event before a function or routine then rehooking, or is there some basic principle I'm not implementing.
The Visual developer express outline provides hide/plus-minus signs throughout the HTML code, and it does this for Class's, but not for my subroutines in an ASPX file.Is there a way for it to do this, so I can reduce subroutines I'm not working on at the moment? I know I can highlight areas and hide, but it's kind of clunky to do quickly through many subroutines if I have 2k lines and a hundred subroutines.
View 1 RepliesI have 2 arrays X(n) and Y(n) where n can vary programmatically, no set value. I want to pass these two arrays between two subroutines.
Sub sub1()
...
call sub2(X,Y,n)
end sub
sub sub2(x,y,n)
...
end sub
I want to know how to prepare the arrays for the "call sub2" and how to extract the arrays in "sub2".
have been writing code to replace an old Fortran program. The Fortran program had very organized subroutines which could be called from anywhere in the project. Most of these were relatively small and left a small, easily followed main routine. I'm converting over to VB.net and when I write the subroutines they are all on the same form. Wading through 50-100 subroutines on one form is going to be messy.
View 3 Replies
