Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I progromatically tell if a word doc has changed?
You want the Saved property of the document - it flips to false as soon as the document is updated. E.g. If ActiveDocument.Saved = False Then ActiveDocument.Save- MikeToole
- Post #2
- Forum: Visual Basic (Classic)
-
Major migration from Access97 to Access2000 - Is there a property that
There's no change in the file format between Excel 97 and Excel 2000, so this shouldn't be a problem. There a a few enhancements in Excel 2000 that can't be handled by 97, but I doubt that these are used in workbooks created by access. For more details see...- MikeToole
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Regular expressions
The following function will do the trick: Public Function GetFileName(ByVal sIn As String) As String Const cPat As String = "(?<=>)(.*?)(?=</A>)" Try dim rx As New System.Text.RegularExpressions.Regex(cPat) Return (rx.Match(sIn).ToString) Catch ex As Exception Stop...- MikeToole
- Post #3
- Forum: Visual Basic (Classic)
