Find Jobs
Hire Freelancers

Data manipulation in excel

$30-200 USD

Completed
Posted over 14 years ago

$30-200 USD

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\[login to view URL]" For Output As #nFileNum For Each myRecord In Range("A1:A" & _ Range("A" & [login to view URL]).End(xlUp).Row) With myRecord For Each myField In Range(.Cells(1), _ Cells(.Row, 256).End(xlToLeft)) sOut = sOut & "," & QSTR & _ Replace([login to view URL], QSTR, QSTR & QSTR) & QSTR Next myField Print #nFileNum, Mid(sOut, 2) sOut = Empty End With Next myRecord Close #nFileNum End Sub
Project ID: 2958203

About the project

6 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$80.75 USD in 14 days
5.0 (52 reviews)
5.1
5.1
6 freelancers are bidding on average $113 USD for this job
User Avatar
See private message.
$85 USD in 14 days
4.9 (80 reviews)
5.9
5.9
User Avatar
See private message.
$170 USD in 14 days
4.9 (41 reviews)
5.7
5.7
User Avatar
See private message.
$106.25 USD in 14 days
5.0 (6 reviews)
2.7
2.7
User Avatar
See private message.
$63.75 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$170 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Weston, United States
5.0
15
Payment method verified
Member since Apr 4, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.