Search results for query: *

...title = "No MRP Connection(B23)!" response = MsgBox(msg, style, title) 'Exit Sub End End If Dim Endes As String * 2 Dim Rtnc1 As String * 7 Endes = "DD" Rtnc1 = "2" Call desAS400_MRP.B23_QGPL_SETMAPENV(Endes, Rtnc1) If Rtnc1 = 1 Then msg =...

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...

Herman, Prior to my last response, I Clicked the link to "mark this post as helpful or expert post" for your answer. If there is somewhere else let me know. I definetely will give credit where it is due! X-) Regards, Brian

You guys are Grrrrrrrreat! The Bug reported under Q248055 on Microsoft's website was the trick. I even searched Microsoft's Knowledge base for "713", but I must have missed that one. Herman you were the winner, but I appreciate all those who responded! |-0 Regards, Brian S. Noll...

OK, so option one was to run MDAC_TYPE.exe and also install the runtime DLL's for Visual Basic 6.0 and option two was to download a 3rd party installer like SetUp Factory. Option 1. Installed the runtime DLL's and then used MDAC_TYPE.exe to install my application. Same result. Option 2...

Guru's, I have created a Standard.exe project which connects to our internal AS400 database and runs a Stored Procedure using the Data Environment options within Visual Basic. The application from the design environment works great. I am successfuly able to compile the application into a...

I have a text file generated on a Unix platform. When accessing this file for processing using Visual Basic 6.0, I do not get the needed cariage returns to designate each line of text in the file. Unix has a command which adds the needed cariage returns, but I am not moving the files from the...