Replies

There are lots of ways and it depends how much VBA you know. Recording the format painter as a Macro may well be enough.
Extensions could involve opening the template and target sheets specifically, but again, a recorded Macro would do 90% of that directly

Sub Doit
Columns(“Sheet1!A:G”).Select
Selection.Copy
Columns(“Sheet2!A:G”).Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End Sub

I always find taskmgr’s “End task” option to be a useful form of last resort cancelling

A description of a way would be useful.

Thanks for the response Pam – our service provider uses Unix and it was those rare few cases that caused the trouble – e.g. many of our users love those wingding bullets and we publish documents created by others (e.g. researchers) so have little control over content or style. Personally I think it’s all Word’s fault and detecting the area the problem is in will work well for me
(The browser’s encoding had been set to UTF-8).

Cool – that’s my kind of code – I’ll give it a whirl thanks. (I anticipate correct results)

I’m over most of my troubles now
The simple one that caught me was 3/4 expressed by Word as a single Arial character – in UTF-8 it seems to appear as an A umlaut followed by the 3/4 as a single character.

I’m struggling to see why it isn’t an index (Reference > index) which you could create either by hand, or via a macro that looped through the table.

I’m no index expert, but it seems to be more relevant than a TOC

Yes, it comes from range.text, and I hadn’t thought of HTML_Tidy for this because the html isn’t the problem (but I’m on the case now if it can do code conversion)

I guess my problem is still “How do I detect that range.value contains a non-ascii character?” or how do I autoconvert it. Either works.

Andrew

Thanks Hans.
The other issue was that I actually had to send it for it to become formated as a mail message. Before a send it knows its a word document.

Attached word document has a paste of the email message content.
I couldn’t see a way to attach the message itself

Thanks both of you

I have enough to proceed with even if its not elegant. I’m picking that I can basically operate via the explorer and correlate to selection via entryids when I have to.
I may end up creating an order entryid cache – but I’ll play for a bit first

That sorted that out – I appreciate the wisdom

Thanks – that’s a good place to look.

I misinterpretted your mail to start off with, but that triggered another thought.
Web1 is running SMTP as a part of IIS (I’d never intended using it) – perhaps looking into that will give me some entertainment over the weekend.

Thanks Hans and Jefferson

Everything I found on the web seem to indicate that there is something funny relating to JScript, IE and context – including the speed at which users move the mouse.
Using a new browser window doesn’t exhibit the problem, re-using the same one often does (but occasionally doesn’).

This same construct works fine on other parts of the site – it is only that one #top that fails. I will do some work around fixing context.

(.stm was an extension that our web-site developers used for server pages. On the development site they have a lot of symbolic code, but when published to the public site this disappears and the remainder is valid HTML and scripts.) The public site is a microsoft site (which is a mystery to me too) while the development one is (open source and also a mystery) .

[Edited to reduce picture size and clarify the text].

Note that this is not a new window, rather it is a paste over a previous window that is not the current one and #top was at the end rather than the full-stop.

Hans

It may sound strange – but I report that my users also overwrite Excel files and have never quite got their heads around using Explorer to find files.

Microsoft has taken to issuing so many dire warnings that users are confused in many more places than just this.
For instance – try working with a csv in Excel and imagine what our beginner makes of the messages at exit time.

OK – thanks
Its running on an ODBC connection into SQL server so I’ll make a local version of the table – if I’m dead unlucky, presumably it will fix the problem
Rats – it did so I cannot demonstrate.