Prev: Adding textboxes based on what user inputs in Total Students textb
Next: VLOOKUP - help
From: Guitarzann on 29 Jan 2010 13:12
Greetings,

I am trying to find the VB code to create a process where the workbook can
be saved on the same folder without overwriting the existing workbook.
Multiple people will be dropping their copies of the workbook onto the same
folder.

The goal is to have the folder contain files to look like:
Master (1),
Master (2),
Master (3), etc.

Thanks for your help!
Rick

From: Don Guillett on 29 Jan 2010 13:31
Sub saveworkbookas()
dim i as long
dim fname as string
For i = 1 To 3
fname = "Master" & i & ".xls"
MsgBox fname
ActiveWorkbook.SaveAs Filename:=fname
Next i
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Guitarzann" <Guitarzann(a)discussions.microsoft.com> wrote in message
news:B3B08893-48FB-4216-9893-9F4529433707(a)microsoft.com...
> Greetings,
>
> I am trying to find the VB code to create a process where the workbook can
> be saved on the same folder without overwriting the existing workbook.
> Multiple people will be dropping their copies of the workbook onto the
> same
> folder.
>
> The goal is to have the folder contain files to look like:
> Master (1),
> Master (2),
> Master (3), etc.
>
> Thanks for your help!
> Rick
>

 | 
Pages: 1
Prev: Adding textboxes based on what user inputs in Total Students textb
Next: VLOOKUP - help