Log In
Register
Home
June 26, 2016
Offline
Hello everyone, my name is Maurizio
And my new problem is this:
According to you it is possible to derive from a vba code a link of an image that can vary in automatic form.
For example :
The image from full sun; For this his link will be written in a certain way.
Tomorrow: The image gives me Cloudy: For this his link will be written in another way.
For here obtained the Fatitico Link: this should be pasted in the sheet 2 in the column (A).
A little like I did in Manual format.
Thanks so far for all the help you want to give me about Greetings from A.Maurizio
October 5, 2010
Offline
Hi Maurizio,
Your code is looking for elements with the HTML class name "sunny" but I don't see anything on the page that has that class name. The images could be identified by their ALT text or their Title though.
I would save all the images into the workbook, then based on the weather for the day load them into the relevant sheet/cell. Please make sure that you are not breaking any legal/terms of use agreement by doing this.
A couple of notes on programming. Never turn off error handling without dealing with any errors that could occur. You have used On Error Resume Next but then if an error occurs, how do you know? How do you know that your code is working?
When you use a declaration like this Dim Y, X As String you are declaring Y as a Variant. If you want Y as a string, the declaration must be Dim Y as String, X as String
Phil
June 26, 2016
Offline
Hi Philip Treacy thanks for your suggestions
But I would like to point out that: What I gave you was only a test sheet and not the original.
Having said this: Thanks also for your advice that you gave me on the Factor (Dim X, Y) I always thought it was the same thing to declare the two factors by linking them together rather than dividing them all; Dora on I will make you as you suggested.
But what about? Alt Text I see it hard because they are two codes that I have never faced for here without something practical I would not know how to proceed.
However thanks again for your intervention, sincere greetings from A. Maurizio
1 Guest(s)
