I have a VB snippet that i ran in excel under Windows that i need to convert to apple script. I have been looking around at some of the scripting tutorials and excel specific tutorials and have so far been unable to reproduce this code. I will post the VB code below and will be very greatful for any help or pointers in the right direction.
Public Sub ScriptMaker()
Const delimiter As String = ";"
Dim myRecord As Range
Dim myField As Range
Dim nFileNum As Long
Dim sOut As String
Dim aArray() As String
nFileNum = FreeFile
Open "c:\secfilter.txt" For Output As #1
For Each myRecord In Range("A1:A" & _
Range("A" & Rows.Count).End(xlUp).Row)
For Each myField In Range(.Cells, _
sOut = sOut & delimiter & Trim(myField.Text)
aArray = Split(Trim(Mid(sOut, 2)), ";")
'Print #1, "APPLY SECURITY FILTER '" & LCase(aArray(1)) & "' TO USER '" & UCase(aArray(0)) & "' ON PROJECT 'Continuum';"
sOut = Empty
Thanks in advance for the help!
Well while many of us probably do have some VB script experience not everyone does. So rather than show us what you had tell us what you want.
Here is the ultimate goal: I am a platform administrator for a large implementation of a BI tool. What i need to be able to do is input into excel user name and then any number of permissions for a large group of users (sometime upwards of 5,000 at a time). The script will then need to add the text from those cells into another line of text (ex “set user ‘cell1’ with permission ‘cell2’” something like that). This will then need to loop through all cells and write to a text file some where.
Does that make sense the way i described it?
anyone have any thoughts on this problem that i am having?
Are you starting with an Excel document or a text file?
You are looking for a text file when finished correct?
i am starting with an excel file and producing a text file.
Can you tell me how many columns of information need concatenating?
And, are they the same columns for each user?
It looks doable, but you’ll probably need to be a bit more detailed in your description. I work scripting excel all day long. email or PM me and I’ll see what I can do to help if you need it.