Käynnissä

VBA Code Modificatoin Needed

I have the following code I need modified to save a text file to an FTP site. The FTP site is saved to my computer. The current code looks into an existing column for the value "1" and if that exists, the code captures the data in a cell several columns over. Then it pops up a save dialog.

What I want to happen is that the file is saved automatically without the dialog box to an FTP site.

This is the file path:

ftp://[url removed, login to view]

This has been attempted by someone with basic VBA skills, but he ran into a problem saving to an FTP site.

Currently, when the Save dialogue box opens and I try to save to the FTP site I get this error:

"Bad file name or number"

The code is below:

Sub Button1_Click()

Dim r As Range

Dim c As Range

Dim OutputFileNum As Integer

Dim PathName As String

Dim RowNum As Integer

Dim SheetValues() As Variant

Dim filePathVariant As Variant

' displays the save file dialog

filePathVariant = [url removed, login to view]( _

FileFilter:="Text Files (*.txt), *.txt")

' checks to make sure the user hasn't canceled the dialog

If filePathVariant <> False Then

PathName = filePathVariant

OutputFileNum = FreeFile

Open PathName For Output Lock Write As #OutputFileNum

Set r = [url removed, login to view]([url removed, login to view]("AX8"), [url removed, login to view]("AW8").End(xlDown))

For Each c In [url removed, login to view]

If [url removed, login to view] = 50 And [url removed, login to view] = 1 Then

Print #OutputFileNum, [url removed, login to view]([url removed, login to view], 41).Value

End If

Next c

Close OutputFileNum

End If

End Sub

Taidot: Visual Basic

Näytä lisää: code vba ftp, convertir code vba php, code vba refresh access, convert lisp code vba, optimization function code vba, ean code vba, ftp code vba, code vba pay, optimize code vba excel, code read text file

About the Employer:
( 1 review ) Dublin, Ireland

Projektin tunnus: #14795465

Myönnetty käyttäjälle:

ksriniravi

I can fix the macro to save the file properly in ftp site for Eur 50. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over t Lisää

50 € EUR 2 päivässä
(21 arvostelua)
4.7

13 freelanceria on tarjonnut keskimäärin 135 € tähän työhön

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 year Lisää

150 € EUR 3 päivässä
(77 arvostelua)
6.5
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Nex Lisää

89 € EUR 1 päivässä
(53 arvostelua)
5.5
zu02

I'll fix it Relevant Skills and Experience vba Proposed Milestones €155 EUR - default

155 € EUR 3 päivässä
(17 arvostelua)
5.2
barundebnath

VBA is a obsolete technology. You should use VB.Net or C# to create program which can solve your problem easily. Thanks. Relevant Skills and Experience C#, Vb.Net programmer. Proposed Milestones €200 EUR - Milestone

200 € EUR 7 päivässä
(16 arvostelua)
4.8
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i Lisää

100 € EUR 3 päivässä
(6 arvostelua)
2.6
jaydeepniper2011

A proposal has not yet been provided

30 € EUR 1 päivässä
(4 arvostelua)
2.0
chintuag

Dear Hiring Manager, I am a professional and working on excel for last 10 years. I have worked with macros and formula's to create dashboards, reports and automation. I have read the details of your project and I'm su Lisää

37 € EUR 2 päivässä
(1 arvostelu)
1.4
166 € EUR 1 päivässä
(0 arvostelua)
0.0
155 € EUR 3 päivässä
(0 arvostelua)
0.0
Steev07

A proposal has not yet been provided

155 € EUR 3 päivässä
(0 arvostelua)
0.0
itdoctor71

Hello, I have some queries and need some discussion regarding the project before start. Please check our profile,portfolio(our completion rate is 100%) and kindly initiate me on chat for discussion. Relevant Skills a Lisää

250 € EUR 3 päivässä
(0 arvostelua)
0.0
222 € EUR 5 päivässä
(0 arvostelua)
0.0