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
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