Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Rick_Stanich
- Content: Threads
- Order by date
-
Save xls file to cvs file
I am trying to write VBScript to save an active Excel file as a CVS file, The format of the Excel file needs to be retained. See example Excel file (57094-97_B_Op 2 of 2_03-04-24_3.xls) and example CVS file (57094-97_B_Op 2 of 2_03-04-24_3.cvs) for comparing. The Excel file is from a CMM...- Rick_Stanich
- Thread
- Replies: 3
- Forum: VBScript
-
How to get data from DataGridView to a Listbox?
Not wanting to type a long-drawn-out subject, I am new to VB.net, and it's been many many years since I was into VB6. On Form1 I have a Combobox and a Listbox, Form2 is my DataGridView. With help from others on forums, I have been able to populate the Combobox with a single column of data from...- Rick_Stanich
- Thread
- Replies: 33
- Forum: Visual Basic (Microsoft) VB.NET
-
Find the nth occurrence of a string and report value to the left.
I have a file name in this format. Ruby Head_Rev 2_Sabre_Op 20_M0020-ALL - H23410_2023-6-6_103655 AM.xls I am trying to find the 4th occurrence of the "_" (Under score) and obtain the value of the string to its Left, not including the "_". Obtain this portion of the string: "Ruby Head_Rev...- Rick_Stanich
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Save active Excel file to new location
Hello I am trying to save an open (active) Excel file to a new location automatically. I created a VBS program, which I wrote initially in VBA but I am loosing something when using VBS. The SaveAs portion will not complete and gives no errors or warning. I am temporarily using a MsgBox to see...- Rick_Stanich
- Thread
- Replies: 6
- Forum: Microsoft: Office
