Workbook naming probz!
 

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
--
Message posted from http://www.ExcelForum.com

Workbook naming probz!
 

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

--
Message posted from http://www.ExcelForum.com