Prev: macro for post editing: can't close loop
Next: Excel automation: how to open a blank spreadsheet
From: JCO on 8 Jun 2010 10:39
I have a VB macro. I want to move it to a VB application, using my VS 2008.
I don't know how to get the Application to run against an Excel Worksheet.
Can someone help?
Thanks

From: Bob Butler on 8 Jun 2010 10:49
"JCO" <someone(a)somewhere.com> wrote in message
news:%23GDVlhxBLHA.4308(a)TK2MSFTNGP04.phx.gbl...
>I have a VB macro. I want to move it to a VB application, using my VS
>2008.

If you mean a VBA macro then moving it to VB is usually pretty easy but VS
2008 is not VB, it is VB.Net, and that's a very different language. This
group is for VB 6 and earlier versions and doesn't address any VB.Net
questions.

You should search at microsoft.com for a "VB forum" where somebody will be
happy to provide the party line on how to rewrite your code to be "more
modern".


From: Auric__ on 8 Jun 2010 12:40
On Tue, 08 Jun 2010 14:49:52 GMT, Bob Butler wrote:

> "JCO" <someone(a)somewhere.com> wrote in message
> news:%23GDVlhxBLHA.4308(a)TK2MSFTNGP04.phx.gbl...
>>I have a VB macro. I want to move it to a VB application, using my VS
>>2008.
>
> If you mean a VBA macro then moving it to VB is usually pretty easy but VS
> 2008 is not VB, it is VB.Net, and that's a very different language. This
> group is for VB 6 and earlier versions and doesn't address any VB.Net
> questions.
>
> You should search at microsoft.com for a "VB forum" where somebody will be
> happy to provide the party line on how to rewrite your code to be "more
> modern".

Well... the VBA/VB6/whatever-you-want-to-call-it importer for 2008 isn't
*too* bad. OP could save the VBA to a .bas file, then import it.

--
My ears can't hear what you say to me.
From: Bob Butler on 8 Jun 2010 12:43

"Auric__" <not.my.real(a)email.address> wrote in message
news:Xns9D916257E9E90auricauricauricauric(a)69.16.185.250...
> On Tue, 08 Jun 2010 14:49:52 GMT, Bob Butler wrote:
>
>> "JCO" <someone(a)somewhere.com> wrote in message
>> news:%23GDVlhxBLHA.4308(a)TK2MSFTNGP04.phx.gbl...
>>>I have a VB macro. I want to move it to a VB application, using my VS
>>>2008.
>>
>> If you mean a VBA macro then moving it to VB is usually pretty easy but
>> VS
>> 2008 is not VB, it is VB.Net, and that's a very different language. This
>> group is for VB 6 and earlier versions and doesn't address any VB.Net
>> questions.
>>
>> You should search at microsoft.com for a "VB forum" where somebody will
>> be
>> happy to provide the party line on how to rewrite your code to be "more
>> modern".
>
> Well... the VBA/VB6/whatever-you-want-to-call-it importer for 2008 isn't
> *too* bad. OP could save the VBA to a .bas file, then import it.

It couldn't be worse than the original "uprade" wizard. Regardless, it's
off-topic for this group.

> My ears can't hear what you say to me.

You work for Microsoft?


From: Paul Clement on 8 Jun 2010 12:59
On Tue, 8 Jun 2010 09:39:26 -0500, "JCO" <someone(a)somewhere.com> wrote:

� I have a VB macro. I want to move it to a VB application, using my VS 2008.
� I don't know how to get the Application to run against an Excel Worksheet.
� Can someone help?
� Thanks

Not sure if I fully understand your question, but if you're attempting to run Excel from Visual
Basic.NET then I would post to the below forum (and provide a little more detail):

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/threads


Paul
~~~~
Microsoft MVP (Visual Basic)
 |  Next  |  Last
Pages: 1 2 3 4
Prev: macro for post editing: can't close loop
Next: Excel automation: how to open a blank spreadsheet