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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calling a batch FTP via VBA - will not load or give errors
I'm trying to call a batch file that uses SFTP. If I double-click the batch file, it FTP's successfully. But when trying to call that .bat through VBA, I either receive strange errors or no error at all. Method: lShellResults = objShell.Run("R:\directory\SendSFTP.bat", 7, False) Results...- lobo3101
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Importing Text file with Extra Delimiters - how to delete?
I'm importing text files that are comma-delimited. Unfortunately, the software that creates these files drops 2 extra commas in at the end of each line. This throws off my import and Access sees a "No Name" field there. What's the best way to delete these commas? Is there an RTrim that'll read...- lobo3101
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
