Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exce Macros
Sorry there is a small goof in my original code. Try this...
Sub ModifyOtherBook() Dim wbkTarget As Workbook On Error Resume Next Set wbkTarget = Workbooks("That.xls") On Error GoTo 0 If wbkTarget Is Nothing Then Set wbkTarget = Workbooks.Open("C:\That.xls") wbkTarget.Sheets("Sheet1").Range("A1").Value = "Tada" End Sub -- HTH... Jim Thomlinson "LPS" wrote: Thank you. I will experiment with this and I'm sure it will help. -- LPS "Jim Thomlinson" wrote: Here is a very basic example. It modifies a workbook called That.xls. It first checks if the book is open. if not it opens it. There is a workbook object called wbkTarget that gives you a reference to the workbook we are manipulating. The code is running in "ThisWorkbook". Sub ModifyOtherBook() Dim wbkTarget As Workbook On Error Resume Next Set wbkTarget = Workbooks("That.xls") On Error GoTo 0 If wbkTarget Is Nothing Then Workbooks.Open ("C:\That.xls") wbkTarget.Sheets("Sheet1").Range("A1").Value = "Tada" End Sub -- HTH... Jim Thomlinson "LPS" wrote: Hi Jim. Thank you for such a fast response. I want to be able to manipulate a second workbook from a macro I start in the first workbook. It doesn't matter where the execution ends. -- LPS "Jim Thomlinson" wrote: Yes...ish but we need a little more clarification. Do you want to 1. manipulate another workbook 2. run code that exists in another workbook Bare in mind the the thread of execution will always end in the workbook that began the process, but that workbook does not need to be the active workbook when the code ends. -- HTH... Jim Thomlinson "LPS" wrote: Using Excel 2000 can you create a macro that works across more than one workbook? For example, can a macro start running in one workbook and finish in another? If so, is there any special code or actions you need to do to make it work? Thanks, -- LPS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exce Formating | Excel Worksheet Functions | |||
How do I keep a running average of a row in exce; | Excel Discussion (Misc queries) | |||
Exce file security | Excel Discussion (Misc queries) | |||
stopping the link of macros in one workbook with every other exce. | Excel Discussion (Misc queries) | |||
stopping the link of macros in one workbook with every other exce. | Excel Discussion (Misc queries) |