Save As new woorkbook from Input Name

**Shark Man** · 04-15-2009, 04:05 PM

Hello Experts

I have one line with input box

Please Login or Register  to view this content.

And i want to open new workbook with that name

How do I save the new woorkbook with the name from the InputBox?

Thanks

The Shark Man

**Shark Man** · 04-16-2009, 12:13 AM

Hay experts
I'm sure its easy for you

Shark Man

**nnram123** · 04-16-2009, 02:09 AM

Use the following macro in your excel vba part, hope this will help you.

Sub Test()
Dim wBook As New Workbook
currentsheet = InputBox("Name")
Set wBook = Application.Workbooks.Add
wBook.SaveAs "D:\" & currentsheet & ".xls"
End Sub

Save As new woorkbook from Input Name

LinkBack

Thread Tools

Rate This Thread

Display

Save As new woorkbook from Input Name

Re: Save As new woorkbook from Input Name

Re: Save As new woorkbook from Input Name

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions