Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
Is it possible to copy cell contents between instances of
excel?? I cannot get the following code to work. Can anyone tell me why? Application.Workbooks("book2.xls").Worksheets(Shee t1).Range ("a1").Value = Application.Workbooks ("book1.xls").Worksheets(Sheet1).Range("a1").Va lue |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
Do you get an error? What does it say?
My guess is that your problem is with (Sheet1). When using Workbook.Worksheets, the argument expected is either the numeric index of the worksheet or the name property of the sheet - which is a string. So, try using ("Sheet1") instead (Sheet1). Ray at work "Paul" wrote in message ... Is it possible to copy cell contents between instances of excel?? I cannot get the following code to work. Can anyone tell me why? Application.Workbooks("book2.xls").Worksheets(Shee t1).Range ("a1").Value = Application.Workbooks ("book1.xls").Worksheets(Sheet1).Range("a1").Va lue |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
Do you really mean separate instances of Excel or separate workbooks? If the
latter, you need to enclose the worksheet name in quotes, and you don't need Application, it is implicit. Workbooks("book2").Worksheets("Sheet1").Range("a1" ).Value = _ Workbooks("book1").Worksheets("Sheet1").Range("a1" ).Value -- HTH RP (remove nothere from the email address if mailing direct) "Paul" wrote in message ... Is it possible to copy cell contents between instances of excel?? I cannot get the following code to work. Can anyone tell me why? Application.Workbooks("book2.xls").Worksheets(Shee t1).Range ("a1").Value = Application.Workbooks ("book1.xls").Worksheets(Sheet1).Range("a1").Va lue |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
Thanks Ray,
Tried that but with no joy. also tried (1) in place of ("sheet1") here is the result of f1 Application Property See AlsoApplies ToExampleSpecificsWhen used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. expression.Application expression Required. An expression that returns one of the above objects. Example This example displays a message about the application that created myObject. Set myObject = ActiveWorkbook If myObject.Application.Value = "Microsoft Excel" Then MsgBox "This is an Excel Application object." Else MsgBox "This is not an Excel Application object." End If -----Original Message----- Do you get an error? What does it say? My guess is that your problem is with (Sheet1). When using Workbook.Worksheets, the argument expected is either the numeric index of the worksheet or the name property of the sheet - which is a string. So, try using ("Sheet1") instead (Sheet1). Ray at work "Paul" wrote in message ... Is it possible to copy cell contents between instances of excel?? I cannot get the following code to work. Can anyone tell me why? Application.Workbooks("book2.xls").Worksheets (Sheet1).Range ("a1").Value = Application.Workbooks ("book1.xls").Worksheets(Sheet1).Range("a1").Va lue . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
Thanks Bob,
I am running two instances of excel, i.e. both are running on the same machine. one is book1.xls and the other is book2.xls. Have corrected the quotes problem, but still cannot get it to work. Aslo have tried to set a variable to the value --- also with no luck. -----Original Message----- Do you really mean separate instances of Excel or separate workbooks? If the latter, you need to enclose the worksheet name in quotes, and you don't need Application, it is implicit. Workbooks("book2").Worksheets("Sheet1").Range("a1 ").Value = _ Workbooks("book1").Worksheets("Sheet1").Range("a1 ").Value -- HTH RP (remove nothere from the email address if mailing direct) "Paul" wrote in message ... Is it possible to copy cell contents between instances of excel?? I cannot get the following code to work. Can anyone tell me why? Application.Workbooks("book2.xls").Worksheets (Sheet1).Range ("a1").Value = Application.Workbooks ("book1.xls").Worksheets(Sheet1).Range("a1").Va lue . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
If they're book1.xls, use "book1.xls" and "book2.xls," not "book1"
and "book2." Ray at work "Paul" wrote in message ... Thanks Bob, I am running two instances of excel, i.e. both are running on the same machine. one is book1.xls and the other is book2.xls. Have corrected the quotes problem, but still cannot get it to work. Aslo have tried to set a variable to the value --- also with no luck. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
Paul,
Book1 and book2 are workbooks, they are not necessarily separate instances. If you have two instances of Excel, I assume the code is in one of them. To access the other, you need to go via an application object. But, how do you get a handle to the other on e? AFAIK, when setting a variable to an instance of Excel, you can not pre-determine which you will get. So you might just end up with the same instance as you are in. -- HTH RP (remove nothere from the email address if mailing direct) "Paul" wrote in message ... Thanks Bob, I am running two instances of excel, i.e. both are running on the same machine. one is book1.xls and the other is book2.xls. Have corrected the quotes problem, but still cannot get it to work. Aslo have tried to set a variable to the value --- also with no luck. -----Original Message----- Do you really mean separate instances of Excel or separate workbooks? If the latter, you need to enclose the worksheet name in quotes, and you don't need Application, it is implicit. Workbooks("book2").Worksheets("Sheet1").Range("a1 ").Value = _ Workbooks("book1").Worksheets("Sheet1").Range("a1 ").Value -- HTH RP (remove nothere from the email address if mailing direct) "Paul" wrote in message ... Is it possible to copy cell contents between instances of excel?? I cannot get the following code to work. Can anyone tell me why? Application.Workbooks("book2.xls").Worksheets (Sheet1).Range ("a1").Value = Application.Workbooks ("book1.xls").Worksheets(Sheet1).Range("a1").Va lue . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying from another instance of excel
Assuming you have a controlled environment (i.e., the other instance of XL is
not automagically instantiated), the following tested code will do the job. Option Explicit Sub testIt() #Const doCleanup = False Dim otherXL As Application, thisXLWB As Workbook, _ otherXLWB As Workbook Set otherXL = CreateObject("excel.application") otherXL.Visible = True Set otherXLWB = otherXL.Workbooks.Add() otherXLWB.Worksheets(1).Range("a1").Resize(10, 3).Formula = _ "=row()/column()" Set thisXLWB = Application.Workbooks.Add() '... otherXLWB.Worksheets(1).Range("a1").CurrentRegion. Copy thisXLWB.Sheets(1).Range("a1").PasteSpecial xlValues '... #If doCleanup Then otherXLWB.Close False otherXL.Quit Set otherXLWB = Nothing Set otherXL = Nothing #End If End Sub "Paul" wrote: Thanks Bob, I am running two instances of excel, i.e. both are running on the same machine. one is book1.xls and the other is book2.xls. Have corrected the quotes problem, but still cannot get it to work. Aslo have tried to set a variable to the value --- also with no luck. -----Original Message----- Do you really mean separate instances of Excel or separate workbooks? If the latter, you need to enclose the worksheet name in quotes, and you don't need Application, it is implicit. Workbooks("book2").Worksheets("Sheet1").Range("a1 ").Value = _ Workbooks("book1").Worksheets("Sheet1").Range("a1 ").Value -- HTH RP (remove nothere from the email address if mailing direct) "Paul" wrote in message ... Is it possible to copy cell contents between instances of excel?? I cannot get the following code to work. Can anyone tell me why? Application.Workbooks("book2.xls").Worksheets (Sheet1).Range ("a1").Value = Application.Workbooks ("book1.xls").Worksheets(Sheet1).Range("a1").Va lue . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - New Instance | Excel Discussion (Misc queries) | |||
Excel instance not shutting down | Excel Programming | |||
Excel Instance | Excel Programming | |||
Launch Excel in another instance | Excel Programming | |||
Second instance of Excel | Excel Programming |