Em Andamento

Data manipulation in excel

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

Habilidades: Engenharia, Microsoft, Microsoft Access, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Visual Basic para Apps, Área de trabalho do Windows

Ver mais: xls header, string manipulation c, password vba project excel, need someone to do a excel project, print vba, excel vba long, end vba, vba code excel, VBA and excel, save to excel, excel to vba, excel password, data upload from excel, text manipulation, data manipulation excel vba, data range, php save data file, php import data xls, excel vba save data txt, excel secure, vba post, save txt excel, excel vba project password, attribute import, excel delete row

Acerca do Empregador:
( 15 comentários ) Weston, United States

ID do Projeto: #2958203

Premiar a:

deatc

See private message.

$80.75 USD em 14 dias
(52 Avaliações)
5.1

6 freelancers estão ofertando em média $113 para este trabalho

amcsummers

See private message.

$85 USD in 14 dias
(80 Comentários)
5.9
jal540

See private message.

$170 USD in 14 dias
(41 Comentários)
5.7
rperaza26vw

See private message.

$106.25 USD in 14 dias
(6 Comentários)
2.7
vw7358537vw

See private message.

$63.75 USD in 14 dias
(0 Comentários)
0.0
JAPhillips

See private message.

$170 USD in 14 dias
(0 Comentários)
0.0