Date: Gettin Previous Month

[astropurni]

I am using VBA- through Excel sheet.
I want to populate one particular column with previous month's name and year in the format 'MMM-YY'- how can i do this??

Also, the excel is to be converted to CSV after that (i know to do this). But, i want it in the same format 'MMM-YY'- it shouldnt get converted to the date format of Excel (in number).

Thanks for all the help!

[kadghar]

I am using VBA- through Excel sheet.
I want to populate one particular column with previous month's name and year in the format 'MMM-YY'- how can i do this??

Also, the excel is to be converted to CSV after that (i know to do this). But, i want it in the same format 'MMM-YY'- it shouldnt get converted to the date format of Excel (in number).

Thanks for all the help!

well, you'll have to change the column's excel's format. CVS will keep the date's format.

this might be of help:

Selection.NumberFormat = "mmm-\y\y"

I'll strongly recomend you to use Date Variables in VBA too, so you dont get all mixed up.

[astropurni]

Hi,

I have changed the format of the date- but while converting it to CSV through VB code (cell by cell), the format gets lost.

This is the code that does that:
With Worksheets("ACTUALS")
For r = 1 To .Range("A65536").End(xlUp).Row
s = ""
For c = 1 To 27
If InStr(1, .Cells(r, c), ",") > 0 Then
s = s & """" & .Cells(r, c) & """" & ","
Else
s = s & .Cells(r, c) & ","
End If
'c = c + 1
Next c

a.writeline s 'write line
Next r
End With


Also, how i want to populate one column with the Month_year value (previous month).
How do i go about populating a column in Excel through VBA?

Thanks!


(im actually not a VB technology person.. but am in Data warehousing...so appreciate all the help i can get)