Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IS THERE ANYONE WHO CAN SOLVE MY PROBLEM ..(JOEL , MIKE H , RON ,PETER , BOB) ANYONE....
Hi all, I have code below which save the current worksheet in
folder "Record" with the name "Rec" Private Sub CommandButton1_Click() Me.Select Me.Copy ActiveWorkbook.SaveAs Filename:="C:\Documents\Record\Rec.xlsm", FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False ActiveWindow.Close End Sub I want to give name "Rec" to all my files in same folder but I want macro to put 1 , 2 , 3… etc at the end of every file name. How can I change above macro that it should first check the folder "Record" if there is any file with the name "Rec" and if there is then it should put 1 at the end of the file and save it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I solve this problem? Please help me | Excel Discussion (Misc queries) | |||
Pls help me to solve this problem... | Excel Worksheet Functions | |||
How to solve this problem? | Excel Programming | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
A problem to solve, a little help | Excel Programming |