List of VBA Excel functions that can be used in in MS Access

Where can I 开发者_C百科find a list of VBA Excel functions and references such as .sheet, .insert etc. that can be used in MS Access 2003? I'm opening an Excel sheet from MS Access and would like to format the sheet. I'd like to know what commands/functions are available for formatting.

Is there a reference for this online? Something that can provide information on tasks like adding gridlines, formatting currency, etc.

Perhaps you wish to access the functionality of Excel through Access by using the Excel library? Create a reference and either use the object browser or intellisense to explore Excel.WorksheetFunction.

EDIT Re Comment

You can also explore the Excel libraries for formating and so forth, once the reference to the library is added.