Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having troubles using visual basic to paste info from one workbook to another
I'm trying to paste info from one workbook to another, but don't kno much about writing macros. I'm just adjusting another macro to do wha I need it to do. Here is the working macro I have so far: Dim Markone As String Dim Marktwo As String Dim Markthree As String Dim Markfour As String Dim Markfive As String Dim NewRow As String Markone = Range("A12").Value Marktwo = Range("A13").Value Markthree = Range("A14").Value Markfour = Range("A15").Value Markfive = Range("A16").Value With Worksheets("GIRDER") .Cells(12, 1).Value = Markone .Cells(14, 1).Value = Marktwo .Cells(16, 1).Value = Markthree .Cells(18, 1).Value = Markfour .Cells(20, 1).Value = Markfive End With End Sub I tried typing in "With Workbook("NEW_BOM")" above the "Wit Worksheets("GIRDER")" But didn't work. The macro works fine in th same workbook, but just don't know what to type in to make it go to th other workbook named "BOM_NEW". Any help is appreciated -- dl ----------------------------------------------------------------------- dlb's Profile: http://www.excelforum.com/member.php...fo&userid=1648 View this thread: http://www.excelforum.com/showthread.php?threadid=38280 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste (visual basic) | New Users to Excel | |||
help to paste via visual basic | New Users to Excel | |||
visual basic (copy and paste) | Excel Worksheet Functions | |||
How to hide a workbook and to detect a hidden workbook in visual basic | Excel Programming | |||
Saving Workbook in Visual Basic Hides the Worksheet, Why | Excel Programming |