EXCEL Spreadsheet Coding

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Guys can anyone help me with this. Been asked to create an Excel spreadsheet and create an imbedded button that you click to import a list of usernames and passwords from one of a dozen log files (all with different names). This then must be checked to see if the password is missing from the username. The log also has loads of other data on each line like date/time etc that would need to be stripped out. I'm really pissed off as I've told them I'm a 2nd line support/systems engineer and don't have any scripting experience and been told to google it . With the complexity would this type of spreadsheet have to be done via VB script or could it be done with Macros alone?

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

http://www.excelforum.com/

Really useful and some excel whizz kids on there!!

~Ati~

 

Cheers for the tip mate. Off to check it out.

 

There is another way to do it if you don't know Excel VBA, which I think could be slightly easier to pick up for just about anybody.

AutoIt is a scripting language that can do just about anything windows related from playing back a sequence of keystrokes as if you were typing them in on the keyboard to a full Windows Gui program. It also includes Excel and Word functions for creating, amending and saving documents.

It's very easy to produce a standalone EXE file which when run can prompt for the name of the log file to open, and once one is selected copy as much or as little of the file into Excel.

As I said, it's another possibility for you if you end up having to do something yourself.

 

Sounds handy, but alas I can't use it as I work in a secure environment for the MOD. I'll have a look just for my own use down the line.