Replies

There are just too many cities in the world. That’s my guess as to why no one publishes a single page with all of them listed. That said, there appear to be many sources offering open APIs to fetch data for the cities of most interest. This page lists a dozen, although some of them may be U.S. only: API Directory – ProgrammableWeb. Yahoo’s says it is for non-commercial purposes, but maybe there is a commercial license available on inquiry from Yahoo or some of the others.

Hi Jefferson

Thanks for the great site, I am working on one of the links that give 500 free calls everyday which might just do it

Methinks someone got out of bed on the wrong side this morning.

I did to Rory, I should not have bothered responding to it, but there you go. Your excellent Custom format from Eileens is instrumental in making this work

Ta

Hi Peter

Thank you for the link, I have actually emailed this site for further information or a paid subscription. Whilst it is indeed an excellent site when you do a web query from within Excel you need to select the tables on the page and on this site it does not do it for the sub pages, for example it lists all of Europe in a table which you can select but if you choose ‘East’ and then ‘Russia’ for example it has a huge list but you can’t select it.

Another wonderful resource that I am waiting to here back from is Weather Underground (Wunderground) http://www.wunderground.com/ and if you then type a country into the search and scroll to the bottom of the page, for example, Vietnam, http://www.wunderground.com/cgi-bin/findweather/hdfForecast?query=vietnam&searchType=WEATHER you get a table that works well in a web queery.

My concerns though are that as there are 225 Countries that we can potentially ship to and from I would have to make 235 web queeries in the same workbook which (a) will take some time each time the workbook is opened, (b) use lots of recsources on the owners site, and (c) may need the site owners to believing that a ‘bot’ of some sort was hitting and then they would lock it down making it unusuable for others that enjoy to use it.

Thanks again for your great suggestion

This certainly qualifies as scuttlebutt. The ‘not quite found what I am looking for’ (despite receiving etc.) does have a familiar ring to it. One might go so far as to imagine that you would like it served on a silver salver without your having to lift a finger.

I cannot be a purveyor of ‘the real goods’, but I might add to your collection of answers (but not advice) with a few parallel oddities.

Depending on your version of Windows you may have any number of desktop gadgets, such as a clock, and you can plaster your desktop with clocks with times from the four corners of the earth, as we members of The Flat Earth Society like to refer to it. Maybe you can do the same with the weather.

Then there is the matter of RSS feeds, which will keep the information streaming in on a continuous basis, so you can collect weather feeds on a continuous basis, and it strikes me as inconceivable that you could not, given the importance of weather to these newfangled heavier-than-air flying machines. If man had been meant to fly, he would have been born with wings.

This is strictly a parallel, but if you care to give the free (promotional) Ashampoo toolbar a try, they have a dandy collection of English-language newspapers that cover the map to the extent that it can be covered, and all of which I presume report upon the local weather.They may look out the window, or a runner may bring news of it to them, or, come to think of it, they may be downloading it from weather satellites. Say, maybe you can too, but what’s a temperature without a humidex and an ‘air quality index’ and a pollen count. Oversimplification is a risky business. There is big money in smog control and hay fever remedies. Asthmatics will despise you, or worse.

As for converting such things to the style of display that suits your fancy of the day, I can only suggest that that be left to the lower order of servants.

Dear Peter

I am not quite sure what I asked for that provoked such a vitriolic response from you.

Scuttlebutt used to be a place where ‘friends’ met and exchanged links, chewed the fat and asked for help if they were stuck doing something. If that has changed under the new management and Scuttlebutt is now used for some other reason then that I am sorry, I was not aware of the change and perhaps the ‘Management’ should advise everybody.

I believed that in my request for help I had covered all of the reasons why I was looking for something further than that which I had extensively searched for myself and which users of another, friendly, lounge had tried to contribute.

It was not laziness that prompted the post but the belief that some other lounger might have had a weather interest and knew of a web page that they could point out to me.

It is apparent that before attacking my post you had not read it correctly because I was not asking for weather widgets etc. for the desktop but for something to use in Excel for a project.

For this project I need to determine live temperatures from almost any origin, via any waypoint to an eventual destination so that we can determine the correct packaging and temperature control for the transplant organs etc. that we ship. If the shipments go out of temperature parameter the contents are ruined which could mean life or death or the ruin of years of research.

I apologise if I have ever offended you in this or a former life and I will stop posting in these forums in case I ever do accidently offend.

Good Morning

In a similar fashion to John I type a completely made up word on the last editted page and then use edit – find next time I want to work on the document. The secret is to remember to take it out before publishing, and if your memory is bad keep it clean in case you leave it in!!

I think I tried what you want me to do; however, when I get to the Protect Sheet window, that’s where I get lost. I have no idea what to check/uncheck. If I leave it as it is, all the cells are not protected. I have attached the window I am referring to. If you can help further, thank you.

Morning

Does the attached shed any light for you?

Hi George

There were several good answers to a similar question given here http://www.eileenslounge.com/viewtopic.php?f=27&t=1317

I have a printer that supports two sided printing; Xerox 8650. I have Publisher 2003. I have a one sided note card in publisher that prints two cards on one side of a 8 1/2 X 11 Sheet. I would like to add some text to the inside of the same card Can you tell me how to do that?
Thanks
Terry

Hi Terry

I am not quite sure if I am reading this right. If you choose blank publications you can select a greeting card for example which will give you 4 pages, 1 is the front, 2 is the inside left, 3 the inside right and 4 the back. When you print and choose the properties I would guess you are offered flip on short or long edge, I think it is the long edge option if memory serves right. When you print you can now fold it in half and have a small booklet (that is what I use for training) or a greeting card etc. with writing on the inside

Hehe… sorry, I meant “torture” more along the lines of pet owners who make their animals do things that are comically unnatural. Like making your cat wear a cute sweater. They look at you with such contempt afterwards.

Oops

That is why Mr. Smith my Cairn looks at me like that when I put on his raincoat

Note to everyone, there is no dog torture in this video. In fact, a dog was given a beautiful necklace in this video. Sheesh.

Hi Keely

I think that Tony refers to the methods in which animals were trained to do this sort of thing in the 30’s

Does anybody know if there is a way to format text on a PPT slide with a yellow highlight as you can in Word? The only way I’ve found to achieve the same look is to create a yellow rectangle with no border and send it behind the text. Does anyone have a better solution please? Many thanks in advance for any help.

Good evening

If you type the text and then right click the text box border and choose ‘edit textbox’ you can set the background colour to what you want, is that what you were after?

Hello
Does anyone know of a way I can create %s of subtotals in a pivot table – instead of % of grand total. I need to create a table from a cube which has salary by region over time with the number of people in each salary range as a percentage of the region. I have tried using the % Of setting but it comes up with nonsense values of itself, ie. each salary range is 100%.
Cheers
Suzie

Afternoon Suzie

Pop over to the CONTEXTURES site, Debrah Dalglish has some super examples. Please drop her a mail if it helps you out

Do you mean Clipmate? And what’s your question?

It would seem that this is the program the poster was referring to http://www.mlin.net/Clipomatic.shtml which is a clipboard manager thingymajig malarkey

EDITTED: sorry for the repost but the first went to a webpage unknown when I clicked to submit it?

Do you mean Clipmate? And what’s your question?

It would seem that this is the program that the poster referred to http://www.mlin.net/Clipomatic.shtml which is a cache clipboard thingymajig malarkey

I’m running into a problem that I think is caused by exceeding the maximum size of a VBA array in Excel 2007.
The final size of the array is (201185 x 151)

The procedure works fine with smaller data sets – but when I move to the larger data set, the final dump of the array doesn’t occur.

Suggestions? Confirmation of my theory?

Hi Catherine

Does this article from the MSKB help http://msdn.microsoft.com/en-us/library/aa730921.aspx#Office2007excelPerf_BigGridIncreasedLimitsExcel