Home > Archive > Visual Basic > April 2004 > Launching VB app from Excel w/ cell data?
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 |
Launching VB app from Excel w/ cell data?
|
|
|
| I distribute an Excel workbook with several macros for various searches.
I'm thinking that to save file size, I could put all these searches into a
VB app. I'd like to call the VB from a custom toolbar in the workbook. I'm
familiar with calling Word, but I can't find anything that tells me how to
call a VB app. Also, I would need to pass the value of a cell as a string
or number into the VB app. If anyone can point me in the right direction I
would appreciate it.
(I thought I posted this earlier, but I can't find it, even with Google. If
I have double-posted, I'm sorry.)
Ed
| |
| solex 2004-04-27, 11:31 am |
| Ed,
You will need to create and ActiveX DLL and expose the functions (via public
classes and methods). In your Excel WorkBook in the design mode set a
reference to your DLL and you will have access to your functions.
Good Luck
Dan
"Ed" <Ed_Millis@NOSPAM.Hotmail.com> wrote in message
news:OEL18oFLEHA.1388@TK2MSFTNGP09.phx.gbl...
> I distribute an Excel workbook with several macros for various searches.
> I'm thinking that to save file size, I could put all these searches into a
> VB app. I'd like to call the VB from a custom toolbar in the workbook.
I'm
> familiar with calling Word, but I can't find anything that tells me how to
> call a VB app. Also, I would need to pass the value of a cell as a string
> or number into the VB app. If anyone can point me in the right direction
I
> would appreciate it.
>
> (I thought I posted this earlier, but I can't find it, even with Google.
If
> I have double-posted, I'm sorry.)
>
> Ed
>
>
| |
|
| "solex" <solex@nowhere.com> wrote in message
news:eU2Oc3FLEHA.628@TK2MSFTNGP11.phx.gbl...
> You will need to create and ActiveX DLL and expose the functions (via
public
> classes and methods). In your Excel WorkBook in the design mode set a
> reference to your DLL and you will have access to your functions.
Whurf! Okay -so maybe I *don't* want to try this just yet! Dan, you just
went way over my head. I thought I was doing good to look in a folder and
rename each file. I'll wait until I learn some more - like at least enought
to ask intelligent questions. 8> )
Thanks for the response, Dan.
Ed
> "Ed" <Ed_Millis@NOSPAM.Hotmail.com> wrote in message
> news:OEL18oFLEHA.1388@TK2MSFTNGP09.phx.gbl...
a[color=darkred]
> I'm
to[color=darkred]
string[color=darkred]
direction[color=darkred]
> I
> If
>
>
|
|
|
|
|