Formatting an Excel from Access vba.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CyndyG - 26 May 2005 16:47 GMT

I have an Excel spreadsheet that is created each time an Access form is
executed.

wks.cells(j, .Fields("MonthNumber") * 2 + 1) = .Fields("Total")
.MoveNext

Could some one tell what I code to format the Total field in an accounting
format . When I ran an Excel Macro this is the code I received:
Range("K3").Select
Selection.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($*
""-""??_);_(@_)"
which is what I want,but don't know how to get it to be accepted in Access.

I am getting errors such as method not found or invalid format.

Reply to this Message

Klatuu - 26 May 2005 17:19 GMT

Cyndy,

I have had the same problem. It doesn't make sense to me that passing an
Excel format from Access should object to Excel formatting; however, try this
and see if it gives you the result you need:

Selection.NumberFormat = "$#,##0.00);($#,##0.00);"-""

> I have an Excel spreadsheet that is created each time an Access form is
> executed.
[quoted text clipped - 10 lines]
>
> I am getting errors such as method not found or invalid format.

Reply to this Message

CyndyG - 26 May 2005 18:47 GMT

THanks,but still does not work,

> Cyndy,
>
[quoted text clipped - 18 lines]
> >
> > I am getting errors such as method not found or invalid format.

Reply to this Message

Klatuu - 26 May 2005 18:58 GMT

Try it this way

Selection.NumberFormat = "$#,##0.00);($#,##0.00); - "

> THanks,but still does not work,
>
[quoted text clipped - 20 lines]
> > >
> > > I am getting errors such as method not found or invalid format.

Reply to this Message