Recent content by shawnmandel

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