Excel 2008 Script

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)
        With myRecord
            For Each myField In Range(.Cells, _
                    Cells(.Row, Columns.Count).End(xlToLeft))
                sOut = sOut & delimiter & Trim(myField.Text)
            Next myField
            aArray = Split(Trim(Mid(sOut, 2)), ";")
            '###alter dblogin###
            'Print #1, "APPLY SECURITY FILTER '" & LCase(aArray(1)) & "' TO USER '" & UCase(aArray(0)) & "' ON PROJECT 'Continuum';"

            sOut = Empty

        End With

    Next myRecord

    Close #1

End Sub

Thanks in advance for the help!

Hank Spencer

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.