Save As and Save Not
 

Hi

I have a macro as follows:-

(The Workbook name is - "Personal Data")

Sub New_Name()
Application.EnableEvents = False
Application.Run "Open_All_Sheets"

Dim inputText As String
inputText = Application.InputBox("Enter name here", _
"Persons Name", , , , , 2)

Sheets("Data Input").Range("D1:H1").Value = inputText

Worksheets("Data Input").Buttons("Name_Button").Visible = False
'Worksheets("Data Input").Buttons("Name_Button").Visible = True

Application.Run "Lock_All_Sheets"
Application.EnableEvents = True

End Sub

What I would like to do is - as part of this macro - have the workbook saved
as
"Personal Data-inputText", where 'inputText' is from the InputBox. Then
have the original file close without saving.

I know I am well out of my depth on this one so your help would be
gratefully appreciated.

Sandy

Save As and Save Not
 

Sub New_Name()
Application.EnableEvents = False
Application.Run "Open_All_Sheets"

Dim inputText As String
inputText = Application.InputBox("Enter name here", _
"Persons Name", , , , , 2)

Sheets("Data Input").Range("D1:H1").Value = inputText

Worksheets("Data Input").Buttons("Name_Button").Visible = False
'Worksheets("Data Input").Buttons("Name_Button").Visible = True

Application.Run "Lock_All_Sheets"

ThisWorkbook.SaveCopyAs "Personal Data-" & inputText.Text
ThisWorkbook.Close SaveChanges:=False
Application.EnableEvents = True

End Sub


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sandy" wrote in message
...
Hi

I have a macro as follows:-

(The Workbook name is - "Personal Data")

Sub New_Name()
Application.EnableEvents = False
Application.Run "Open_All_Sheets"

Dim inputText As String
inputText = Application.InputBox("Enter name here", _
"Persons Name", , , , , 2)

Sheets("Data Input").Range("D1:H1").Value = inputText

Worksheets("Data Input").Buttons("Name_Button").Visible = False
'Worksheets("Data Input").Buttons("Name_Button").Visible = True

Application.Run "Lock_All_Sheets"
Application.EnableEvents = True

End Sub

What I would like to do is - as part of this macro - have the workbook
saved as
"Personal Data-inputText", where 'inputText' is from the InputBox. Then
have the original file close without saving.

I know I am well out of my depth on this one so your help would be
gratefully appreciated.

Sandy

Save As and Save Not
 

Hi Bob

When I insert the two lines you suggest I get an error message 'Invalid
Qualifier' with the inputText in the SaveCopyAs line highlighted.

I tried deleting the '.Text' at the end of the line and it saved as - but
not as an excel file.

Any ideas?

Sandy

"Bob Phillips" wrote in message
...
Sub New_Name()
Application.EnableEvents = False
Application.Run "Open_All_Sheets"

Dim inputText As String
inputText = Application.InputBox("Enter name here", _
"Persons Name", , , , , 2)

Sheets("Data Input").Range("D1:H1").Value = inputText

Worksheets("Data Input").Buttons("Name_Button").Visible = False
'Worksheets("Data Input").Buttons("Name_Button").Visible = True

Application.Run "Lock_All_Sheets"

ThisWorkbook.SaveCopyAs "Personal Data-" & inputText.Text
ThisWorkbook.Close SaveChanges:=False
Application.EnableEvents = True

End Sub


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Sandy" wrote in message
...
Hi

I have a macro as follows:-

(The Workbook name is - "Personal Data")

Sub New_Name()
Application.EnableEvents = False
Application.Run "Open_All_Sheets"

Dim inputText As String
inputText = Application.InputBox("Enter name here", _
"Persons Name", , , , , 2)

Sheets("Data Input").Range("D1:H1").Value = inputText

Worksheets("Data Input").Buttons("Name_Button").Visible = False
'Worksheets("Data Input").Buttons("Name_Button").Visible = True

Application.Run "Lock_All_Sheets"
Application.EnableEvents = True

End Sub

What I would like to do is - as part of this macro - have the workbook
saved as
"Personal Data-inputText", where 'inputText' is from the InputBox. Then
have the original file close without saving.

I know I am well out of my depth on this one so your help would be
gratefully appreciated.

Sandy