1) 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.
What 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).
Hint: this one might sound complicated, because I am trying to give as much info as possible, but I suspect that I just want someone to tell me "yes, you are correct".On this legacy system, which dates from 2002, the user visits a web page and uses an RFID reader to read a tag number, which is then written to an input field on the web page.
The only s/w that comes with the reader is a custom DLL, nop .exe. The very sparse documentation insists that only MSIE be used and that all security relating to ActiveX be disabled.When I look into the source of the web page I see calls to functions in the DLL.Now, here's the fun part: I know zilch about ActiveX, I have to make a minor change to the DLL _but_ the VB6 source code has been lost, so I guess that I have to recreate the (seemingly very simple) DLL from scratch - this week.
Decompiling the DLL shows me the functions (locateReader, getTagVal, closeReader). However, by decompiling I can't really know the number or type of the parameters, nor the return values ... and if anyone knows the API they are refusing to share it, but basically it all seems to have been lost in the mists of time as companies went bust, were bought & sold, merged & demerged and the initial DLL might have been written by an external guy, but no one knows who.So, can I get the function params & type from the ASP page source?I see things like
Reader = new ActiveXObject("<dllName>.Reader");
Reader.locateReader();
tagVal = Reader.getTagVal();
Reader.closeReader();
I would say that none of the fn()s take parameters, that closeReader doesn't have to return anything; it looks like locateReader doesn't return anything either, so I guess that error handling will have to be in the DLL (loop forever with a popup demanding that a reader be attached; and getTagVal seems to return a string.
I have been trying to build a game bot in vb.net.One of the main problems is getting access to the text the game prints on the screen so I have been trying to hook the games calls to the windows api drawtext and textout functions.I have been hunting for examples of how to set up a hook in vb.net for a long time without any luck.I have found it impossible to translate examples in old school vb, C++, and C#.For convenience's sake I would like to use the freely available deviare and/or easyhook libraries.
View 2 RepliesI am trying to send data and arrays using System.Object and System.Event. Lets say I have 4 pieces of data: date, y(1),y(2),y(3).
sub main(...)
Dim date,y(1),y(2),y(3) as integer
Dim obj as System.Object
Dim args as System.Eventargs
How do I organize obj with all the integer data above so I can send it to main2.
main2(obj,args)
end sub
Sub main2(obj as System.Object,args as System.Eventargs)
End Sub
And how do I apply this to (ByVal sender as System.Object, ByVal e as System.EventArgs). I am using VB.net 2005.
In our VB6 applications, we added a few utility functions for tracking the amount of time spent in a function. We did this to track performance bottlenecks. Basically, how it worked was there were two utility functions:
StartTickCount() and EndTickCount().
You would pass the name of the function in each, and the functions would use a dictionary to get the tick count when StartTickCount() was called, and then subtract the tick count when EndTickCount() was called. This wasn't perfect because it didn't of course take into consideration that calls to get tick count takes time, etc, but basically it worked for our purposes. How to make sure to call StartTickCount() at the beginning of each function and EndTickCount() at each exit point:
Private Function SomeFuction() as String
' indicate the function started
StartTickCount("MyClass.SomeFunction")
' some logic that causes the function to end
[Code] .....
Anyway, is there any functionality built in, either through the VS 2010 debugger or in the System.Reflection namespace, to do something similar in VB.NET? Basically, what I want is to log the number of times each function is called, the total amount to time spent in that function, the average number of seconds spent in that function, and the maximum amount of time spent in a single call in that function.
I have an application that I am reworking. It has many reports and a pain to compile and roll out.I'd like to make a root user interface that "calls" the functions and subs remotely.I was concidering pulling them and making formless exe's of them, passing the needed criteria via command line. Yet still be able to update and control them.
View 4 RepliesWhile converting types, I have found myself using both VB functions and BCL Convert.To* methods.
E.g.)
Cstr() vs. Convert.ToString()
CInt() vs. Convert.ToInt32()
CDbl() vs. Convert.ToInt64()
etc...
Are there any subtle differences that should be noted?
Is there a way to see exactly what the functions are doing. What i mean is there a way to see the class? I know what it does, i just want to know the code.
For example the function: Membership.FindUsersByName()
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]....
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 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 redoing a program for my company and my boss wanted me to created the entire thing through functions...
For the task I wanted to know is it possible to have functions within functions?
Sort of like in C where we would have nested structures?
Its a FILE I/O, with robot commands, moves and verifications....
So I would find the line in an excel spreadsheet where it moves, the coordinate, put it into an array.
Take the actual results store them into a two dimensional array...etc, etc....
Another function would eventually compare the results with the moves, and within a tolerance.
When you refrence a Function like this one:[code]You may want to be able to get more out of that, like this.[code]So how would I be able to add subs or functions onto a sub or function like that?
View 4 RepliesI have made quite a good library for calculating Math problems like Quadratic Equations and many other. Now I met a friend, and hes programming a little in VB, and we were thinking if it is possible to import my functions from C++ to his code, so he can call them, when they are needed, so we can make a calculator? How can we do that?
Edit: My friend is using VB.net
Edit: My library is organized in free functions.
I am not sure if i am using these in the correct manner. Basically i have an app that downloads a file from an ftp server (i am kinda cheating cos i am using chilkat). Now if i put the code directly in the form i can get it to do a progressbar.value = ... in it['s own sub.What i decided to do was stick my ftp download parts into a dll i created. Created a function within the dll and i have a return on that which returns the message 'file downloaded' or 'no file to download'. But can i return a value to update the progress bar as it goes when the code is contained in a dll? Or am i totally missing the point and how to use dlls?
View 5 RepliesI have a code which I call many times in my soft,its an external exe commandline file with arguments,Here is a piece of my code
Dim processgetver As New Process()
processgetver.StartInfo.UseShellExecute = False
processgetver.StartInfo.RedirectStandardOutput = True
[code]....
I want to ask help from you guys, about on how to use the listview functions in vb.net. I also just starting to study about the vb.net for my object-oriented programming. Please help me in writing the codes for a simple listview.
View 4 RepliesThe following syntax is valid VB.NET code
Dim myCollection As New List(Of Stock)
myCollection.Add(New Stock(Guid.NewGuid, "Item1"))
myCollection.Add(New Stock(Guid.NewGuid, "Item2"))
[code]....
How can I accomplish the same thing in C#? I have tried...
myCollection.FindAll(bool delegate(Stock stock) {
if (blah blah) {
}
});
But it appears I have somehow structured it incorrectly as I get the following error. "Error 1 Invalid expression term 'bool'"
How do I check which functions are in a dll I don't who's contents are unknown to me? I am looking to use a certain function and I have a couple of dlls and I don't know in which one it is are its name. So i need to be able to show all function available in a dll and their parameters.
View 6 RepliesI'v got 3 functions that I'd like to combine into 1. There is only one line in each function that changes. can think of a few ways off the top of my head, but not sure which is "the best", or "proper way" to accomplish this.
Private Function CheckQuads(ByVal QuadNumber As Integer) As Boolean
Dim intArray(3) As Integer
Dim x As Integer = 0
[code].....
We know some functions in dll files and can use them but if we haw a dll file and dont know functions names. is there a way to get the functions name and their parameters
View 3 RepliesI am new to visual basic and currently doing my major project on sending sms using visual studio 2005. I want to create it in window application. I have search the net but I could not understand it. I have download some of the project that the net has found for me but when i test it the receiver did not received any message but the application have come out the popped out box saying "message send".
View 8 RepliesI have a DLL library, but I am not familiar with it. How can I get its usage in vb.net?
View 2 RepliesDoes VB.net have anything built in for graphing functions? Linear, quadratic, cubic, log, and absolute value functions would be my main needs. I would want to display the functions on a graph whose x- and y-axes both go from -10 to +10, with grid lines.
View 1 RepliesI am fiddling with the code here: [URL] I had a couple errors when I copied/pasted it into my project. I dimmed a couple variables, now the squiggle lines are gone, but I'm not sure how to call the functions in the project? Do I use a Lable or a TextBox? How do i make this work?
[Code]...
I am working on a migration project of vb6 to vb.net, in vb they did some string actions with left, right, mid functions. How to achieve the same in vb.net.
View 3 RepliesHow do you use the e.graphics functions? I have visual studio 2010 professional installed. I opened a windows form project, in the code window I type e., there's only End. or Enum., no e.! Do I need to import something at the beginning, or do I need to open certain type of project to use the e. graphics class of functions?
View 6 RepliesI have a visual basic file with a number of functions I want to use inside my XSL. I can build it as a dll and reference in my XSL project but I don't know how to reference it in my XSL file. I am using visual studio.[code]...
View 1 RepliesI was reading the lesson on how to use functions and subs and I'm having a bit of a hard time understanding this part:
[Code]...