$$Excel-Macros$$ Re: vba excel understanding objects : worksheet

2010-09-28 Thread cyber 1000s
anguage but maybe it has more to do with c++ than with c. Thanks Regards, On Sep 24, 3:45 pm, Stuart Redmann wrote: > On 23 Sep., cyber 1000s wrote: > > > > > > > > > > > Hi cyberspace, > > > I have some c programming background... > > Is it po

Re: $$Excel-Macros$$ vba excel understanding objects : worksheet

2010-09-23 Thread cyber 1000s
Hi, I'm looking for a more general answer about objects in vba like : dim ws as object set ws = worksheets For i = 1 To wkb.Worksheets.Count wkb.Sheets(3).Cells(i, 4) = wkb2.Worksheets(i).Name It's ok until the last line, i understand what little there is to understand (pointed notation?). Bu

$$Excel-Macros$$ vba excel understanding objects : worksheet

2010-09-23 Thread cyber 1000s
Hi cyberspace, I have some c programming background... Is it possible to increment a worksheet object (worksheets collection) in a loop such as below ? Public Sub CopyShNamesFromWkbToWkb2() Dim i As Integer Dim wkb As Object Set wkb = Workbooks("Nouveau_Feuille_Excel_1.xls") Dim wkb2 As