Need Help in editing macro which is recorded

[svsaug6]

dear,
i have recorded a macro in excel to fetch some data from internet and have assigned to a button in sheet1.
but i want to edit this macro that when i click this button in sheet 1, it should download the data in to second sheet named 'option_chain'
without editing when i click the button it's downloading the data in to first sheet it self. i have changed the name to 'option_chain' but it's giving error. can some one help me in this issue that when i click the button in first sheet it should download the data in to second sheet which named 'option_chain'
my file:
ex1 - Download - 4shared
thank you....

 

[sergioMabres]

I could help you but 4shared requires registering please use skydrive or dropbox to share a file

 

[oldbrewer]

Have you carefully checked quote marks and spaces and colons?

 

[svsaug6]

https://www.dropbox.com/s/ewuhf64d73orbj3/ex1.xlsm

 

[svsaug6]

yes sir, it was working fine before changing the name 'current sheet' to option_chain' but it was updating in first page it self only. i need to update in second sheet that's why i changed the sheet name but failed....

 

[oldbrewer]

change name to current shoot as a test.

 

[sergioMabres]

The probles is that you have changed Activesheet to option_chain
You should have changed Activesheet to Sheets("option_chain")
So line 8 should be
With Sheets("option_chain").QueryTables.Add(Connection:= _
And line 33 should be
With Sheets("option_chain").QueryTables.Add(Connection:= _

Reason is option_chain is not an object is just a name
I hope this helps

 

[svsaug6]

The probles is that you have changed Activesheet to option_chain
You should have changed Activesheet to Sheets("option_chain")
So line 8 should be
With Sheets("option_chain").QueryTables.Add(Connection:= _
And line 33 should be
With Sheets("option_chain").QueryTables.Add(Connection:= _

Reason is option_chain is not an object is just a name
I hope this helps

thank you for your reply...but the problem is with range cell, pls find the debugger screen as follows...

 

[sergioMabres]

the workbook you posted with the changes I suggested does no raise any error
it works fine
sergio

 

[svsaug6]

thank you, it's working fine now.