Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JerryYoakum
- Order by date
-
Saving files with visual basic
It could be a number of things: different version of Windows, Excel, or who knows. Something to keep in mind is that if you changed my code above to be more like the code below you will need the err.number to be 71. Private Sub Worksheet_Activate() On Error GoTo errHandler Open...- JerryYoakum
- Post #5
- Forum: Programming language engineering
-
Saving files with visual basic
Below is a VBA code example that works in Excel to check if a disk is in drive 'A' before saving the workbook. If there is not, it checks to see if the user would like to try to save to disk again; meaning that the user has put a disk in the drive. However, the user can choose not to try again...- JerryYoakum
- Post #3
- Forum: Programming language engineering
-
VB6 Execute DOS program
Below is a example that will work in VB6. It is better to use the CreateProcess API call but that is pretty complex. I hope this works for you. Private Sub Form_Load() Dim temp As String, tmp As String Shell "dos_program > c:\output.txt", vbHide MsgBox "Do not click...- JerryYoakum
- Post #3
- Forum: Programming language engineering
