I was thinking about writing some VB 2005 code that would be able to open an excel file and keep it open while I do things in separate functions/subs basically just check boxes, so each check box is its own sub but HOW do I do that with out opening and closing the excel file for every check box sub, since every time I make a check box the sub comes up as private?
View 9 Replies1) Is it possible to access the Excel mathematical functions without actually opening Excel?
I was thinking of through a DLL WinAPI call or maybe a delegate function or smaller program?
2) Does anyone know of a MS link or area that gives instruction on "how to" use every function of every Windows DLL at all?
Or for all those that Microsoft have chosen to document online at least.
I am currently trying to write classes so that I can access certain functions from any form within my VB project.
My class is defined thus:-
Public Class testclass
Public Function showmes()
MsgBox("Hello everyone"")
Return 0
End Function
End Class
I have added the class into my form using this at the top in the form:
Imports WindowsApplication1.testclass
Obviously, WindowsApplication1 being the name of my project, testclass being within a VB file, saved with my project.
I have attempted to call the function from the form using this:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
showmes()
End Sub
However I am getting the error "Reference to a non-shared member requires an object reference." I don't understand why there is a problem, since I have used imports to reference the class.
I have an asp.net web app. It has a shared class, and I want to have the connection string the same through out the site. My string is in my web config, but I don't want to type this all over the place:
View 3 RepliesI would love to implement the asp.net routing but i have a basic question.
In my Generic handler i have the following Global class
Public Class MyHandlerRouteHandler : Implements IRouteHandler
Public Function GetHttpHandler(requestContext As System.Web.Routing.RequestContext) As System.Web.IHttpHandler Implements
[Code].....
I currently have two forms, and I need to share the value of a variable in one of them.
I declared the variable to be 'Public Shared', and assigned a value to it. However,
when I inspect the value it appears as 'Nothing'. Here is the snippet:
Public Class A
Public Shared sVar As String = Nothing
Private Sub A_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
I am using this example I found to learn how to load class files and access variables through them. This is in a file called Class1.vb in the App_Code folder (this is not an app project):
Imports Microsoft.VisualBasic
Public Class my_class
Public Shared Sub my_sub()
[Code]....
How could I access the vartest variable without using a session, since if this is accessed by multiple functions at the same time the variable can be overwritten I assume. Is it possible to go the other way, where a variable is sent to a class file?
[Code]...
i have a function that i have in my data access class now i want to access it then declare and assign parameters and then insert data into database.
I have created a public shared subroutine in a class file in asp.net 2 (vb.net) web site app_folder.The subroutine retrives some values from a sql database via an sql query and assigns the datareader field values to several variables The problem is I can't seem to assign the variables from the subroutine to the variables and textbox controls in the asp.net page I am calling the subroutine from. The textbox text value just appear blank.By the way, if I response.write the variables in the subroutine they appear populated by the sql data reader.
View 9 RepliesI am currently working on a project of "interpreting" C# into VB. The project involves adding images to a database, retrieving images from the database and presenting them in thumbnails. Right now I have the following Public Class with the Variable that needs to be assigned:
VB:
Imports System.Data
Imports System.Drawing
Imports System.IO
[code]....
I'd like to get a more refined programming style and I was wondering if any of you might give me a hand...(How to declare public variables, constants, functions...in a proper way),is there any useful link or pdf document I could have a look in order to improve my style?
View 5 Repliesgive me a good resource that explains the difference between a Private, Public, Shared Functions/Sub/Variables? I normally use Public for Subs/Functions inside of Modules I call from other parts of the program. But I'd like to get more of an understanding of how and when to use them. I want as little as impact to a system that is running my programs as possible, so i guess the key here is I'm trying to just get more proficient in my coding.
View 8 RepliesI would like an overview of System.EventArgs. I have an understanding of System.Object where I can pass data between subroutines and functions using Public Classes. I am curious what EventArgs do?
View 3 RepliesI've got a program that runs from one Windows form, Form1, with stuff declared all in that class: public variables, public functions, subs, etc. I decided that the form was getting cluttered, so I added one button to bring up a new form, Form2, and I put some of the buttons & check boxes for testing over there, so that Form1 can be more visually clean. Problem: when I go to put the code for the tests into the buttons on Form2, none of the public variables or subs or functions that reside in Form1 are visible in Form2. What statement/s do I need to add (and where) so that the public "stuff" that's declared in the class for Form1 is visible within Form2, please?
View 6 RepliesI have to make a VB project for one of my college Co-Sci classes. However, I am having issues doing what I think is logically possible. Part of our project entails creating a user defined class, then create a form that then instantiates an instance of the object type. After that we are to list the item in a listbox. That is all well and good and works fine.
What I need help with is looping through each object in the listbox, getting some data from the object, then moving to the next.
I have been trying something similar to c++. For example, an object contained in a c++ array can be accessed like this:
array[index].someObjectMethod().
How would someone do something similar to that for objects contained in a VB listbox? I imagine it starts something like this:
myListBox.Items(index).
[code]...
EDIT: The above class is just an example of what could be returned from a web service. I won't have access to modify it at all, sorry if I didn't make that clear.Is it possible to somehow make a clone this class, so that it retains all of the properties values, but hides the fact that there is a Public function?I'd like to be able to take some existing classes we retrieve from a web service(which we didn't write) and be able to pass them on for use in an application, but without exposing the functions. I don't want to go down the route of creating my own classes that specifically define each property and write the values in (due to the sheer size of some of them), so I'm looking to see if there is anything dynamic I can utilise (maybe there is a way using reflection?).
In my Site.Master.vb file, I have a custom User object:[code]Now in one of the content pages, I want to be able to see if a user is logged in. I figured if the object u was declared in the Site Master, I could use it in the pages that derive from the Site Master. For example, I want to do:[code]
View 2 Repliesi have have a few questions about the syntax of the lan.:
1) What is the 'Get' statement and when do you use it?
2) Whats the difference between public, private, protected etc... when declaring functions and subs.
3) When would you use the overrides property?
I am trying to get a handle on SyncLock and multithreading, but I am having some trouble wrapping my head around exactly how it should be implemented. I have a Public Class Utilities with a many Shared Functions. I want to make sure that each function can only be executed when there are no other concurrent calls to the same function. So If I have 2 functions, A and B in a Public Class Utilities, what is the syntax so that a function "locks" while it is being executed, preventing any subsequent calls until the "locking" thread has completed?
CODE
Public Class Utilities
Public Shared Function A (ByRef i As Integer) As Integer
[CODE].............................
I know I need to wrap the statements of execution in a SyncLock block, but I am unsure of the scope of the parameter used with SyncLock...is it private to the function, class, etc? Can the same object be used to lock both functions if they are independent?
I used to develop applications in VBA, but now I'm using SQL Server 2008 Integration Services for a lot of the functionality, and using VB.NET as the scripting language where needed - all of which are new to me. I need to do the same string manipulation in several different SSIS tasks. With VBA, I'd simply write a function and declare it Public, and I could use it from any module. E.g.
Public Function MakeId(ByVal Country As String, ByVal Postcode As String) As String
....
End Function
' later...
Dim MyId as String
MyId = MakeId(County, Postcode)
But when I do that in a Script Task or Script Component, I find I can't call the function from VB in any other Script Task or Component; it says MakeId is undeclared. It works within its own 'box', but not from anywhere else.
how would it go to be able to use in a VB application some statistical functions that are in Excel?
Basically I would just want to know the general lines of how something like that goes, what things need to be imported and so and whether this is a very complicated thing or rather it is just about importing stuffs. I have found something like this (which extends itself ) . I get tons of error red lines that never seem to end despite correcting using the options, new ones appear etc
<code>
Imports System.Net.Mime.MediaTypeNames
Private Sub Button1_Click(ByVal sender As System.Object, _
[Code]....
Is there anyway of access the value of a chekbox in a excel worksheet using vb? I need to import the answers of a survey that is in multiple excel files.
I´ve tried
wsheetB.OLEObjects("CheckBox1").Object.Value
but I get a com exception
Exception from HRESULT: 0x800A03EC
What i would like to do is change the color of a column in excel. I cannot seem to get the right command string to accomplish it.
View 2 RepliesWhat I am trying to do is have a class where the functions of the same name are both instance functions and shared functions.
Public Shared Function Get...(byval xx as xx)
and
Public Function Get...
The Public Function uses a Property xx created in the constructor, whereas the Shared Function has the parameters (byval xx as xx).
I need to migrate from Excel 2003 VBA to Excel 2007 VBA. When Microsoft introduced Excel 2007 it removed many objects from the previous versions and added some new objects. Also it hid some properties of particular objects. These hidden properties can be viewed by going to the object browser, right clicking any object and selecting "Show Hidden Members". My problem is I need to access these hidden properties. Is there any way I can access these properties. I can successfully migrate from Excel 2003 VBa to Excel 2007 VBA with the same functionality?
View 5 RepliesHow do I access the new attributes of Excel 2007 chart objects from VBA code such as setting the line gradient on a data series?
View 1 RepliesI'm trying to use common Worksheet functions found in Excel 2003 (average, standard deviation, etc) from within VS 2008. See thinned down sample code below:
Code:
Imports Microsoft.Office.Interop
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
When ran it returns "New cannot be used on an interface". Removing "New" returns "'WorksheetFunction' is a type in 'Excel' and cannot be used as an expression."
I've added a reference to the Microsoft.Office.Interop.Excel library v11.0.0.0, which I'm using in other places in the code with no complaints.
I'm trying to make a public array that I can use in Form1.vb and module1.vb.
It seems to work fine in Form1.vb but module1.vb complains about that it isn't declared.
This is how I've done it: I placed it right after this line in Form1.vb:
Public Class Form1
Public SuffixArray() As String
how I declare a Array that I can use in all forms and modules?
I am attempting to make a form public. I've start out with this class:[code]I can see the stupid form thru intellisense, but when this code is run I'm getting a null reference exception. I believe this is because the stupid form has not been initialized. I thought that placing 'new' in my class definition would initialize the form.
View 4 RepliesIs there any way to make a class instance public?In my mainform I define an instance of a certain class and then later on in some other forms which appear I want to alter this class.I try and pass them through when creating new instances of these other forms and it tells me Error3<instance of the class I want> cannot expose type <the class> outside the project through class <the form I want to edit it with>Which I gather from documentation is about it defeating the purpose to have a private class suddenly be thrown aroudn.but then how do I make it public? I can't define it in the first place as public myXClass as XClass, it only accepts private.
View 6 Replies