macro to open csv file on the web with password

A

andycg

Hi all -

confused noob here :) i want to create a function in excel to open
csv file on the web and then do copy and paste. so far so good until m
company decided to put password on the link for security reason. m
current script (without password) looks like this:

Workbooks.Ope
Filename:="http://www.ourwebsite.com/folder/samplefile.csv"

it works without password. the question is: how do i script the macr
to open this csv file if the link is password protected?

thanks a bunch!
And
 

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

How to Unlock Excel Workbook protected by MACRO Password 6
open ftp with password 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Closing workbook open as CSV 3
Command Button to export a worksheet as a .csv file 1
Looping Open and Save as CSV 9
Save Excel file to a CSV without opening it first 4
How to open a password protected powerpoint file by Excel macro 2

Top