vbscript - financial functions! rate() -
Im trying to build a financial calculator in vbscript,
and have stumbled upon the fact that vbscript does not support any financial functions? Can anyone confirm this?
Is there any other alternatives to rewriting this functions? Specifically i am after the rate() function (the one which is used in excel).
Is there anyway to some how get the vbscript code behind from excel??
I have tried to write the function myself in vbscript, using a guess and check method loop - but this proved way to inefficient and froze the computer when numbers/percentages were getting big.
Can someone suggest an alternative solution?? I have the choice of javascript/java object or vbscript as the program which takes these scripts only accepts those two languages.
Thanks for any help and solutions!
vbscript - financial functions! rate() -
Im trying to build a financial calculator in vbscript,
and have stumbled upon the fact that vbscript does not support any financial functions? Can anyone confirm this?
Is there any other alternatives to rewriting this functions? Specifically i am after the rate() function (the on
Do you have a VBScript function about Financial (Rate, PV, FV) -
Do you have a VBScript function about Financial? (Rate, PV, FV)
Because I would like to use "Rate" function in my VBScript page but I think that it is only in VBA library of VB or Excel.
Thank you very much.
[2008] ( Help please with simple Financial Calculator) -
Hi,
I'm trying to create an application that basically has
Financial goal to save (for example:$200 000)
Yearly Investment (ex: $5000)
Interest Rate (ex : 0.06)
Year ( ex: year 1, year 2..etc)
Balance (ex: Yearly investment * Interest Rate)
Remaining ( ex: Financial Goal - Ba
WebCam : Frame rate VB.NET=12/s, Flash=28/s -
Hi,
Using Flash I can have a frame rate about 28 fps, but I do not exceed 12 fps using VB.Net.
I use avicap32.dll functions. Same using CallBack functions then a Timer event.
I test all internet sources I could find, but no one do better... even if they parameter a fast frames rate.
Financial Aid -
Hey anyone know any way of obtaining financial aid in the US for further education. I am going to be studying there and I am aware of the FAFSAA(the govenrment financial aid) but I do not qualify for that as it is only for citizens and permanent residents and I am not either of the two
Is there anybody out there(apologies to Pink Floyd) -
I put this in my code, using the inbuilt financial function Rate:
dim RetVal as Double
RetVal = Rate(12, 1000, 10000)
When I run this I get a VB error #5, invalid procedure call or argument. Where am I going wrong?
According to the object browser, it is defined as:
Functio
DLLs, Functions & ASP -
I want to create a dll with public functions to be used in
ASP pages. Similar to the way regular vbscript functions are used. Ie. Date1 = FormatDateTime(Date2, 2)
I would like to create my own function -- for example,
FormatString -- and call it from an ASP page.
To avoid the
Font Test -
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
rate dee-u
Dynamic code.. possible with vbscript maybe -
Hey, this is a far fetched idea I have but wanted to see if it was possible just the same.
Is there anyway to load some dynamic code into a program (at run time) that could access the various functions in the program as if it was built in?
I'm looking for an easy way to perform s
looping problems (help) -
How do I change both For...Next statements to Do...Loop statements.
'declare variables
Dim term As Integer
Dim principal, rate, payment As Double
Try
'assign input to a variable
principal = Double.Parse(Me.uiPrincipalTextBox.Text)
'display the years in the heading
Me.u
creating Dll in VB for VBScript Code -
My project is coded in vbscript.I would like overcome the interpretive overhead by converting part of my code(a major functionality which mainly has function calls to other VBscript functions) into a Dll using VB.
Is it possible to have vbscript function calls in a Dll created in VB??
A class question... -
I have come across a design issue (programming in vb.net) . It would be helpful if any one share their opinion about this .
I am trying to design a class and I wanted to make sure I am in the right path...
A 'Rate' is an interest rate at a specific maturity (Term on X-axis and
More on datagrids -
Hi again guys
I am developing a form with a datagrid and would like to display one of the column as a combobox. Is there anyone that can give me an idea of how to insert the right code to the grid?
I have attached the code below. The 8th column is the one I would like to be a com
Question about a class -
New to OOPS and VB.NET
I am trying to design a class called 'RATE'
The rate object can be a "simple rate" or "Complex rate". The attributes of both simple rate and complex rate are exactly same. Its just that the complex rate is summation of 2 or more simple rat
MSSCRIPTING (Script Control ) Quick help needed with VbScript - adding extra function -
hi,
im just making a program where Vb Script added in a box will be executed. i got all working fine.. & all VbScript functions work. i just wanted to knw hw do i add my own functions like checkIfEmail() and all... hw can i addd them to the script control ?
pls help!
thx
How do I call Vbscript functions from VB.net code behind files -
Hi gang,
I have a problem.
I need to call some VBScript function from my code behind file. Tis is because, only under certain condition, would the Vbscript function be needed to be called.
How do I go about doing it?
Calling a VBScript from within a VBScript -
I have a VBScript that needs to call another VBScript and I'm not sure how to do it. The called VBScript also has 3 command line parameters. Any ideas on this?
Thanks,
Senior VB Developer -
Location : NY
Rate: Open
Length: 6 months+
Senior VB Developer - VB 6.0, Sql Server, Crystal Reports (.net desired)
Financial services experience is requried
Someone who has programmed for financial institutions/investment banks
Ideal profile would include:
Using VBScript for scripting in a VB App.. -
I know this is possible, but as yet I havn't figured out how.. I want to use VBScript (or at least its parser) to do scripting within my VB app.
What I would like it to do is read a file, and run it as if its a vbscript file, but call functions in my app for certain things in the f
Help in Designing Financial Accounting Software -
hi i need some information on how to go about making a business Financial Accounting System... should I use vb 6 nad SQL Server 2000 ?
Calling PHP functions from VB -
Is it possible to call PHP functions from vb or vbscript? If so, how?
ActiveX Control -> HTML/VBScript -
Is it possible for my ActiveX Control loaded on a webpage, to call the VBScript functions and subs defined on that page?
And if, then how do I call them from the ActiveX?
I have tried with calling through the Parent object, but it won't let me access my own subs and functions on
VBScript: Opening Excel Spreadsheets -
How do you properly open an Excel spreadsheet in VBScript? What error messages should I look for? Also, which functions throws those errors?
Any help would be appreciated.
The rate debate.... -
My current client wants me to take a rate cut (to the rate I started on 4 years ago) because he's got lost of CVs through the door recently. What should I do....
VBScript and JScript -
how do i call JScript functions from a VBScript routine on the same page?
Cheers
sql query RESOLVED -
i want to write a sQL which will pick the most uptodate rate.....
eg. table has RoyaltyID, Rate, Datefrom
what i want to return is ALL IDs with its most up-todate rate.....
Help needed in getting the data transfer rate. -
hi,
Can any body help me with getting the data transfer rate. i.e. what is the data rate that is downloading and what is the rate in the upload. For example the way we see in Kazaa or Shareaza etc....
Please help..This wld solve my last problem in the project.
regards.
Rate of return -
Im trying to figure out the 10 year rate of return on an investment. The problem is that i have no clue how to do it. If anybody can lend a hand it would be great.
Im taking an example from an investment book which provides the figures. The growth rate is expected to be 15.2 perce
VBScript & API Question -
Simple question:
Can VBScript call API functions?
VB or VBScript -
Hey, posted this over in VBScript also. I am very new to VBScript. I know VB pretty good though, so hopefully this helps. I am trying to use VB or VBScript to open or pass a command line to Monarch Pro to take a report and put it into a template, that is already created, load it to a
display data from another recordset -
hi guys ,
i have two tables in a access database
Table A have this two data
rate rate id
1.5 A
2.4 B
3.2 C
4.5 D
Table B have this datas
rate(this is taken from rate id) /working hrs/ name
A 8
ActiveX and the Web: The Inside Story -
Am I right in believing thusly:
I am a financial analyst who's looking for the current foreign exchange rate for various currencies every second moment. For this I always telephone Phil de Lucre, the brokers and dealers of the forex markets. They now have a website where I can logon
Activex Components in JavaScript/VBScript -
Hi!
How to call the Activex Control Properties and methods(Subs & functions) through the VBScript or JavaScript. Please help me. Ok bye for now. Have a nice day.
Cheers
Durgarao
Dynamically creating a form and control in a VBscript -
I need to create a VBscript which has 1 form, and at least one control.
I want to prompt the use to change the drive letter.
So I need a form, and a Dir List Box.
However, I don't know how to add a form or control to a vbscript, since it seems to be limited to variant data types
Visual Basic and Scripting - Resolved -
Hi all,
How do you call a VBScript from Visual Basic? I made a vbscript with three functions and I want to be able to use them from a standalone VB project.
Sanctos
RE Core VBscript programming. -
Hi,
Question for you all,
how do you rate and find (if you use them.) the VBScript 5.0 reserved applicational class events
class kai
private sub class_Initialize()
do something
end sub
end class
class hirst
private sub class_Terminate()
do something
end sub
end cla
display data from another table -
hi guys ,
i have two tables in a access database
Table A have this two data
rate rate id
1.5 A
2.4 B
3.2 C
4.5 D
Table B have this datas
rate(this is taken from rate id) /working hrs/ name
A 8
[2005] Help Creatings VBScript Debugger -
Hello All,
I am new to the forums and have searched everywhere on the internet, gathering bits and pieces of information (most of which contradict eachother, and do not actually explain my goal), but I am trying to make a VBScript, JScript IDE.
This program includes syntax highli
How do we rate a post -
Hi,
How do we rate a post in this forum ??
I wanted to rate this thread Webbrowser - MSHTML Library - Why Late Bound?
But when u click the link on the left u go no where!!
The link Rate this post points to this
http://www.vbforums.com/showthread.php?p=2018510#
So it doesn'
Excel Charts -
Here is where I am...
Right now, financial data is stored in my server (mysql). I have the user login to the windows application and when he/she clicks "view finances", the financial results are viewed.
I have a great designed chart in Excel that I would like to insert