Recent content by emhunter

VBAjedi, Thanks for the tip in your second paragraph. Following your suggestion: - I 'Dim'med the variable array as STRING to force Excel not to recognise as a date. Previously the array was an undeclared variant which makes the array highly adaptable (but in this case too adaptable). -...

Thanks for this tip. I have used it to place a filtered worksheet into a listbox to enable the user to make a selection on a subset of data. Only problem is that date values are reformatted when being displayed in a listbox. Rather than adhering to the regional setting of dd/mm/yyyy on my PC...

Are you suggesting that a document can have a macro but that macro is nowhere to be found in the project explorer or organiser? Further, do you have any evidence that macros (of any sort) can survive in the rich text format?

Yes. Save the document in rtf format (.rtf) and then open this and save again as .doc (you are overwriting the old .doc with a new file) RTF doesn't support macros, but it does support things such as document and custom properties, so it appears that only the macro (and all the supporting bits...

So is there a way to turn off the marker now that there is no macro?

Does anybody know why Word 97 warns that a document has a macro when there are no macros present? (I have checked the organiser and the Visual Basic Editor for confirmation that there are none). Anybody know how to fix this?

This bug occurs when printing Microsoft Word documents using document automation (Visual Basic) with Screenupdating turned OFF ("false"). Documents which have paragraph borders (underling/overlining as used in headers and headings etc.) print without the paragraph borders. The problem...