Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Uploading document to the internet

Status
Not open for further replies.

DeGeus

Technical User
Dec 30, 2003
38
NL
I want to upload an excel document to a internet location with help of a VBA macro. Now I found something in the helpfile but I think I have the following problem. When I want to upload something to my homepage I have to supply a password. But this is not incorparated in the code. Can anybody help me with this.

Some extra information:
Windows XP
Excell 2000
VBA 6.3

Code found in the helpfile:

With ActiveWorkbook
With .WebOptions
.RelyonVML = True
.PixelsPerInch = 96
End With
With .PublishObjects(1)
.FileName = _
" .Publish
End With
End With

Leendert de Geus

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top