Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Question - Edit Macro | Excel Discussion (Misc queries) | |||
Quick question about "filtering" macro | Excel Discussion (Misc queries) | |||
Quick Macro question - How to delete two rows then skip one - and repeat | Excel Discussion (Misc queries) | |||
MACRO ATTACHED TO A TOOLBAR BUTTON | Excel Programming | |||
Is there a quick way to see which objects have code attached? | Excel Programming |