Recent content by bytehead

I am not an accomplished VB programmer by any means, so bear with me... 1. I need to open the connection to the as400 database (already accomplished). 2. I need to invoke a stored procedure (SETMAPENV) in a specific library (QGPL) and pass in two arguements (Endes, Rtnc1). The stored...

Skip, Just what I was looking for! Life Saver for the day, and a pat on your back. Thanks. Brian

Skip, Excately what I used, but now I am faced with when I divide a number like 10000 / 1000 = 10 not 10.000 as I need. Is there a way to format the decimal so it is always three decimal places even if it is a whole number? Thanks, Brian

OK, I found the CDec datatype, but it can only be used with a datatype of variant. Well I had my variable declared as double and it was not working because of that. All is well now. Thanks!

I need to convert Double to Decimal as such: 1234 / 1000 = 1.234 I am at a loss. This has to be easy to do... Thanks, Brian

Here was the fix. Thanks to strongm for putting me in the right direction. And I knew it was going to be an easy fix... Add reference to Windows Script Host Object Model then added the following to my code. Dim objExec As New WshShell objExec.CurrentDirectory = App.Path objExec.Run...

Nope... Another Try? Application is too darn smart. Somehow I need to set directory, and ChDir does not work. It really can not be this hard...

Unfortunetely using the Shell command does not reset the last remembered Windows Directory that a file was opened or saved from. I need to use something other then shell, but just as simple.

Yes, all supporting files are in the same directory. The executable, created by someone else, needs an input file and its respective data files. All of which exist in the same directory where the Shell command calls the Executable. In the application, I allow the user to go open a text file...

I am using the Shell Command to execute an Executable file on disk. But even though I specify a specific path to the Executable file, the application is looking in a different directory for the supporting data files. I want to to look in the directory specified when executing the Shell...

I had used the MaskEdit Control in VB6 before, but now in VB.net it does not seem to work the same way. I am trying to read the user input in a MaskEdit Control and concatinate it when trying to do a FileOpenDialog box. But I can not get the value the user typed in for som reason. I would...

VB & Excel gurus, I am trying to unprotect an Excel worksheet with no avail. I have recorded a macro in Excel which displays the following code to unprotect the sheet: ActiveSheet.Unprotect I have used the object browser in VB to search for unprotect for the proper code in VB to do the...

cajunCentruion, I did as you said and still have the same results. Any other suggestions? I have included the new code for the sub. Private Sub Command3_Click() Dim FSO As Scripting.FileSystemObject Set FSO = New FileSystemObject FSO.CopyFile...

Craig, I have included the code which already exist in my application. As you can see I am already making sure the application is closed and quit before setting the range to nothing. Private Sub Command3_Click() Dim FSO As Scripting.FileSystemObject Set FSO = New FileSystemObject...

I am developing an application in VB, which reads an Excel file and extracts cell data and writes it to the itermediate window for right now. I would like for the application NOT to have to be closed to be able to process a second file or group of files. Unfortunately, every other time I...