Tagged Questions
11
votes
2answers
11k views
Regular Expression Rules in Outlook 2007? [closed]
Is it possible to create rules in Outlook 2007 based on a regex string?
I'm trying to add a filter for messages containing a string such as: 4000-10, a four digit number followed by a dash and then ...
7
votes
2answers
387 views
Start excel from Task Scheduler was working, now fails
I've been running my excel 2000 vba program with Task Scheduler and cscript and vbscript for about a year now. A few days ago it stopped working. I can run the program manually. Whenever Task ...
6
votes
3answers
21k views
Code for looping through all excel files in a specified folder, and pulling data from specific cells
I have about 50 or so Excel workbooks that I need to pull data from. I need to take data from specific cells, specific worksheets and compile into one dataset (preferably into another excel workbook).
...
5
votes
3answers
930 views
Pass existing FileSystemObject or create multiple instances
I have several procedures that use the FileSystemObject. I find it's quite convenient.
Question: Is it sensible to pass an existing instance of FileSystemObject from a "main" procedure to these ...
4
votes
2answers
441 views
sending AT COMMANDS
does anyone know where i can get the official list of all AT COMMANDS available? i would like to get my computer speaking to my cell phone. i need all AT COMMANDS and i will hook it up to either .NET ...
4
votes
3answers
7k views
Apply Font Formatting to PowerPoint Text Programatically
I am trying to use VBA to insert some text into a PowerPoint TextRange, I use something like this:
ActiveWindow.Selection.SlideRange.Shapes("rec1").TextFrame.TextRange.Text = "Hi"
However, I can't ...
4
votes
2answers
2k views
VB - Append to array?
this is probably a super simple question. But I have this Array that I need to strip useless parts from. But I still want it in an array.
So, the array looks like this when it comes in:
ArrValues(0) ...
4
votes
2answers
719 views
Creating objects in VBA and VBS
Recently in trying to access the properties and methods of the windows firewall in vba I referenced hnetcfg.dll and was able to dimension variables for objects like inetfwMGr, inetfwPolicy etc.
But ...
4
votes
1answer
6k views
VBA - Use multidimensional array instead of two separate ones?
Lots of stupid questions lately, but I would appreciate some input on this one.
I've got a string that comes from an INI-file. It looks like Firstname=FIRSTNAME. This is basically an array with loads ...
3
votes
2answers
6k views
VB6/VBScript change file encoding to ansii
I am looking for a way to convert a textfile with UTF8 encoding to ANSI encoding.
How can i go around and achieve this in Visual Basic (VB6) and or vbscript?
3
votes
3answers
1k views
Is there any way to align text in message box in vb or vba?
Is there any way to align text into the center in msgbox in VB or VBA? Does VB have any functionality to do the same?
3
votes
1answer
388 views
Passing custom objects from VBA to VBScript
I have a function in an Excel file that returns a custom class, when i try to call this function from VBScript i get an "Unknown runtime error"
Sample VBA Code:
Function myVBAFunc() As Variant
...
3
votes
2answers
2k views
Calling an External VBA from VBScript
Ok, I am using a program called mathtype to pull some equation objects out of a word document. I've written code in VBA that works perfectly using their API, but I have to translate it to a VBScript ...
3
votes
1answer
77 views
Can we assign the dictionary keys to a column with a single statement?
I have large dictionary keys,Which I want to insert to a column of an excel sheet.Which I have done by the below :
Dim a, d, i 'Create some variables
Set d = CreateObject("Scripting.Dictionary")
...
3
votes
3answers
772 views
What's wrong with this regular expression (VBScript/JavaScript flavor)?
I'm trying to run a regular expression in VBA code that uses Microsoft VBScript Regular Expressions 5.5 (should be the same as JavaScript regular expression).
Regular expression: ...
