Prev: Auto-Protect Sheet on Open and on Close
Next: Retrieving Archived (EAS) Outlook Attachment
From: Carlos Mallen on 7 Oct 2009 09:51
Hi,

I'm using Visual Studio 2008 Professional Edition and Microsoft Office 2003
and working with an Excel 2003 Workbook template. The language I'm using is
Visual Basic.

When I'm in one of Excel's objects (like a worksheet), I can refer to
objects like in Me.Application.Workbooks(1). However, when I insert a new
module, I can't use the same syntax, because Visual Basic does not recognize
it. For what I know, I must use CType instead, but I don't know how to use
it.

Can anyone help me? It would be of great help if someone could give me an
example of how refer to a workbook, like in:

Dim wbk As Excel.Workbook
wbk = CType(x,Excel.Workbook)

Thanks in advance,

--
Carlos Mallen
From: Patrick Molloy on 7 Oct 2009 09:58
make sure that you have a refence set to the Microsoft Excel Library

dim xlApp as Excel.Application
dim xlWb as Excel.Workbook
dim xlWs as Excel.Worksheet
'instantiate excel
set xlApp = New Excel.Application
set xlWb = xlApp.Workbooks.Open("**path & file name**")
set xlWs = xlWb.Worksheets("Sheet1")

does this help?



"Carlos Mallen" wrote:

> Hi,
>
> I'm using Visual Studio 2008 Professional Edition and Microsoft Office 2003
> and working with an Excel 2003 Workbook template. The language I'm using is
> Visual Basic.
>
> When I'm in one of Excel's objects (like a worksheet), I can refer to
> objects like in Me.Application.Workbooks(1). However, when I insert a new
> module, I can't use the same syntax, because Visual Basic does not recognize
> it. For what I know, I must use CType instead, but I don't know how to use
> it.
>
> Can anyone help me? It would be of great help if someone could give me an
> example of how refer to a workbook, like in:
>
> Dim wbk As Excel.Workbook
> wbk = CType(x,Excel.Workbook)
>
> Thanks in advance,
>
> --
> Carlos Mallen
From: Carlos Mallen on 7 Oct 2009 10:07
Thanks for your answer. I'm afraid it doesn't help because in Visual Basic
"Set" is not used to refer to objects. Although some things are similar, it
differs form Visual Basic for Applications, which is the language you used to
give me the example.

Thanks again,
--
Carlos Mallen


"Patrick Molloy" wrote:

> make sure that you have a refence set to the Microsoft Excel Library
>
> dim xlApp as Excel.Application
> dim xlWb as Excel.Workbook
> dim xlWs as Excel.Worksheet
> 'instantiate excel
> set xlApp = New Excel.Application
> set xlWb = xlApp.Workbooks.Open("**path & file name**")
> set xlWs = xlWb.Worksheets("Sheet1")
>
> does this help?
>
>
>
> "Carlos Mallen" wrote:
>
> > Hi,
> >
> > I'm using Visual Studio 2008 Professional Edition and Microsoft Office 2003
> > and working with an Excel 2003 Workbook template. The language I'm using is
> > Visual Basic.
> >
> > When I'm in one of Excel's objects (like a worksheet), I can refer to
> > objects like in Me.Application.Workbooks(1). However, when I insert a new
> > module, I can't use the same syntax, because Visual Basic does not recognize
> > it. For what I know, I must use CType instead, but I don't know how to use
> > it.
> >
> > Can anyone help me? It would be of great help if someone could give me an
> > example of how refer to a workbook, like in:
> >
> > Dim wbk As Excel.Workbook
> > wbk = CType(x,Excel.Workbook)
> >
> > Thanks in advance,
> >
> > --
> > Carlos Mallen
 | 
Pages: 1
Prev: Auto-Protect Sheet on Open and on Close
Next: Retrieving Archived (EAS) Outlook Attachment