Visual Basic Syntax - Where is ThisWorkbook.Sheets("xx") ?? Unable to resolve 'ThisWorkbook'

Author

Where is ThisWorkbook.Sheets("xx") ?? Unable to resolve 'ThisWorkbook'

Eric W

2006-03-14, 7:02 pm

I am converting an EXCEL VBA application to Visual Basic (2003).

I am not having much luck finding how to convert statements containing
references to things like ThisWorkbook.Sheets("sheetname").

I am not using Visual Studio Tools (which may be my problem)... I would
think that I don't really need the templates --- or do I??

Eric

Ken Halter

2006-03-14, 7:02 pm

"Eric W" <xxx@wzone.com> wrote in message
news:pan.2006.03.14.21.32.26.905547@wzone.com...
>I am converting an EXCEL VBA application to Visual Basic (2003).

You'll want to post that question in a .Net group.
They all contain "dotnet" or "vsnet" in their names.
This and all other groups on the MS server that start with
"microsoft.public.vb"
are for VB Classic (mostly VB5/6) and were in existance long before any .Net
products were released. While some of the code looks the same, they are very
different products and require a different set of groups.

Try one of these:
news://news.microsoft.com/microsoft....dotnet.general
news://news.microsoft.com/microsoft...et.languages.vb
news://news.microsoft.com/microsoft...ges.vb.controls
news://news.microsoft.com/microsoft...amework.interop

--
Ken Halter - MS-MVP-VB - Please keep all discussions in the groups..
DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm

Sponsored Links