2MG image files do not download

I can successfully (scrape) / download image files from a URL list on my server.
However; there appears to be a size limit as nothing downloads over 1Mg size and 80% of the images on the list of 10,000 target URLs are 2Mg images taken in high resolution with my Nikon.
I like this tool and want to purchase it but I cannot use it if I cannot make it work.
Are there setting or additional commands I need to put into the formula to target larger images?

I have tried formula:
=DownloadFile(E2,"E:20231114 ZOEY DOWNLOAD URL BACKUP numbered",M2)

And:
=@DownloadFile(E2,N2,M2)

Same result for both.
Only the smaller images appear in the receiving file.
I have left it all night to execute.

It appears to locate all the targeted 10,000 files on the Server. I know this because if I delete the receiving image directory Microsoft gives me a message that it is deleting 9,600 files; however, only 4,500 are visible in the directory.

I also noticed that the files in the folder where sorting by size, with the smallest files completing the download first. Then sorting alphabetically as the larger files downloaded.

Is it just a question of time to allow the larger files to download?
I realize it would be impossible to predict how long it should take because of all the possible variations on internet connection speed, CPU clock speed and the response of the Server etc.

Is there any other reason or method I can try?
Batches of 1,000?
Are there other settings?

Any assistance is appreciated.
Please let me know - thank you.

1 Like

Hi, we have no such limit in the DownloadFile function and I successfully downloaded files above 2mb in size. Can you provide the list of your image links or a sample so I can debug this?

Thank you for the response. I think it may have been the combination of the size and quantity of files downloaded at one time. I am going to test an individual image and , if successful, then increase the target size. I will let you know.

The test was successful. I am going to retry the original images.
QUESTION: is there a procedure to dis-engage items that you have previously attempted to upload. I have experienced warnings and notifications that the file is "Busy".

It just refuses to work. I get debug and error messages.
These are the URLs.

media_image
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c-
-c_bmw_e46_320i_3_series_4dr.6_cyl_m54_nov_2003_5_spd_manual_kl10854_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/c//c_bmw_e46_320i_3_series_4dr.6_cyl_m54_nov_2003_5_spd_manual_kl10854_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/c/
/c_bmw_e46_320i_3_series_4dr.6_cyl_m54_nov_2003_5_spd_manual_kl10854_3.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e46_320i_3_series_4dr.6_cyl_m54_nov_2003_5_spd_manual_kl10854_4.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c-
-c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_1_.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/c//c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_9.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/c//c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_12.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_11.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_14.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_6.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_3.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_7.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_10.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_4.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_8.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_15.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_5.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_13.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-c--c_bmw_e53_x5_4.4i_built_june_2003_m62_engine_4x4_awd_suv_auto_lh50127_12.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-catalog-product-e-2-e21_318_m10_6_cylinder_for_1975_engine_bmw_1976_e12_518_1.8l_1_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/e/2/e21_318_m10_6_cylinder_for_1975_engine_bmw_1976_e12_518_1.8l_1_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/d/h/dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_6_.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/d/h/dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_2_.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/d/h/dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_1_.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/d/h/dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_4_.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/d/h/dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_3_.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z//z_dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_1.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/d/h/dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_5_.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z//z_dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_2.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z//z_dh-10_bmw_64221908671_1908671_used_oem_heater_duct_left_e34_e32_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/_/d/dsc0343_1_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0346_2_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0347_2_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0345_2_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0344_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0348_2_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0349_2_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0350_3.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0059_8_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0061_5_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0062_4_3.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0060_3_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/b/m/bmw-images-diag_42l3.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-a90d8ad4e7ccc7caffdc53c4cf6f5e45-ee71b289f40fc2abf37713be55f8af0b.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-a90d8ad4e7ccc7caffdc53c4cf6f5e45-4f8f25e43c2b4c2407d5498b5ace9004.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-a90d8ad4e7ccc7caffdc53c4cf6f5e45-badef10e3e547762452f7b1870d2d5ac.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0127_7_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0129_6_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0131_5_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0130_6_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0132_4_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0128_7_1.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0133_6_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-3470526321714cec91593db469e4cb02-3a3c939294d07d00d98accac5e04a71a.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-3470526321714cec91593db469e4cb02-2a4ceb4210aacdadb0f4717609b64706.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-3470526321714cec91593db469e4cb02-98750255e9ef6b6282d5f60472c27303.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-456c75b362f5cf75217ed793cfaaad70-783ead9a72df4571d153b9619b6845ca.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-456c75b362f5cf75217ed793cfaaad70-def4f088e0c10e5870bb840f1af2a7a5.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/s/t/strapr1-456c75b362f5cf75217ed793cfaaad70-81bb223b2fac7136a71ae91ba14945b9.png
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0061_5_11.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0060_3_9.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0063_4_14.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0065_3_13.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0059_8_11.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0064_4_12.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0062_4_12.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0079_6_4.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0082_6_4.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0080_5_5.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0083_6_4.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0081_5_2.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/dsc0085_7_5.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/
/d/_dsc0084_7_5.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-banner-with-e-mail-and-phone.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-euro-all-parts-sco-google-image.jpg
https://s3.amazonaws.com/zcom-media/sites/a0iE000000Hvpe1IAB/media/catalog/product/z/c/zcom-media-sites-a0ie000000hvpe1iab-media-import-z-logo-euro-eruoparts-no-image-message.jpg

After continuing to experiment it appears that the problem disappears and the scraping will be successful if the file directory receiving the images is as simple as possible. (ie.) C:\1 and the name as strictly a short number string. This is not good for me because I need to sort the images in different ways and search them in different ways. I will keep experimenting to find out if it is a complex directory or complex name that creates the issue.

UPDATE: Three items.
I have to claim success! but had some issues.

1)It appears that it was the length of the name of receiving directory. You may wish to address that with programming or direct users to Name the receiving directory in their formula \1 or \2 on a root directory. Fill it, and then copy the contents to a directory with a desired name in a desired location.

  1. There appears to be an issue with the actual length of the URL names. If the name is beyond the set number of characters that causes Excel to utilize a second line in the name bar - the program places a #VALUE code in the name column. To correct this one can locate the coded items, click on the URL Name Cell associated with the error, move to the Excel view window and arrow down to the second line of code. Click back on the associated URL name cell and the "#VALUE" code will be replaced by "#GETTING DATA". And the scrape should complete.

NOTE: The reason our URL's are so long is the use of AWS tired party storage that applies re-directs to data when servers are re-arranged. Some of the URL names can become extremely long over time.

This leads to...
3) If the URL name is of suffient length to extend past the second line in Excel; the program truncates the name. This maybe done by EXCEL as part of the download process. Since the URL is truncated - it is incomplete, so will not work and any URLs with these long names cannot even be identified because the URL is not complete and the name does not appear to assist in identification. The error code "#VALUE" appears in the name column. There were only 16 of these but it will take time to figure out what they are. and down load them manually.

I hope at a minimum this allows you to improve your already excellent product.