Put data to another excel open by Shell function

Hoang · June 29th, 2009, 06:50 AM

Hi evey one !

1. Can I write some data to another excel open by Shell("c:\EXCEL\EXCEL.EXE",1) ? For example put data to cell "C1".
2. Can I run Worksheet_Change(ByVal Target As Excel.Range) only when cell "A2" change the other cells's value change it not run ?

Many thanks.

Shasur · June 29th, 2009, 09:11 PM

Hi

Is there any specific reason for you to use Shell? Why it be done using VBA?

For your second query. Can you try the following:

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$2" Then
        MsgBox "Do something"
    Else
        ' Do nothing
    End If
End Sub

Cheers
Shasur

Hoang · June 30th, 2009, 12:04 PM

Hi Shasur !

Thanks very much for your excellent answer on second query.
on first query I use AppActivate funtion to active an workbook open by Shell function the workbook have some command needed to run on time, when the workbook having VBA code AppActivate update data every time

Cheers.
Hoang

Shasur · July 5th, 2009, 03:11 AM

Hi

Will the Workbooks_Open event help?

Code:

Private Sub Workbook_Open()
   Sheets(2).Range("c1").Value = "Hoang"
End Sub

Cheers
Shasur

Hoang · July 7th, 2009, 11:32 PM

Hi Shasur !

Thanks very much for your help.

Cheers.
Hoang