473,320 Members | 1,820 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Fetch size of the file in excel sheet

1
favorite


This question may already have an answer here:

VBA Excel Function for returning file size in byte 2 answers

For example:

Cell A | Cell B
==================================
http://m---.com/myfile.txt | 4kbs
--------------------------------------------
http://m---.com/myfile.txt | 10kbs
--------------------------------------------
http://m---.com/myfile.doc | 104kbs
----------------------------------------------
http://m---.com/myfile.jpg | 102kbs

I just have URL lists in Cell A and I want to have file size in Cell B.

I tried VBA code for this but its not working. One thing more, I just got this code from internet and its not mine, but it was not help me. Here is code:



Is it possible to fetch the file size on a particular URL in excel? Check the above example, I have the URLs in column A and want to fetch the file size in Column B.
excel excel-vba
Sep 26 '16 #1
1 2409
Luuk
1,047 Expert 1GB
Getting the file size on a URL is not possible.
An URL is a link to a file somewhere (on the internet)

If you want to know the size of the file that is available via an URL, than you will have to download the file.
Dec 17 '16 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Rajiv | last post by:
HI ALL, actually , i m working in a company having large number of employee , i have two userid and password . on id is from admin group(id given to me by technology manager) of the server and...
0
by: dgoel | last post by:
Hi, I Have a text file & I want to open it in excel sheet ( withou importing). I have written code for it, but it is not opening exce sheet. It opens the text file, but does not create a excel...
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
0
by: vinidimple | last post by:
Hi i have a serious problem while i was working in Excel.I want to fetch columns from an excel worksheet and i need to compare it with an sql querry fields,so i tried to open an excle...
8
by: hyper-sensitive | last post by:
Hi Can some body suggest me which approach I should follow to import millions of records from data base into an excel sheet? I am working with ver. 2000 of MS-Excel . The requirement is to...
3
by: dmshah01in | last post by:
hi. i am new to .net i need to fetch data from excel sheet and display it on web page. please help me how to do this???
1
by: prakashsakthivel | last post by:
Hi Members, Maximum size of excel sheet name is 31. is it posssible to increase excel sheet name length . Thanks & Regards musai.
7
by: TG | last post by:
hi! I am trying to create a sql server table from an excel sheet. Here is the code I have: 'This procedure the xlsx file and dumps it to a table in SQL Server
3
by: lokanath60 | last post by:
import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.FileReader; import java.io.IOException; import...
0
by: Dila Ram Gurung | last post by:
I want to write a code in .NET C# which will fetch data from actively running excel sheet. To be more elaborative : I am using an excel sheet which automatically updates its cell value through...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.