jjcarter1988
New Member
- Joined
- Nov 24, 2013
- Messages
- 28
Hi All,
I am wondering how to use the Shell feature in VBA to call a terminal (using mac), then run a perl script called read_scalepack.pl on a log file that I have chosen using GetOpenFileName.
Right now I am just using Terminal to issue the .pl script (its parsing a log file) and then importing the results in excel workbook.
My terminal command looks like this: read_scalepack.pl example.log > example.csv
I turn the parsed log file into a csv file so I can import correctly into excel using delimiters.
So far I have:
This lets me choose the log file I want. I suppose the next part may look something like:
Obviously I'm stuck there. I am not sure how to turn it into a csv file or if I need to. Also not sure how to specify to create everything in the directory that I have chosen the log file from.
Any help would be most appreciated.
I am wondering how to use the Shell feature in VBA to call a terminal (using mac), then run a perl script called read_scalepack.pl on a log file that I have chosen using GetOpenFileName.
Right now I am just using Terminal to issue the .pl script (its parsing a log file) and then importing the results in excel workbook.
My terminal command looks like this: read_scalepack.pl example.log > example.csv
I turn the parsed log file into a csv file so I can import correctly into excel using delimiters.
So far I have:
Code:
Dim logFileName As Variant
logFileName = Application.GetOpenFilename(FileFilter:="")
If logFileName = False Then Exit Sub
This lets me choose the log file I want. I suppose the next part may look something like:
Code:
Call Shell("read_scalepack.pl" & "logFileName")
Obviously I'm stuck there. I am not sure how to turn it into a csv file or if I need to. Also not sure how to specify to create everything in the directory that I have chosen the log file from.
Any help would be most appreciated.