Search results for query: *

Totally agree with @mikrom. I've enjoyed using Tek-Tips over the years and have received some fantastic help which I have tried to repay by providing some in return. But it may well be time to say Goodbye.

I've been offered escorts (sadly not the old Ford model) from around the world. I wrote a rule to delete them and have contacted Tek-Tips to notify them.

Those are really very good Skip and I gave you a star for both of them. Hope they were original and you deserved them :)

Yes I think that Microsoft: Office is the right forum for Excel queries unless you are doing something fancy with VBA.

Totally agree. Forums / Watched Forums seems to make things easier (mine look OK) and I need to cull some of those. Email settings are in Your Account/Preferences, and I need to check them too.

Haven't logged on for ages and just saw this. I am also a long term survivor (>30years), so rarely think about it unless I hear news like this. My heart goes out to you and your friends and family. Hope things go as well as you hope. Simon

Ages I've used this fantastic forum, but my job has changed to a more technical one! , I'm trying to use Outlook Tasks to manage tasks for different customers. Each customer is set up as a Category and if I remember to set the category before saving, it works fine. However I often forget and I'd...

This is an interesting situation. I would have suggested a macro converting yellow text to black as a quick work round, but you say that documents are view-only. I don't know your role in your organisation, but this does sound like an HR issue. You have a user with some sort of eyesight problem...

Just a thought. I've never used VBA in Visio, but often encounter similar problems when deleting in other MS applications. It seems to lose the count as it is deleting. Try counting backwards: Dim MyPage As Page Dim P as Integer For P=ActiveDocument.Pages.Count to 1 step -1 If MyPage.Background...

A colleague has pointed out to me that they are actually the labels of the swim-lanes in the diagram. So this appears to be a 'feature' of Visio. I've tried to search for this but can't find any reference to it. Does anyone know if it can be turned off? Thanks Simon

Resubmission to correct forum. Some advice please. I am updating some corporate Visio documents and somehow the contents of the Tags property is getting updated to its original contents if I delete it and save. Oddly enough, if I try to replace with a new tag, that appears in before the 'old'...

Glad you guys have got involved. The point I was trying to make in my last update was that it may be better to run a macro from outside the workbook and also by using variables, which I understand is better notation, there would be less confusion [dazed] about which file was in use! Simon

Something strange is going on and can't really comemnt on what you are finding, because. You may need to write the code using a proper variable handle such as below. As I have already suggested, don't run from an Open method, use something independant so you can close the workbook and then...

Not sure if these comments will help in this situation, but thought of a couple of points. I haven't dealt with such problem recently but remember them from old. When I had some control over the csv export, I would sometimes seed the first row with values that would fool Excel into data typing...

I didn't have a suitable txt file to play with, so I just did 'Workbooks.Open Filename:=sInput' and then Kill sInput worked without any problem. Must admit that I'm using Windows 7 and Excel 2010 though. Not sure what strongm is getting at: the code is Save As sOutput, then Kill sInput. It may...

Can't see the problem - you've dropped the association to the original by the SaveAs. You should just need to 'Kill <path>/nnnnBSEXPORT.XLS'

strongm - not heard of either, but neither really what I wanted. It's not the application level, but the object being opened - Presentation in the case of PowerPoint. combo however... you've come up trumps again. The first site I looked at said this: 'Tags are a very useful feature and often...

That's well thought out combo - I didn't think of that. I've still got PowerPoint to think about, but can't give you a half-star, so I'll round it up [2thumbsup]. Anyone else any thoughts about PowerPoint? Shame you can't make a CustomDocumentProperty invisible. Simon

Thanks - all good ideas that I'm afraid I have already considered. The good thing about Word Document variables is that they are hidden unless you write some code to look for them.

Thanks. Not really PHV - I'm after a Workbook level property Simon