0
votes
1answer
20 views

Get data from another Excel file

I have an Excel spreadsheet that contains a list of usernames Each user will have the following code. I just need to find a way to substitute First.Last with the names in the Excel spreadsheet. There ...
0
votes
1answer
196 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
113 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
155 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
316 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
183 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 ...