Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook/worksheets protected- can I allow tab re-naming? | Excel Discussion (Misc queries) | |||
naming a workbook the same as a cell entry | Excel Worksheet Functions | |||
Naming a new Excel workbook in a macro | Excel Worksheet Functions | |||
Auto naming Tabs in a Workbook | Excel Discussion (Misc queries) | |||
Workbook "Sheet" Naming | Excel Discussion (Misc queries) |