0
votes
1answer
162 views

How to Replace Words With VBScript Regex and VBA?

what is vbscript syntax for .net: \b[a-z]+\b Hi trying to replace all alpha words in the source. .net regex tester confirms this pattern will find all words: \b[a-z]+\b this: ...
1
vote
1answer
107 views

Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc. We are basically trying to ...
0
votes
1answer
149 views

VBScript Carriage Returns

I write the following VB script in order to run commands from WIN XP on Linux machine and redirect the output command to out.txt file ( under C:\ ) My VB script I print the /etc/hosts file from Linux ...
0
votes
1answer
280 views

VB sciprt + how redirect output from CMD window to file

I wrote the following VB script in order to run commands from WIN XP on a Linux machine and redirect the output command to out.txt file ( under C:\ ) I don’t understand why output from the command ...
0
votes
2answers
2k views

How do I publish/export Microsoft Access Forms

I developed some forms in Microsoft Access and have yet to connect the forms with the database. However I would like to build and maybe publish the forms so I can view them outside of Access. how do I ...
1
vote
1answer
182 views

Creating Custom Sortable datatypes in excel

I want to define a custom data type in excel 2007, a date range. Basically, it's an array of dates or smaller date ranges like: "{ 01-26-1991 , 01-01-2004 to 12-31-2004 , 12-13-2017 }" which ...