How do I

[Matthew Leggett]

I need to find out how to do the following: I have a script to do this Ask User for a variable Create a NEW sheet with the variable name I am able to do some of the above however I need to incorporate some error checking to prevent the script failing. wats the best course of action hope this makes sense to someone

[Steven J Jowett]

Is this a question about VB scripting in MS Excel?

Steve Jowett ------------------------- It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)

[Matthew Leggett]

yes it is

[ChandraRam]

Ok - I guess you need to check for 2 things: 1) Check that the user input is valid (not blank, doesnt contain invalid characters...) 2) Check that the name specified does not already exist as another sheet in the workbook where you want to attempt to create the new sheet (Check the Workbook.Sheets collection) HTH

[Dalek Dave]

I used somethng like this recently. In my case I wanted a new sheet consisting only of data of a particular Suppliers account. But you can see the basis of it and adapt as per necessary.

'request supplier
Dim RequestedSupplier As String
RequestedSupplier = Application.InputBox("Enter Supplier Code", "Supplier Selection", , , , , , 2)
If RequestedSupplier = "" Then End

'UPPER CASE the RESULT
RequestedSupplier = UCase(RequestedSupplier)
'confirm supplier
MsgBox ("You have Selected : " & RequestedSupplier)
'create page
'creates ActNm - Active Sheet name
Dim ActNm As String
With ActiveWorkbook.Sheets
.Add after:=Worksheets(Worksheets.Count)
End With
ActNm = ActiveSheet.Name
On Error Resume Next
ActiveSheet.Name = RequestedSupplier
NoName: If Err.Number = 1004 Then ActiveSheet.Name = InputBox("Enter name for New Sheet")
If ActiveSheet.Name = ActNm Then GoTo NoName
On Error GoTo 0

Hope this helps

------------------------------------ "I'd rather have a bottle in front of me than a frontal lobotomy" - Bob Monkhouse

[Deeprj77]

Hi, Please help me to create pdf file from crystal reports with sub reports and parameters? Thanks, Deepa