Y luego procesarlo con la siguiente macro, la cual me generará el código de creación del Form:
Sub Macro1()
Set fso = CreateObject("Scripting.FileSystemObject")
Set arch = fso.OpenTextFile("C:\Users\Jorge\Downloads\script.vbs", 2, True)
arch.WriteLine "On Error Resume Next"
arch.WriteLine "Set newForm = dSession.Forms(""18b05f5041c54a5b8ba12984f5a6b569"")"
arch.WriteLine "ErrNumber = Err.Number"
arch.WriteLine "On Error GoTo 0"
arch.WriteLine "If ErrNumber <> 0 Then"
arch.WriteLine " Set newForm = dSession.FormsNew"
arch.WriteLine " newForm.GUID = ""18b05f5041c54a5b8ba12984f5a6b569"""
arch.WriteLine "End If"
arch.WriteLine "newForm.Name = ""CRM_Ventas"""
arch.WriteLine "newForm.Description = ""Ventas"""
arch.WriteLine "newForm.URLRaw = ""[APPVIRTUALROOT]/forms/generic.asp"""
arch.WriteLine "newForm.Application = ""Cloudy CRM"""
arch.WriteLine
arch.WriteLine
i = 2
Do While Cells(i, 1) <> ""
arch.WriteLine "On Error Resume Next"
arch.WriteLine "Set newField = newForm.Fields(""" & Cells(i, 1) & """)"
arch.WriteLine "ErrNumber = Err.Number"
arch.WriteLine "On Error GoTo 0"
arch.WriteLine "If ErrNumber <> 0 Then"
arch.WriteLine " Set newField = newForm.Fields.Add(""" & Cells(i, 1) & """)"
If Cells(i, 3) = 1 Then ' Char
arch.WriteLine " newField.DataType = " & Cells(i, 3)
arch.WriteLine " newField.DataLength = " & Cells(i, 4)
ElseIf Cells(i, 3) = 2 Then ' Date
arch.WriteLine " newField.DataType = " & Cells(i, 3)
ElseIf Cells(i, 3) = 3 Then ' Numeric
arch.WriteLine " newField.DataType = " & Cells(i, 3)
arch.WriteLine " newField.DataPrecision = " & Cells(i, 5)
arch.WriteLine " newField.DataScale = " & Cells(i, 6)
End If
arch.WriteLine " newField.Nullable = True"
arch.WriteLine "End If"
arch.WriteLine "newField.DescriptionRaw = """ & Cells(i, 2) & """"
arch.WriteLine
i = i + 1
Loop
arch.WriteLine
arch.WriteLine "newForm.Save"
arch.Close
End Sub
No hay comentarios:
Publicar un comentario