• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy data from a website to excel

​
As yours, fantastic ‼ LoL ! And specific too to Chris' name !​
​
A day without a smile is a lost day …​
 
Hi,​
​
it's just an other way than QueryTable or IE piloting …​
​
So just copy my entire code in a new workbook and launch procedure DemoBybel and you will see !​
 
Hi, Chris van der Berg!
Lazy on weekends, aren't you?
If you're talking (as I assume you're) about Marc L's code you could follow two paths:
a) Replicate the worksheet Main part from my solution and assign BK$ variable the result of your selection
b) Replace the direct assignment by an input box
So you have homework...
Regards!
 
Hi SirJB7,

Thanks for the advise, but I don't want to change your code, it works like a charm, after the changes to the constants.

I will follow your suggestions above, just to see the result.

Have a great weekend.

Chris
 
Chris van der Berg said:
The code works 100%, can you add a messagebox, instead of having to change the Book name every time
Click to expand...
Hi, Chris van der Berg!

As per your question I assumed that you were talking about Marc L's solution, which being a demo had the book name hardcoded in the variable BK$. And towards that were my comments.

Now if I misunderstood and you were talking about my code, I'm actually lost, so could you please elaborate?

And regarding the message box, what do you intend the message box to do? Message boxes display (output) information, while the instruction InputBox lets you enter information (input). If you alluded to having displayed the last book retrieved, in my solution it's held in the combo box, and if you wanted to use Marc L's one that's why i told you to replicate that part of mine into Marc L's code. If I'm wrong, again please elaborate and explain in other words what do you want to achieve and in what solution. Thank you.

Regards!
 
Hi SirJB7,

Yes I refer to Marc L's solution.
Basiclly I want an Inputbox where I can enter the Book name, instead of having to change the BK$ every time. I am now following your suggestion to replicate the combo box into Marc L's code.
If that is done, it will solve my question.
The final analysis is that your code is the prefered one, as I can get a Book or the complete Bible depending on my choice.
I assume that if I replicate your combo box into Marc L's code I will get the same result.
I have not done it yet, but will get stated with it later today.


Regards
 
You must log in or register to reply here.
Back
Top