I'm a noob in VBA scripting so I decided to ask for some help on running a macro on multiple files in "current directory"
So what I'm trying to do is to run a VBS file from a batch. The vbs file should then run the code created by macro record from Excel on all the xls files in the same directory the vbs file is in. I'm sure the code has to be written somewhere but after googling for an hour I decided to ask here, maybe u can redirect me:P
Another thing that riddles me:
Selection.Sort Key1:=Range("A6"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
...arranges lines from "Range" in ascending order.
But what if I only know the first parameter from "Range" (A6), and the second should be decided based on the certain string found further down the A row, so the range length is different in every file?
Also I found this script that crashed if after dim x there was the "as" parameter...Is that syntax inappropriate in vbs scripts?
aaa, too many quiestions!:P
Thx for (if any) replies! Cheers!