Replies

Thank you sir, I found that one also. I did import two weather tables – what a God-sent, no more having to actually logon to the weather site – just hit refresh and we get “new” weather.
Now if I could only manipulate the exchange rate, by getting others to refresh my data.

Bruno Terlingen

Hi Bruno

You can have the data imported when you open the workbook automatically. In the attached example I have added a macro into the on open event of the workbook

– alt + F11
– on the left double click ThisWorkbook

and you will see the code.

If you are using this for personal use you might want to set macro security to low
If you set the macro security to medium you will be prompted to allow the macro
If you set the macro to high it will not run.

You could, as an alternative, record a macro

– tools 0 macro – new
– name the macro and assign a shortcut
– selct the range that you want to update
– right click – refresh data
– click on a blank cell and then stop the macro

Assign the macro

– Select an autoshape from the drawing tool bar
– Right click and choose to assisn a macro
– click on the name of the macro you have just recorded and exit
– You can name the shape by right clicking it and choosing add text

Now when you open the workbook you can click the button at anytime and if there is any new data it will download it.

HTH

Hello again.

Someone asked for this during a course. A Flash file can run in it’s own space on a slide so I thought it might be possible to do
a similar thing with a hyperlink to a web page. Is it possible to modify the hyperlink and persuade it to open the page in a full screen view?
I think the main intent is to hide screen clutter during the presentation.

Andy.

Hi Andy

I use this Live Web and find it works great

Hi Andrew

Have you tried to convert it first, if you Google there are loads of free converters listed

Good evening

I tried to download a manual from the Canon site to have a look but it just kept stalling. Have you tried opening properties and looking at the options there? We have a biggish Canon at work and in the properties it has an option for booklets which prints in the right order

HTH

Humbled by Dogz

Mr. Smith (My fearless Cairn) gets walked on a West Sussex beach every weekend and bank holiday morning, the slighest bit of spray and water on his foot and he is off like a shot. However, like Ricochet he has found his own niche in life, sad to say the niche is a portal to the foods cupboard

Great find

Good morning

I need some help please in revamping a formula for a tariff

I was going to try and explain everything here but it got too complicated. I have attached a copy of the workbook which calculates a rate based on a table in the rates and surcharges tab, however my supplier has now simplified the tariff structure to a base rate for 1 kilo and then a rate per half a kilo thereafter so I would only need to reference A4:A5 and B4:F5.

There are about 5 different calculations (highlighted in red) in the calculation tab but I honestly can’t remember how it got that complicated.

PS: does anybody know why it is saying “You can make 48 more posts until 2010-01-26 20:26” above my messages, am I being expelled after that?

Hi all

I think that the problem has been solved on another lounge and I am just testing now

=INDEX(‘Rates + Surcharge’!$J$4:$N$4,C32)+INDEX(‘Rates + Surcharge’!$J$5:$N$5,C32)*ROUNDUP(2*MAX(D32-1,0),0)

I have just done a quick Google and found this about read only files

http://office.microsoft.com/en-us/excel/HA101527191033.aspx

This seems to suggest that the file needs to be given a new name but I have not read it all

Hi
I have an xlsb – Excel 2007 binary workbook that was created on one computer and when it was installed onto another computer the user is getting a read only and a non commercial use across the top. I checked the properties for workbook and the read only was not selected. Any thoughts what it might be

Good evening

I know that you can get the non commercial use message when you are using office 2007 Home and Student version but I am not sure about the read only issue

A couple of other queries have sprung to mind. Preferred currency in UK and on the continent? I’m wondering about setting up a foreign currency card account with HSBC. I could buy USD, EUR, GBP for AUD any time from now, when the buy/sell rate is right. I’m guessing EUR might be the go, since no further conversion stings would be involved?

Also, rail passes. Back in my days there were a bunch of disparate options – Eurail, Britrail, Benelux and other passes, for whatever length of time, with Switzerland not included, Spain partial inclusion etc. etc. I’m hoping that there might be some consolidated arrangement now under the EU?

Hostels and backpackers have obviously moved in leaps & bounds too. With a mixture of private and Youth Hostels now, is there a “common” membership or similar worth getting?

Alan

Hi Alan

You will need proper currency here in the UK, remember to keep the small change such as Groats and farthings for tipping the serfs. Also remeber to swot up on Miles per Hour, Pounds and Ounces etc. you know, proper measurements are still used here like ‘Chains’ (remember the border line series).

On another note I have an office in SYD and MEL so if you need anything shipped by air I can get them to do it at cost and the same if you buy up half of London I can get it shipped back.

pieterse,
I’m only seeing one city listed when picking a country with multiple cities when using your workbook.

stevenhocking,
The 3 of USA cells have a trailing space. It could cause problems with various functions.

I’ve attached a version that uses a unique country list (hidden in the AB column on Sheet1) for the country dropdown and then uses the Offset function to populate the list of the City drop down. I also use the offset function to return the high and low temps.

Hi Mike

Downloads are working again now

Fantastic solution, thank you. I am working though the formulas and ranges, I can see that there is a temperature range but in the low and high result cells you have =lowtemperature and =hightemperature and I can’t fathom out where to find them or where they are getting their values from (I can see the offset formula below. Sorry just a little confused

pieterse,
I’m only seeing one city listed when picking a country with multiple cities when using your workbook.

stevenhocking,
The 3 of USA cells have a trailing space. It could cause problems with various functions.

I’ve attached a version that uses a unique country list (hidden in the AB column on Sheet1) for the country dropdown and then uses the Offset function to populate the list of the City drop down. I also use the offset function to return the high and low temps.

Hi Mike

Thanks for doing that but I can’t open or download it, it goes straight to an error page (Please see below) perhaps a MOD can pick up on this and advise

Can’t attach the picture either it says Error The server returned an error during upload

Perhaps there is a general lounge problem so I will try later

You can certainly do it with conditional formatting. Based on my sample workbook, you would select C4:D5, use FormulaIs and enter
=C4=MAX($C$4:$D$5)
for the max and:
=C4=MIN($C$4:$D$5)
for the min. Assumes that C4 is the active cell when you add the CF.

Super answer again Rory

Cheers for looking Mike the workbook was in the post link that I atttached

Thanks

HI Rory and Jan Karel

You guys are amazing, thank you so much for the effort and the quick responses, you have saved me hours days months of pulling my hair out

Advice requested.
I have a lovely charming elderly aunt. Who has discovered the internet and email. And who forwards every chain mail/virus hoax that crosses her desk. Its’ gotten so bad that family members are hiding their email addresses from her.
I would be happy to exchange a couple of lines with her daily. I have in the past directed her to sites such as Snopes.com so that she can verify any virus warnings she receives. I have not responded to (nor forwarded) any of her chain mails.
Yet she continues in her forward ways.

Any suggestions on how to stop the flow?

Hi Catherine

I received this today, you might want to forward it to said Auntie

Dear Friends

At the beginning of this new year I wanted to thank you for the emails you have forwarded over the previous year.

I must send a big thank you to whoever sent me the one about rat junk in the glue on envelopes, because I now have to use a wet sponge with every envelope that needs sealing.

Also, I now have to wipe the top of every can I open for the same reason.

I no longer have any savings because I gave it all to a sick girl who is about to die in the hospital for the 1,387,258th time. But that will change once I receive the £15,000 that Bill Gates/Microsoft are sending me for participating in their special email programs. Or from the senior bank clerk in Nigeria who wants me to split seven million dollars with me for pretending to be a long lost relative of a customer who died intestate.

I no longer worry about my soul because I have 363,214 angels looking out for me.

I have learned that my prayers only get answered if I forward emails to seven friends and make a wish within five minutes. I no longer drink Coca-Cola because it can remove toilet stains.

I can no longer buy petrol without taking a friend along to watch the car so a serial killer won’t crawl in my back seat when I’m filling up. I no longer go to shopping centres because someone will drug me with a perfume sample and rob me.

I no longer answer the phone because someone will ask me to dial a number and then I’ll get a phone bill with calls to Jamaica , Uganda , Singapore and Uzbekistan . I can’t use anyone’s toilet but mine because a big brown African spider is lurking under the seat to cause me instant death when it bites my bum.

I can’t even pick up the £5 I found dropped in the car park because it probably was placed there by a sex molester waiting underneath my car to grab my leg.

If you don’t send this email to at least 144,000 people in the next 70 minutes, a large dove with diarrhoea will junk on your head at 5:00pm tomorrow afternoon and fleas from 12 camels will infest your back, causing you to grow a hairy hump. I know this because it actually happened to a friend of my next door neighbour’s ex-mother-in-law’s second husband’s cousin’s beautician.

By the way….a South American scientist after a lengthy study has discovered that people with low IQ who don’t have enough sex, always read their emails while holding the mouse.

Don’t bother taking it off now, it’s too late.

Regards,
Your friend

http://smartcanucks.ca/how-to-send-free-text-messages-to-rogers-fido-telus-bell-virgin-cell-phones-canada/

and obviously, you have to be at a computer for this to work.

Oh, and here is my husband’s favourite tip about using Google from a regular cell phone.

http://www.google.ca/mobile/sms/index.html

Again, USA / Canada Centric I found this site Melissa Data which may be useful