Re: Documentation/Reference guide

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

as a reference, best is the help file for excel.

John Walkenbach has a good book on Formulas

http://www.j-walk.com/ss/excel

there is a link to his books from there.


There was a very good Excel functions workbook by Peter Noneley at
http://homepage.ntlworld.com/n­oneley/ but that links seems to be gone.

--
Regards,
Tom Ogilvy



"Wescotte" <wescotte@xxxxxxxxxxxxx> wrote in message
news:1117136531.550068.265410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm looking for a good source of MS Office (specifically Excel) related
> functions and objects. Are there any good reference guides or books out
> there?
>


.

Relevant Pages

  • Excel Late Binding with C#
    ... I've been having a real hard time converting some VB.NET Excel Automation ... I have tried may methods to get the Workbook reference such as Item, ... Dim Books As Object 'Excel.Workbooks ... Sheets = Book.Worksheets 'get Sheets reference ...
    (microsoft.public.office.developer.automation)
  • Re: VBA Reference Book?
    ... One of 3 books I would suggest ... VBA For Dummies by John Walkenbach, ... Excel VBA Programmer's Reference by John Green, ...
    (microsoft.public.excel.misc)
  • Re: VS2005 vb.net DLL - interop EXCEL
    ... where you are actually working with Excel via ComInterOp is ... ..NET CLR to release it's reference to the underlying COM object: ... Dim xlAppl As Excel.Application ... It has to do some work with Excel files, so I created a DLL in VS2005. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: VS2005 vb.net DLL - interop EXCEL
    ... where you are actually working with Excel via ComInterOp ... .NET CLR to release it's reference to the underlying COM object: ... Dim xlAppl As Excel.Application ... It has to do some work with Excel files, so I created a DLL in VS2005. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: VS2005 vb.net DLL - interop EXCEL
    ... an explicit Worksheet object reference and don't actually get a Worksheet, ... Dim xl As New Excel.Application ... 'Set up explicit Excel object references... ... xlSheet = xlSheets ...
    (microsoft.public.dotnet.languages.vb)