Tagged Questions
2
votes
0answers
38 views
VB Script accented characters coming out as “Chinese” looking script?
I'm writing a VB script to replace words in a word doc.
The crux of the code is:
strEuropeanOld="European"
strEuropeanNew="Européen"
I then replace the word:
If InStr(FileText, strEuropeanOld) ...
1
vote
3answers
88 views
How can I use VBScript to effectively refresh the external data of several Excel spreadsheets?
I have a macro in one XLSM workbook's module that refreshes all the external data, then saves and closes that workbook.
ActiveWorkbook.RefreshAll
ActiveWorkbook.Save
ActiveWorkbook.Close
...
0
votes
1answer
33 views
Updating MS Power Point linked object such as chart or Excel sheet
I have a ppt which is generated every week. I have created a vbscript for updating the linked chart.. but i couldn't find how to identify the excel sheet which i have used for creating the table in ...
0
votes
1answer
38 views
How to pass vbscript variable into html
I am using vbscript and excels to automate one of my tasks.The below mentioned code automatically draft an email in outlook with an attachement.But still i have to manually enter the 'aa' values and ...
0
votes
1answer
50 views
Display timer as well as “Pause / Resume / Stop” Button
I have a small scrip that basically presses "F2" for me every 4 minutes for the duration of 8hours for the active application.
It works and is really basic as my skills in VB are extremely limited.
...
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
2answers
100 views
Adding to an array in VBA with strings as the index
Not sure I've labelled this correctly.
I have a bunch of cells containing strings of data. Each cell consists of something like this:
q1 = 1 | q2 = 3.2 | q3 = 5.6
q1 = 1.8 | q3 = 2.1 | q5 = 1.4
...
0
votes
0answers
56 views
Create Access ADE file from command line
I have inherited an Access 2007 application that needs to be saved as an ADE before release. Is there a way to do this from the commandline? I am trying to automate the build process as much as ...
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
votes
1answer
43 views
vba to format/parse dataset in csv [duplicate]
Can anyone see whats wrong with this script?
Option Explicit
Dim lrow As Long
Dim lcol As Long
Dim i As Long
Dim j As Long
Dim strow As Long
Dim fso As Object
Dim xl As Excel.Application
Dim wb As ...
-1
votes
1answer
110 views
Connection to MS access 2007 via form using vba
I have created a sample MS access 2007 database and designed a form to retrieve the records of the user , if the username and password entered in the form matches the record.In the button action it ...
0
votes
1answer
59 views
Problems searching HTML with Regular Expressions
I'm trying to use regular expressions for the first time and having some trouble, maybe with my syntax.
Here's a sample string contained in my source file I'd like to find:
Type = Creature / Animal ...
3
votes
0answers
95 views
VBS Very very slow in ms word [closed]
So, I have a 100page long docx format document. I'm using a macro written in VBS to extract some information and then just generate a table from them.
I iterate through the paragraphs and store the ...
