Search results for query: *

I have not been able to get any answer regarding the following question for which I've been searching for answer for a while: Is there any way to create pure VBScript for automating PPES and IWR publishing to a specific Upfront folder without using ANY CognoScript? Any help, no matter how...

Great. Thanks, Skip.

Hi Skip, Makes sense. I know I failed to mention this, but I also have the number of hours in each corresponding cell in column F. How do I tally up the total hours for only those rows which were highlighted as a result of containing the text 'travel*' in the corresponding row in column G...

I have a sheet with descriptive text in column G. I would like to be able to search for a specific word in all possible rows with a wildcard; for example anything with the word 'travel*' in it. If the text containing 'travel*' is found in column G, I would like the entire cell highlighted and...

Hi Rick, I also only have .NET 1.0. Does that mean that I cannot use this BrowseFolder class? Is there any alternative? Regards, Shawn

Rick, Please take a look at my button code which gets assigned to the textbox text: Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click If OpenFileDialog2.ShowDialog() = DialogResult.OK Then Dim sr As New...

Rick, I was getting all kinds of errors in the code. As soon as I entered the following for my button code, I got my code to work... System.Diagnostics.Process.Start("xcopy.exe", TextBox1.Text & " " & TextBox2.Text) Thanks, Shawn

Great. Thanks again, Rick. Cheers! Shawn

Rick, Great! Exactly what I needed. How much more complicated would it be to give the user the possibility to browse to the target and destination paths as opposed to having them type in the paths? Much appreciated, Shawn

I'm totally new to VB.NET. I'd like to know if there is any quick way to build a very simple GUI interface to be able to control a Windows batch file. For example, I have the following batch file command: xcopy c:\Report_Target\report.ppx e:\Report_Destination\ In my case, since the paths or...

Tony, That's great. All of my inqueries have been answered very efficiently. Cheers! Shawn

Hi Tony, That's perfect--exactly what I was looking for. One more related question: What can I do in terms of validation? In other words, now that the user has more flexibility to type in the company name, how can I build in some validation in that only the company name in the list is a...

I apologize, I clicked on Submit Post by mistake... Here is the table that I have in a sheet called Table: A B C 1 ABC_Company 12906 2 Aldo 32600 3 Bay 15637 4 Bureau Engros 25900 5 Garment_Plus 14568 6 FutureShop 18906...

I have the following table: 1 ABC Company

Hi PVH, Got it. I had to exit design mode. Thanks so much Gerry & PH

PVH, Okay, I filled out the ListFillRange with my range. There must be something else, since my combo is not being populated. Thanks, Shawn

Hi Gerry, Okay. I understand the difference. I see the MatchEntry property now. However, how could I now populate my new controls toolbar combo? I suspect I need to accomplish this with some VBA code as opposed to the forms toolbar combo, correct? Thanks, Shawn

Sorry, I actually have a forms combobox. I cannot get my controls combo box to read my table as it doesn't appear to have a Controls tab for me to assign my ranges as before? Thanks, Shawn

Gerry, My combobox dropdown is actually from the Control toolbar. I'm assuming you're referring to MatchEntry through VBA, correct? Thanks, Shawn

Hi PHV, I cannot see any MatchEntry property for my combobox. All I see is a Control tab which I access via Format Control. I have an Input range and cell link ranges applied. Thanks, Shawn