Prev: Navigate from one bookmark to another
Next: Bug in ADO recordset Find method and Sort Desc
From: JCO on 8 Jun 2010 18:40
I have several 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?

I did start a project using VB-Excel template. My Macros are in a .bas file
but when I import it, I get the following error:
"Statements is not valid in a namespace".

Thanks


From: Karl E. Peterson on 8 Jun 2010 18:55
JCO pretended :
> I have several 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?
>
> I did start a project using VB-Excel template. My Macros are in a .bas file
> but when I import it, I get the following error:
> "Statements is not valid in a namespace".

You'd have far better results taking this to the web. VFred folk don't
really get NNTP, it seems. Try here:

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

--
..NET: It's About Trust! http://vfred.mvps.org
Customer Hatred Knows No Bounds at MSFT
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Free usenet access at http://www.eternal-september.org


From: JCO on 8 Jun 2010 19:25
Thanks again

"Karl E. Peterson" <karl(a)exmvps.org> wrote in message
news:humhog$3g3$1(a)news.eternal-september.org...
> JCO pretended :
>> I have several 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?
>>
>> I did start a project using VB-Excel template. My Macros are in a .bas
>> file but when I import it, I get the following error:
>> "Statements is not valid in a namespace".
>
> You'd have far better results taking this to the web. VFred folk don't
> really get NNTP, it seems. Try here:
>
> http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/threads
>
> --
> .NET: It's About Trust! http://vfred.mvps.org
> Customer Hatred Knows No Bounds at MSFT
> ClassicVB Users Regroup! comp.lang.basic.visual.misc
> Free usenet access at http://www.eternal-september.org
>
>
 | 
Pages: 1
Prev: Navigate from one bookmark to another
Next: Bug in ADO recordset Find method and Sort Desc