0
votes
1answer
36 views

Automate download of a dynamically generated file after NTLM Authentication using vbscript/java

I am trying to automate to download a dynamically generated file on a server, so here are the steps what I have to carry out manually - Login to the site using my credentials - It uses NTLM to ...
-1
votes
1answer
73 views

Grouping Similar Cells in Excel [closed]

I have an excel sheet that has 7000+ records. It has two columns- Number and Title. The rows under the 'title' column contains strings and some of the strings are quite similar. For instance: Need ...
-3
votes
0answers
34 views

Saving a excel file to a server using vb script [closed]

How to save a file using vb script?.I am updating a xlsheet and have written code in the same file.I need save it into a server using the code.
1
vote
2answers
115 views

How to set a delay in VB Script to let Excel update data

I have an Excel file that automatically loads the data from an external database (via a Data Connection to an Accesss database that is, in turn, linked to a Sharepoint table). I need to automate the ...
1
vote
1answer
94 views

How to split a column in Excel into multiple columns, using categories from another column?

I have a very large data set with hundreds of thousands of rows. I have managed to split it into two columns like so: Name: | John Birth year: | 1982 Favorite sport: | Rugby Favorite ...
1
vote
1answer
41 views

getelementsbyID inner dt id values

I am extracting data from HTML using Vb Script. This is the HTML code from which am trying to extract the data. <dl id="overview"> <dt id="overview-summary-current-title" ...
0
votes
1answer
57 views

Excel getElementById extract the span class information

I need to extract certain information from HTML using VBA. This is the HTML from which I am trying to extract the location information alone. <dl id="headline" class="demographic-info adr"> ...
0
votes
0answers
70 views

Update XLSM (macros) via VBS, Current Directory

I am trying to run an excel macro via a scheduled task. I found a good working method here. My version of that vbs is here: Option Explicit On Error Resume Next ExcelMacroExample WScript.Echo ...
0
votes
1answer
88 views

Writing a vbscript to read data in a table and output total hours

I am working with a table like below, where there are projects that are broken down into tasks, and one task may appear more than once. I am aiming to get the sum of all hours of the same task, so for ...
0
votes
1answer
86 views

Extract All Excel Function Types From A String using Regex in VB

How can i extract excel functions (only their names) from a string in visual basic? For example i have: Sin(B6)*Sum(A2:A4) So i want to find a way to have "Sin" and "Sum" from this. Note: I already ...
0
votes
1answer
100 views

How to select the characters part of string in Visual basic

I have some string variables with combinations of numbers and characters. like this: A12452 BCD23 ESK56003 Using vbscript I want to get the characters and not the numbersfrom these strings. So I ...
0
votes
2answers
69 views

Visual Basic Fill Array with simple number set

I need to fill an array with numbers 1-50, and I currently have the code: Dim numberSet(49) For x = 1 To 50 numberSet(x - 1) = x Next x The challenge is to do it in the least amount of lines ...
1
vote
1answer
238 views

Get Row number of excel using ADO

We are trying to get the row number of particular recordset retreived based on soome condtion. consider below table Name Id abc 1 cde 2 efg 3 Now, how to get the row number or ...
7
votes
3answers
115 views

Updating values from external workbook automaticly

I have the following workbook setup: Workbook A has a link to x amount of workbook B's and fetches data from them. The workbooks B have links to some other workbooks and fetches data from them. ...
-1
votes
1answer
50 views

how to open and WRQ relection program through VB script?

I want to open test.r2w file (r2w is extention for WRQ reflection program) and then i want to run macro which is store inside of that file and then i want to close it automatically. is it possible ...

1 2 3 4 5 10
15 30 50 per page