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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Closing Delimited Files from Excel
As the text file that is imported is truly not a workbook, you may not be able to reference it as such. Try using this ActiveWorkbook.Close after you have switched to it.- Woodstock
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need help with error handling syntax
Here is my solution for the worksheet protection problem: Sub Protect() On Error GoTo Handler Range("A2") = 20 ActiveSheet.Protect Exit Sub Handler: ActiveSheet.Unprotect Resume End Sub- Woodstock
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
