Data manipulation in excel

Completed Posted Nov 10, 2009 Paid on delivery
Completed Paid on delivery

Need someone to work with VBA within Excel to do the following:

Import ascii text all columns set to text

Set several columns to a calculated value

Delete the header (1st row)

Save file in XLS format

Use a VBA program to write file into ASCII file

End of? phase 1 of project

Phase 2

Login into a secure site with username and password

click on a button

post? ASCII file from Phase 1 above? into browse window

click on upload button.

Watch for confirm message

logout of secure site.

## Deliverables

Here is the VBA code to write the file in ascii comma delimited.

Attribute VB_Name = "Module1"

Public Sub OutputQuotedCSV()

Const QSTR As String = """"

Dim myRecord As Range

Dim myField As Range

Dim nFileNum As Long

Dim sOut As String

nFileNum = FreeFile

Open "L:\OUTPUT\[url removed, login to view]" For Output As #nFileNum

For Each myRecord In Range("A1:A" & _

Range("A" & [url removed, login to view]).End(xlUp).Row)

With myRecord

For Each myField In Range(.Cells(1), _

Cells(.Row, 256).End(xlToLeft))

sOut = sOut & "," & QSTR & _

Replace([url removed, login to view], QSTR, QSTR & QSTR) & QSTR

Next myField

Print #nFileNum, Mid(sOut, 2)

sOut = Empty

End With

Next myRecord

Close #nFileNum

End Sub

Engineering Microsoft Microsoft Access MySQL PHP Project Management Software Architecture Software Testing Visual Basic for Apps Windows Desktop

Project ID: #2958203

About the project

6 proposals Remote project Active Nov 12, 2009

Awarded to:

deatc

See private message.

$80.75 USD in 14 days
(52 Reviews)
5.1

6 freelancers are bidding on average $113 for this job

amcsummers

See private message.

$85 USD in 14 days
(80 Reviews)
5.9
jal540

See private message.

$170 USD in 14 days
(41 Reviews)
5.7
rperaza26vw

See private message.

$106.25 USD in 14 days
(6 Reviews)
2.7
vw7358537vw

See private message.

$63.75 USD in 14 days
(0 Reviews)
0.0
JAPhillips

See private message.

$170 USD in 14 days
(0 Reviews)
0.0