Transfer files & change file attributes with VBA ?

B

Bassman62

Using Excel 2007 / WinXP
The tasks at hand:
Use FTP to transfer a text file from a Unix Server to a Windows Server.
Remove "Read-only" attribute from "Job_Report.xls"
Open "Job_Report.xls"

*In "Job_Report.xls", Refresh a text import (from the text file just moved)
*For this part I have code that unprotects the sheet, refreshes the connection
then protects the sheet. The code is in a code module in "Job_Report.xls".

Close "Job_Report.xls" and set the "Read-only" attribute.

Is there a way to control the FTP program or access the file via another
method?
Can I set file attributes with VBA? How?
Many thanks.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying files with attributes 0
Possible to Transfer/Open "Read" a text file into VBA Module? 6
code for Allow Insert Hyperlink 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel VBA help: Text file formatting 19
File Attributes 8
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
analyzing data with VBA 4

Top