Copying from WB to WB!
Hi all!
Thanks a bunch Mudraker for those tips. Well, here'z exactly what I tried as suggested . Dim wsData As Worksheet Set wsData = ActiveSheet Workbooks.Add wsData.Copy Befo=ActiveWorkbook.Sheets(1) But, there were 3 macro buttons that I had created in the origina workbook and that also is getting copied along with the other data t the new workbook. But I do NOT need the macro buttons in the ne workbook, just the data (values in columns and rows) in the ne workbook. Is there a way to implement this? I would appreciate your help. Thanks again. Regds, Arun.... Vtec corp -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com