A Runtime Error with an Excel Sheet Operating on VBA

[indraji2001]

First of all I acknowledge that I have no knowledge about VBA. I use an Excel Sheet based on VBA. But recently whenever I am going to operate this file Runtime error is coming.

I cannot understand how I will attach that excel file ? Without attaching the file it is very difficult to explain the nature of the problem.

So experts are being request please tell me how to attach my file?
Regards

 

[Rick Rothstein]

First of all I acknowledge that I have no knowledge about VBA. I use an Excel Sheet based on VBA. But recently whenever I am going to operate this file Runtime error is coming.

I cannot understand how I will attach that excel file ? Without attaching the file it is very difficult to explain the nature of the problem.

So experts are being request please tell me how to attach my file?

You cannot attach a file in this forum; rather, what you can do is post a copy of your workbook to DropBox and then post the link they give you for your file.

 

[indraji2001]

@Rick

Ok the drop box link of this file is: https://www.dropbox.com/preview/Excel project 1_With Cells Filled Up.xlsm?role=personal

In this worksheet
At first I put the list of the name of the symbols in the sheet entitled "List of Pre-added Symbols"
Secondly, in the Sheet "Symbols" I push the button "Copy Over". After that I push the button "Run". Immediately all the cells in the column "EXCHANGE" will be filled up "NSE", all the cells in the column "TYPE" will be filled up "STOCK", all the cells in the column "Currency" will be filled up "INR", all the cells in the column "MINTICK" will be filled up BY "0.01" and the Cells in the Column "DESCRIPTION" will be be pulled from Google Finance Website. From the Google Finance Website the full name of the company against the corresponding symbol will be pulled in.

e.g if I Put SBIN and exchange NSE, the name of the company "State Bank of India" will be appeared in the corresponding "Description" column . this name will be fetched from the google finance site:https://www.google.com/search?tbm=f...IAebjiZJ0#scso=uid_gQ3JWs_kHqKOvQSg4q-oCA_5:0

similarly
e.g if I Put ABAN and exchange NSE, the name of the company "Aban Offshore Ltd Fully Paid Ord. Shrs" will be appeared in the corresponding "Description" column . this name will be fetched from the google finance site:https://www.google.com/search?tbm=f...hNt-BT790#scso=uid_wA3JWu2sHcruvASgvruABQ_5:0

Hope I could present what I want in this worksheet.

 

[indraji2001]

@Rick

Ok the drop box link of this file is: https://www.dropbox.com/preview/Excel project 1_With Cells Filled Up.xlsm?role=personal

I am attaching a worksheet. The purpose of this worksheet is to pull the name of the Companies (against the corresponding symbol) from Google Finance. This worksheet is not presently working and showing the runtime error.

I am trying to represent the whole thing at the level of my best....

How this Worksheet Operates:
At first step I put the list of the name of the symbols in the sheet entitled "List of Pre-added Symbols"

In the second step, in the Sheet "Symbols" I push the button "Copy Over" to copy the list of symbols from the sheet entitled "List of Pre-added Symbols". After that I push the button "Run". Immediately all the cells in the column "EXCHANGE" will be filled up "NSE", all the cells in the column "TYPE" will be filled up "STOCK", and all the cells in the column "Currency" will be filled up "INR", all the cells in the column "MINTICK" will be filled up BY "0.01" and the Cells in the Column "DESCRIPTION" will be be pulled from Google Finance Website. From the Google Finance Website the full name of the company against the corresponding symbol will be pulled in.

e.g if the symbol is "ADANIENT" => the exchange name will be "NSE", and the name of the company "Adani Enterprise Ltd" will be appeared in the corresponding "Description" column . this name will be fetched from the google finance site: https://www.google.com/search?tbm=f...Hr-t8QYBs#scso=uid_m6jJWtvxL8T8vgTKj6ngDg_5:0

similarly
e.g if the symbol is "ABB" => the exchange name will be "NSE", and the name of the company "ABB India Ltd" will be appeared in the corresponding "Description" column . this name will be fetched from the google finance site: https://www.google.com/search?tbm=f...g3UfoZlfM#scso=uid_wKXJWsKcCp2SvQS2uqv4Bw_5:0

The case is like this(Screenshots):
https://ibb.co/ciPGPx
https://ibb.co/hb5vHH

The Runtime Error is coming like this:
https://ibb.co/nAo4Bc

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...-to-pull-information-from-google-finance.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[indraji2001]

@Fluff
Thanks for your response. Yes I did the cross posting. Actually I am at a loss. Did hot get any solution still no. But really I need this solution from subject experts.
I will definitely keep your valuable comments in mind. I will request you and also other respectable members if they can help me to get this solution.
Regards

 

[indraji2001]

@Fluff
Please delete the post from this forum

 

[indraji2001]

Ref: Cross-Post on this same topic: https://www.excelforum.com/excel-pr...mation-from-google-finance-2.html#post4879348