ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File size of web file via url (https://www.excelbanter.com/excel-programming/396906-file-size-web-file-via-url.html)

SixSigmaGuy[_2_]

File size of web file via url
 
Is there anyway, programmatically with VBA in Excel 2003, that I can retrieve
the filesize of a file on our intranet when the file can only be accessed via
its URL?

I've tried using the FileSystemObject, FileLen, BuiltinDocumentProperties,
but nothing seems to work when the path to the file is a URL.

Thanks!

SixSigmaGuy[_2_]

File size of web file via url
 
Anyone have any suggestions?

"SixSigmaGuy" wrote:

Is there anyway, programmatically with VBA in Excel 2003, that I can retrieve
the filesize of a file on our intranet when the file can only be accessed via
its URL?

I've tried using the FileSystemObject, FileLen, BuiltinDocumentProperties,
but nothing seems to work when the path to the file is a URL.

Thanks!



All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com