Hi All,
My version is 2007.
I'm getting news headers from a web site using the "import data from a web page"
Cell A1 is the header of Number 1 news in that source web site.
What I want is; Excel to read it to me when this Cell A1 updates itself and changes.
I've seen a similar thread here and tried this VBA:
***********************************************
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, c As Range, ir As Range
Set r = Range("A1")
Set ir = Application.Intersect(Target, r)
If ir Is Nothing Then Exit Sub
For Each c In Range("A1")
c.Speak
Next c
End Sub
***********************************************
I've saved the file as Excel Macro-Enabled Workbook and enabled macros but not doing anything.. Do I have to do anything else like compiling or activating the macro or something else? Or is the code wrong? As you can see I'm not familiar with VBA or Macros..
Any idea??
Thanks in advance..
cheers,
mem
My version is 2007.
I'm getting news headers from a web site using the "import data from a web page"
Cell A1 is the header of Number 1 news in that source web site.
What I want is; Excel to read it to me when this Cell A1 updates itself and changes.
I've seen a similar thread here and tried this VBA:
***********************************************
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, c As Range, ir As Range
Set r = Range("A1")
Set ir = Application.Intersect(Target, r)
If ir Is Nothing Then Exit Sub
For Each c In Range("A1")
c.Speak
Next c
End Sub
***********************************************
I've saved the file as Excel Macro-Enabled Workbook and enabled macros but not doing anything.. Do I have to do anything else like compiling or activating the macro or something else? Or is the code wrong? As you can see I'm not familiar with VBA or Macros..
Any idea??
Thanks in advance..
cheers,
mem