Number Format

[March]

Dear All,

I write VBA code in Access to transfer records in Access to Excel.
I've done with the transferring code, however, I don't know how to set the
cell format in Excel in range using VBA.

As I know is

xApp.sheets("Access").range("A3") = Format(Date, "mm/dd/yyyy")

that only one cell in excel.

I need to set as a range like "A1:J50".

Please give me suggestion.


March

 

[Duane Hookom]

I don't know the exact syntax but can usually find out by using the macro
recorder in Excel and then copying the code into a module. Minor
modifications are needed but should be evident.