Comments by Member 11584553

Member 11584553 8-Sep-15 22:49pm View

I came out with a different approach...

I need to write a batch file that copies a file to existing folder and renames it with current month and year. I used the below code

At the moment, my batch file consists of only this command:

**@ECHO OFF
copy /y D:\SalesMixExp\Sales_Mix_v1.2_082015.xlsx D:\SalesMixExp\Sales_Mix_v1.2_092015.xlsx**

It works fine. But every time i need to change the newly created filename with current month and year. i.e for ex: 092015 in my filename is **sep2015** and for next month it should be automatically renamed as **Sales_Mix_v1.2_102015.xlsx**...Please help me in resolving my problem

Member 11584553 7-Sep-15 0:11am View

Actually SalesItem is a view name(which i used above) . In that view i joined 3 different tables. when i execute view i get 8 Columns.That data should be automatically exported as pivot table every month.

Member 11584553 6-Sep-15 21:45pm View

Thank you Tomas Takac. Actually creation of Excel file and conversion into pivot table should be done automatically at the beginning of every month. How should i do that

Member 11584553 6-Sep-15 21:38pm View

Deleted

Thank you Tomas Takac. Actually creation of Excel file and conversion into pivot table should be done automatically at the beginning of every month. How should i do that

Comments by Member 11584553 (Top 4 by date)