Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm having problems copying an excel workbook the way I want to.
I currently have a MasterCopy.xls with data on Sheet1 and all my macros imported. I need to create a new workbook (I called it Junk Test.xls) and copy the first sheet of MasterCopy.xls onto JunkTest.xls. However, I don't want the new Junk test workbook to have any of the VBA macro stuff in it. I can't figure out how to do that. Here's a basic look at what I have: Private Sub Workbook_Open() Dim sDest As String sDest = "C:\Documents and Settings\rb012653\Desktop" Data_Mover.SaveCopy sDest End Sub ~~~In my Data_Mover Module~~~~~ Public Sub SaveCopy(sDest As String) Dim NewWB As Workbook Set NewWB = Workbooks.Add(sDest & "\Junk Test.xls") 'I've tried lots of copy commands here without any luck. End Sub Whenever I try and open the new JunkTest.xls file I also get the following error: Runtime error '1004': Cannot access 'JunkTest.xls.' This is my first time posting, so I appologize if it is in another thread. I've searched all over and couldn't find anything to help me figure this one out. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Delete Another WorkBook Macros using Macros.. Possible? | Excel Programming | |||
How to copy a workbook so the buttons run the macros? | Excel Discussion (Misc queries) | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Copy Macros and VB code from one workbook to another | Excel Programming |