Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Combination Press Plough Plane

OT - I need a volunteer Visual Basic guru :)

Posts

OT - I need a volunteer Visual Basic guru :)

#1

OT - I need a volunteer Visual Basic guru :)

Paul Cates - Henderson, KY

>Hello everyone,

I have an 8 yr. old Excel spreadsheet that needs a few changes. While I am fairly proficient in Excel, I am not in VB, and I think some of the changes may require someone with extensive VB skills.

My proposal:

I'll send you the file along with an add-in you'll need to install in Excel to run the spreadsheet. I think the changes are easy for a VB "guru," but then I could be wrong. If we agree on price, then I'll send that amount to WC as a donation.

What do you think?

Re: OT - I need a volunteer Visual Basic guru :)

#2

Chet Kloss

Re: OT - I need a volunteer Visual Basic guru :)

Chet Kloss

>Is the add-in licensed such that you can let me (or anyone else for that matter) install it?

,,,,,,,,Chet

Re: OT - I need a volunteer Visual Basic guru :)

#3

Re: OT - I need a volunteer Visual Basic guru :)

Randy G

>What is the add-in that is needed. I know my way around VB but I don't call myself a guru... there's always someone better.

Re: OT - I need a volunteer Visual Basic guru :)

#4

Re: OT - I need a volunteer Visual Basic guru :)

Paul Cates - Henderson, KY

>I have it on 3 of my computers and it works fine, but to answer your question regarding licensing - I'm not sure. I have a license agreement, but it's not filled out. I'll call the company on Monday since I purchased the add-in ~ 9 yrs. ago and don't remember what type of license I bought.

Re: OT - I need a volunteer Visual Basic guru :)

#5

Re: OT - I need a volunteer Visual Basic guru :)

Paul Cates - Henderson, KY

>It's an add-in that calculates stock option prices, and the add-in is needed to run the spreadsheet. Maybe the changes can be made without the add-in? I don't see why not, now that I think about it...I could run the spreadsheet on my computer to check/debug any VB changes.

Re: OT - I need a volunteer Visual Basic guru :)

#6

Re: OT - I need a volunteer Visual Basic guru :)

Dave Paine

>Sounds like the add-in is basically a purchased VB macro. I am practiced in using VB for database queries, calculations, formulae. I have not got into custom controls, forms, etc.

Happy to take a look and advise if something I want to take on, if you are not able to do the changes yourself.

Most of the challenge of VB is figuring out the syntax. Functions in VB are different than in Excel. Calling Excel functions can be done, but the syntax can be frustrating.

Referencing cells is also frustrating. VB is like java, and the first row is "0". If you reference like Excel, then R1 is row one. Gets even more complicated if the VB code needs to paste a VLOOKUP into a cell.