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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Integrating SAP and vb
I too would appreciate a copy. thanks, filipet@portugalmail.pt- lamber
- Post #11
- Forum: SAP ERP Solutions
-
Delete File in User Profile
Try this Set fso = CreateObject("Scripting.FileSystemObject") Set WshNetwork = WScript.CreateObject("WScript.Network") username=WshNetwork.UserName file = ("C:\Documents and Settings\"& username & "\Application Data\Microsoft\Outlook\test.txt") if fso.FileExists(file) Then fso.DeleteFile file... -
Setting default printer in Excel
Make this in VBA ActivePrinter = "printer name without on NExx:" If you want to know the name of the defalut printer in a Word+VBA, do: msgbox activeprinter- lamber
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Selecting a network printer in Excel
In Word+VBA ActivePrinter = "printer name without on NE0?:" this works, in excell+vba not. I don't know why. -
Selecting a network printer in Excel
in a vbs file, put: Set WshNetwork = WScript.CreateObject("WScript.Network") Set Printers = WshNetwork.EnumPrinterConnections For i = 0 to Printers.Count - 1 Step 2 WScript.Echo i,i+1,"",Printers.Item(i),Printers.Item(i+1) Next WshNetwork.SetDefaultPrinter Printers.Item(0) Or... -
Selecting a network printer in Excel
Make this in VBA ActivePrinter = "printer name without on NE0?: -
use txt file
I need a vbscript that read from file a.txt, and then write in file b.txt. Best regards.
