Replies

I prefer “People who live in tin houses should be careful about throwing can openers!”

The way I heard it is that “Royalty in grass houses should stow thrones (in their attic)”

[*]A new 18 litre back pack

I hope that was 18l of

btw Bonne année tout le monde …

”Come back real soon now!”

Why thank you kind sir, I look forward to it

Thanks Steve & Stuart.
Everything went smoothly as you said. John will be pleased to know that I have vacated British soil, never to return – that is until next time, which will be next Saturday as we stopover enroute to spending Christmas in the frozen West of Canada.

Our plans have us flying out on BA to Vancouver on the 21st – the day their cabin crew have decided to down tools. Never a dull moment with those guys …

That shouldn’t be a problem.

Thanks

Back to civilisation, at last?!

In a way since I’m returning to civilisation on the 1620 to Geneva, absolutely!

Why do you ask?

Steve – thanks. The last time I took the DLR it was diverted from Bank to London Bridge, and that isn’t connected to anything else! Is there a minimum amount you can have left on an Oyster? I’ve got 5.15 and I think I’m going to get charged the Maximum daily rate of 4.85 leaving just 0.30.

Try this one from the NY Times. Can you drive and text and …
NYT

PS – maybe it’s my mac, but in the youtube frame you can clearly see the question … so before you play it you know what too look for.

The instruction is:

ActiveDocument.AttachedTemplate = “Normal.dot”

Perfect! Thank you + :swiss chocolate bonbon smilie:

How does it do that?

Hans, sorry – you are right, it doesn’t. The user creates a new document using my template which autoruns my macro. The Macro displays a dialogue box, the user clicks on choices and enters text which is then inserted into bookmarks in the new document. Using one of the text fields the document is then saved and the macro ends.

Bowlie

Jefferson – thanks, I think but that is a little further along the learning curve for me …

I used Hans’ suggestion and frankly see no lag time at all. I’ve also tested with input of up to 255 characters and still I doubt that anyone would really notice a lag.

Hans – thanks again, It works very nicely and I learned how a couple of new (to me) VB statements work.

Oh, a PS … My Macro creates a document, inserts variable info into various bookmarks, saves the document and then ends. However the next time I open the document it warns me of Macros. Once the document has been saved I don’t need the macro any longer. How do I get rid of the macro (and the macro warning)?

Here’s an alternative version:

Code:

Public Function IsValidFile(sFileName As String) As Boolean
  IsValidFile = Not (sFileName Like "*[/|:*?""]*")
End Function

Hans – thanks for this. I’d like to go one step further though – If a forbidden character exists, to replace it with a “-“. I’m taking the file save name from ‘subject’ text users enter into a text box, and I’m not going to be able to get them to change their behaviour.

Jan Karel

That looks perfect! I was getting into the 10s (even 100s) of line of code – got off on the wrong track!

I’ll give that a go tomorrow morning, once I’m in the office!

Many thanks

Bowlie

Is this for a Mac? In Windows, the illegal characters for a file name are / | : * ? “

Hi Hans,
No not for my Mac, but for Windows. I did that “i.e.” quickly and may have got the characters wrong.

Another offering along the same lines here

I think Mum’s been there before …

The table stops at element #111. Elements #112-#119 have been synthesized and detected, but only in extremely small amounts. Either the person who created the table in the picture didn’t know about those, or didn’t bother including them.

You have much better eyes than I, Gunga Hans … Knowing this now takes a very heavy weight off of my shoulders!