Tagged Questions
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 ...