Workbook naming probz!

A

aiyer

Hi all!

A quick question on the macro that I am attaching here with.
As we can see, I am just trying to copy contents from a worksheet
vextec' present in a workbook 'Vtec'.
into a newly added sheet in the workbook named as 'FEV'. However th
user has the freedom to save the new new sheet with a name into a tex
format, as can be seen in the macro.

But here is the problem. When the user names and saves the added shee
(*.fev, where the name is specified by the user), the workbook als
gets renamed as the *.fev file (specified by the user).
I do not want the workbook name to be changed at all and it has to hav
the same name 'vtec.xls'.

Any help on this would be greatly appreciated guys.

Thanks alot.

Arun.
Vtec corp

Attachment filename: sample.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=54287
 
M

mudraker

aiyer

You have no mention in your code of a new workbook

You add the new sheet into the same workbook that contains your vexte
sheet


If the new book is open

try changing
Set NewSh = Worksheets.Add

to

Set NewSh = workbooks("BookName").Worksheets.Add

If not open then you will need to add a new workbook before adding
new sheet or renaming sheet1 to fe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top