help with saving file a csv +some details

[avishain]

Hello there,

im using excel 2007 and i need to save a workbook in a spesfic way:

i want to built a macro and when i click it the workbook will be saved as:

"text"&username&ddmmyyyyhhmm.csv

i need it to be save to :

\\lg\fdfdfd

"text" = a constant text that need to appear each time.

user name= the user name which saved the file

ddmmyyyyhhmm= the exact date when i clicked the macro.

for instance:

i worked today and saved the file exactly at 08:30/

the file will be :

textadmin010820110830.csv


thank you very much

 

[wigi]

Sub wigi()
    ThisWorkbook.SaveAs "\\lg\fdfdfd\" & Environ("Username") & Format(Now, "ddmmyyyyhhmm") & ".csv", xlCSV
End Sub