venkatesh Sarivisetty
asked on
How to get the output file name as Month Year(September 2017) in VB script
How to get the output file name as Month Year(September 2017) in VB script
Do you want VB Script or VBA?
Even its vbs, you just need to add Excel Object in front of above code:
Set objExcel = CreateObject("Excel.Application")
objExcel.ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.Path & "\Your Folder name" & Format(Date, mmm yyyyy) & ".xlsx"
What type of file is the output file and how have you created/produced it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS SIR. IT WORKED WELL!!!
Please try this:
»bp
MonthYear = MonthName(Month(Date)) & " " & Year(Date)
»bp
Open in new window