Change date format to text format

H

Hande

Temp7 = Format(temp4, "yyyy")
Temp8 = Format(Left(MonthName(Month(DateAdd("m", -1, Now_
()))), 3), "mmm")

I have a special database formula in VB editor as shown:
DBR4(""accounts"",""Retail""," & Temp8 & "," & Temp7_
& ",""EUR"")
this formula appears in excel as:
DBR4("accounts","Retail",Oct,2003,"EUR")which gives an
error because Oct and 2003 are not in "".

Temp7 shows up like "2003" and Temp 8 "Oct". To retrieve
the right formula in excel, I have to write them
like ""Oct"" in VB. But with Temp's I can not do that???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell: date and day format 10
Convert Date-as-Text 3
Formatting 0
How to handle date formats with regional settings 5
Date Format 1
Applying formatting to non-continuous named ranges 1
PC date format (M, MM vs. MMM) messes up formula... 3
VBA Date Format 4

Top