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!
-
Import Text (txt) file to Access
Ok my mistake the code does not work in VB6 either - that explains a few things, will look into tomorrow.- adamctb
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Import Text (txt) file to Access
Hi, I have to import a number of 60MB - 70MB txt files into an access table, which works fine. However before importing I would like to remove the first 7 lines of the text. I have had to do a similar thing in the past but with much smaller files and in VB6 using the below code: Private...- adamctb
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to run a external exe from a vbs login script
Hi vmaxdlx, set WshShell = CreateObject("WScript.Shell") WshShell.Run "1.exe" The above assumes the exe resides in the same directory as the script, if that is not the case you will need to specify this. Hope this helps. Adam -
Printer - Tray Selection
Hi, I use the below vbscript to setup a network printer on user logon. The script works fine however i want to do the same thing for our HP Laserjet 4250 printers. The problem i have is that i need to change the default paper tray from auto-select (which goes to tray 3) to Tray 2 for certain...
