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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by athlon551
-
Excel VBA File Close Taking 2 minutes. Help code snip in message.
'close File Application.DisplayAlerts = False Workbooks(NewWorkbookName).Close SaveChanges:=False Application.DisplayAlerts = True Why doe is take so long to close a text file.....csv file in excel vba? Is there a better method? Matt- athlon551
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Help Macro Stops Time
When I run macro1 I can actually see the Time Stop. Any Help would be appreciated. Sub Macro1() ' Macro recorded 7/13/2005 by Matt Kerg Repeat: Time = Now Length = Len(Time) SpaceStr = InStr(1, Time, ":") NewLength = Length - SpaceStr - 4 ReportTime =...- athlon551
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Workbook Sharing
Thanks PHV. Guess I should install Excel Help.- athlon551
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Workbook Sharing
Is there a way in VBA to detect if a workbook is shared? Is there a way in VBA to make a workbook shared and vica versa? Thanks for your help in advance! Matt- athlon551
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
