In my VB application, I have command buttons set up so when a user clicks on one of them an application executes. If the path to that exe is not the default location, I need it to then search all the drives mounted on that particular machine until it finds that exe name. So what is the call to...
In my VB application, I have command buttons set up so when a user clicks on one of them an application executes. If the path to that exe is not the default location, I need it to then search all the drives mounted on that particular machine until it finds that exe name. So what is the call to...
I am using the shell command to pass a variable to another vb program like this:
Shell "C:\Folder\App.exe sName"
sName holds a value like "Bob". But when I call the second app with sName attached to the end of it, the Command only sees sName as sName and not the value...
I have a login screen that allows the user access to the Main Application. If the user successfully logs in, the Main App displays a list of command buttons that when clicked, will execute another application. Now what I need is to pass the application being launched the username of the user...
I have a login screen that allows the user access to the Main Application. If the user successfully logs in, the Main App displays a list of command buttons that when clicked, will execute another application. Now what I need is to pass the application being launched the username of the user...
I need to loop through all the rows in an Excel file that has data in each row. If I use Workbooks.Application.Rows.Count it returns every row (65235) or whatever. I usually just have around 100 or so rows with data in them. I'm using a For loop to do this. My code goes something like this...
I have a string with a value that looks like this "w81flr05102202". I need to only get the first six characters out of that string. How do I do that in VB. I was thinking of using the Split function but didn't see any delimiter I could use.
I have 2 or more different excel workbooks with 1 worksheet of data in each workbook. I need to put all the worksheets into one new excel workbook. Either by combining all the worksheets into one big worksheet, or each having there own worksheet in one big workbook. Do I need to do some copy...
I have 2 or more different excel workbooks with 1 worksheet of data in each workbook. I need to put all the worksheets into one new excel workbook. Either by combining all the worksheets into one big worksheet, or each having there own worksheet in one big workbook. Do I need to do some copy...
1.)I have an Excel Workbook with one worksheet in it. The worksheet already has data in it. 165 rows and 15 columns of data. What I need to do is insert a new column using Visual Basic to talk to Excel to write to this existing worksheet. The new column needs to be in the first column. And...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.