I need someone to explain throughly this excel vba. Please explaine every command and every word and give refrences as possible to related links on the web. Also, explaine what parameters are possible for any of these commands and what would they do: Public Sub Create_Text_File() Dim strItemNumber As String, _ strShortDescription As String Dim lngRecCount As Variant, _ FName As String, _ FNum As Long, _ i As Long On Error GoTo ErrHandler ' initialize params i = 1 lngRecCount = InputBox("Please give the number of records to export") If Not IsNumeric(lngRecCount) Then Exit Sub strSeparator = Chr(9) FName = InputBox("Please give filename + path like, C:\[login to view URL]") Open FName For Output As #1 ' print header WholeLine = "Item Number" & strSeparator & _ "Short Description" Print #1, WholeLine ' printe data For i = 2 To lngRecCount WholeLine = "" ' build string parts strItemNumber = CStr(Range("A" & i).Value) & strSeparator strShortDescription = "Great Painting Titled: " & _ CStr(Range("C" & i).Value) & _ " by the world famous Artist " & _ CStr(Range("B" & i).Value) & strSeparator ' build string to write WholeLine = strItemNumber & _ strShortDescription ' write string Print #1, WholeLine Next i Close #1 Exit Sub ErrHandler: MsgBox "An error has occured " & [login to view URL] Close #1 Exit Sub End Sub
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Excel WIN 98 WIN XP