Tagged Questions
-3
votes
0answers
28 views
can someone provide me the VBscript code to export data from QC to a excel sheet please [on hold]
how to export the data from QC to an excel sheet using VBscript??
0
votes
1answer
27 views
QueryTable authentication
I have a VBScript which gets a data into Excel sheet through QueryTables. The script works fine, but the URL is a server which requires a basic authentication. So when the script runs the login pops ...
0
votes
1answer
31 views
run time error “subscript out of range”
I have written the following script and I'm getting runtime error subscript out of range. Can anyone help me with this?(The msgbox is used as a debugger)
Thanks in advance.
Sub newbook()
Dim bk ...
4
votes
2answers
1k views
Using excels named range in a sql string in VBScript
I have searched on here and google but I still cannot solve my issue. I am trying to use an excel's named range equivalently in my .vbs file. The below works in VBA in excel but I cannot get it to ...
-5
votes
1answer
44 views
how to export multiple tables to excel using vbscript?
I need to import multiple tables from a HTML file that is generated using Perl script to Excel sheet using vba script.
I tried importing the tables with import external data option in Excel.
But I ...
1
vote
3answers
101 views
VBS: Type conflict when using a variable with application.run
I'd like to use a vbs-file as a bridge to get access from Java to a vba-macro which is inside an Excel file. Additionally, I need to transmit some variable parameters.
In Java I call open the ...
0
votes
1answer
3k views
Excel - Macro to compare multiple rows then copy to different worksheet
I am trying to figure out a Macro to copy a row of data to a new worksheet once my conditions are meet. I found another question answer but it is too different for me to figure it out: Other Answer
...
-1
votes
3answers
62 views
Excel get value from worksheet using value (complex) [closed]
This is quite a hard situation and I am wondering if it will be best to use a formula or vbscript. I will explain it first and maybe someone can help me come up with a way of doing it.
I have 2 ...
-2
votes
1answer
97 views
search for string in text file in vb and print lines
Hi I am new to VB and just though if someone could help me in my current scenario
I have a text file named shar.txt
It has 6 lines in it.
I am a new student
I am learning VB
Please ...
2
votes
2answers
4k views
VBA/VBscripting automated Web Scraping looping w/ IE Logon
I've been trying to write a script that will web scrap a certain field/label on a render website. The website is rendered with a search parameter that i have in a column list in Excel. Appox 20 items ...
0
votes
2answers
87 views
Excel VBS Save output to directory the script was launched from
Updated code: The script executes but doesn't output anything and Excel.exe process continues to run. I need this to output to the directory the .vbs script was launched from and name the Excel file ...
0
votes
1answer
136 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
93 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 ...
1
vote
2answers
246 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
159 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 ...
