Home > Archive > Visual Basic Syntax > February 2005 > Need VB+Excel help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need VB+Excel help
|
|
| bigg_schwantz@hotmail.com 2005-02-08, 9:02 pm |
|
I bought a program that populates data in a excel spreadsheet. I
have numerous calculations and often the spreadsheet has certain
fields that do not calculate on occasion causing all my totals to be
wrong.
With that in mind I would like to do the calculations in vb which I
know very little about interfacing with excel...
Unfortunately excel does not allow me to force circular referencing so
it is impossible to do latch functions and one shot functions with it
which I really need.
So what I really need is a place to go where I can get help or some
examples on how to interface and communicate with the cells in excel
using vb as I do believe that would be the best solution and keep my
excel sheet calculations small compared to the monster it is now...
Any help on this would be very much appreciated...
thanks,
JJ
| |
|
| Ask for help in the Excel Programming newsgroup - should be able to get your
questions answered there..
Also, check out:
http://mvps.org/dmcritchie/excel/excel.htm
--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
<bigg_schwantz@hotmail.com> wrote in message
news:hmji01h5nsf7vodeuqia777c9sjr0fsc4o@
4ax.com...
>
>
> I bought a program that populates data in a excel spreadsheet. I
> have numerous calculations and often the spreadsheet has certain
> fields that do not calculate on occasion causing all my totals to be
> wrong.
>
> With that in mind I would like to do the calculations in vb which I
> know very little about interfacing with excel...
>
> Unfortunately excel does not allow me to force circular referencing so
> it is impossible to do latch functions and one shot functions with it
> which I really need.
>
> So what I really need is a place to go where I can get help or some
> examples on how to interface and communicate with the cells in excel
> using vb as I do believe that would be the best solution and keep my
> excel sheet calculations small compared to the monster it is now...
>
> Any help on this would be very much appreciated...
>
> thanks,
> JJ
>
>
>
|
|
|
|
|