Replies

Thanks BigAl… The effect you achieved is sort of what I am after. I’ll take a look at Easy Morph and report back ASAP.
Leigh

I have a way that solves the ‘bleed’ problem. It is to use a black sheet of paper or light card behind the text to be scanned. This stops the black text on the back of thin newsprint being ‘seen’ by the scanner and improves OCRecognition rates.

HTH, Leigh

Good news… We took it up to a setting of 1000 (kb) and it fell over again, BUT, took the setting to 3000 and have had no trouble since.
It appears to be only the Japanese version that gave this problem but as I cannot read Japanese, I was not able to use the Help files.
Thanks for assistance.

Thanks Cyberdance
I’ll give the larger settings (say 1mb) a try. An Internet search showed some users have been advised to take it up to 3000 (3mb) the maximum that their ISP supported. I have already experimented with zipped files, JPEG compression, etc. but trying a larger setting might just do it. I will be at the client’s site later this week so will post any outcomes…

The only solutions I can come up with are these:
1. To delete the original macro that this shortcut was assigned to and then re-create the macro and re-assign the shortcut.
2. Delete the shortcut, export the macro then delete it from the template, finally import the macro and re-assign the shortcut.

I assume that meta code or some such resides in the document and has to be ‘cleaned’ before the problem will be corrected. But keyboard shortcuts can go astray obviously.

Leigh

Thanks Chris

I put that link with a list of handy pieces of info I store about VBA.

Leigh

Chris, I have successfully used the following code to avoid a warning that a selected worksheet is about to be deleted in MS Excel 97 through to MS Excel 2002. It might be what you could try.

[indent]

---

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

---

[/indent]
So that any other wanted messages are not missed, I usually turn on the display alerts after the action I do not want the user to see on screen.
HTH, Leigh

Thanks Hans, this has put me on the right track but I haven’t moved into second gear!

My only problem now is that the Userform actually has two instances of Multiline textboxes (Attendees list and an Apologies list).

I used your code and got an expected result with the ReplaceString function with the Multiline text from the Attendees textbox. But the second time I called the Function, and referenced a different textbox, it came up with a ‘Compile error: ByRef argument type mismatch’

Now I believe both the textboxes are the same type but cannot understand what I am missing. The code below is part only.

Private Sub cmdOK_Click()
    Dim strAttendees As String, strAgenda As String
    
    frmMinutes.Hide
    
    strAttendees = txtAttendees.Text
    strApologies = txtApologies.Text

    ActiveDocument.Bookmarks("Attendees").Select
    Selection.Text = ReplaceString(strAttendees, vbCrLf, ", ")
    
    ActiveDocument.Bookmarks("Apologies").Select
    Selection.Text = ReplaceString(strApologies, vbCrLf, ", ")
    
    Unload frmMinutes
    
    ActiveDocument.Bookmarks("Start").Select
    
End Sub

And your function of course.

Public Function ReplaceString(sIn As String, sWhat As String, sBy As String)
    Dim intPos As Integer
    Dim sResult As String
    sResult = sIn
    intPos = InStr(sResult, sWhat)
    Do While intPos > 0
        sResult = Left(sResult, intPos - 1) & sBy & Mid(sResult, intPos + Len(sWhat))
        intPos = InStr(sResult, sWhat)
    Loop
    ReplaceString = sResult
End Function 

What should I be looking for, please?

OK Gary, now we are cooking with gas!!

What about introducing this?

ActiveDocument.Comments.Add Range:=Selection.Range, Text:=strBmkName

I have tried but can’t seem to make the Comment appear at any point other than the current cursor point in the document. What it needs to do of course is to move the selection to the Bookmark, select it then display the Comment.

Suggestions? Thanks

Brilliant, Andrew. Great lateral thinking!

Many years ago, I had trained MS Excel users in the use of the Camera, (in a version too far back to recall, it even used to show on one of the Toolbars, but I had long since forgotten about it.

And as the result of using the Camera is a graphic object, you can do the sort of things that John was seeking.

(For other users that want to try it out, get the Camera by Tools | Customize | Commands (tab) | drag the Camera to a suitable toolbar and presto! You have a great new way to jazz up MS Excel spreadsheets. (Following Andrew’s suggestion, try hiding the original worksheet after you format the column widths, fonts, etc. But don’t format the cells for background colour of the hidden sheet or it will override your graphic settings.))

Have fun…

Leigh

The problem has been satisfactorily resolved.

Initially the answer was to migrate the data files (including the linked templates) to a Microsoft Server (instead of NetWare Server).

The long term solution has been addressed by Microsoft. They are (or have by now) developing a patch that will resolve the use of linked Office XP files on Win XP workstation using a Netware Server for data storage.

Many thanks to contributors to date.

Thanks for the suggestions. I will try it out later today.

Re: Who uses the format? A government department that produces certificates prefers the ‘correct’ legal presentation. FYI, an Australian Standard was introduced in 1975 (when we changed to SI and the metric system) but like most of us we accept the general concensus that the commas are OK (especially as Microsoft has not been alerted to the requirement that we should adopt the standard in all produced material. Can’t blame MS when we as a group are tardy in adopting the change.)

Thanks again.

Thank you John for your quick reply.

I do need to use these numbers as numbers though. Therefore for presentation your response is OK but I can’t perform calculations on them. Or is there another way?

Leigh

Thanks Big Al

Yes, there are two NICs and the network (simple crossover cable connection) sometimes ‘forgets’ that there is a another PC connected when booting up. It appears best that you boot the PC (Win98SE and THEN the laptop (WIN XP Pro).

I will check the site (Practically Connected) and come back if I get anything worth reporting.

Leigh

I have been playing around with an installer called CreateInstall that is available as freeware. Get it from the creator at:

http://www.gentee.com/%5B/url%5D

I have used it to install a hidden macro file and a large (2.3mb) template with two toolbars attached to the hidden macro file. The finished installer was only 378kb!

It has proved great in being able to give users choices in where to install, etc. It also includes an Uninstaller which did the right thing when I tested it on my PC.

There are a number of versions of this available from the site, but I used the pre-release version that appears almost complete except for some Help files.

HTH, Leigh