Quick question on a small Macro attached!
 

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

Quick question on a small Macro attached!
 

Most of us will not download files.

I get round this problem by adding a line of code to save the fil
again with the original name

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