Forum

Notifications
Clear all

Import Images

9 Posts
2 Users
0 Reactions
63 Views
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi,

I have one column contain Images URLs and I want to import it in second column, please check attached file.

Is this applicable with Excel macros?

Thanks;

Marsil

 
Posted : 15/01/2021 5:06 pm
(@questvba)
Posts: 125
Estimable Member
 

Hi Marsil

Here is a solution found on the net.

BR,

Lionel

 
Posted : 16/01/2021 1:37 am
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi Lionel,

Wow! Thank you so much Lionel. This is awesome. This will save me so much time.

I just has these URLs, but macro can't deal with it, please can you check.

https://media-exp1.licdn.com/dms/image/C560BAQHjoMS1FU87Fg/company-logo_100_100/0/1584045405065?e=1618444800&v=beta&t=Lk4wNsqnAPFME2I2w1mt_WAJRx-10cXrtI3SSYxttD0

https://media-exp1.licdn.com/dms/image/C5603AQHzxEBjGuo2xw/profile-displayphoto-shrink_100_100/0/1588078243927?e=1616025600&v=beta&t=bDrcuTl__H1YdZoNfvDnC1MDZyybYDAwQCPd2n2Vz9k

How kind you are to help me. Thank you very much.

That's a huge help.

Thanks;

Marsil

 
Posted : 16/01/2021 12:58 pm
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi Purfleet,

Please can you help to update the macro to deal with as below URLs. as I need it urgent please

https://media-exp1.licdn.com/dms/image/C560BAQHjoMS1FU87Fg/company-logo_100_100/0/1584045405065?e=1618444800&v=beta&t=Lk4wNsqnAPFME2I2w1mt_WAJRx-10cXrtI3SSYxttD0
https://media-exp1.licdn.com/dms/image/C5603AQHzxEBjGuo2xw/profile-displayphoto-shrink_100_100/0/1588078243927?e=1616025600&v=beta&t=bDrcuTl__H1YdZoNfvDnC1MDZyybYDAwQCPd2n2Vz9k

 

Thanks;

Marsil

 
Posted : 17/01/2021 9:55 am
(@questvba)
Posts: 125
Estimable Member
 

Marsil,

Here is an adaptation.

BR,

Lionel

 
Posted : 18/01/2021 7:44 am
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi Lionel,

Please can you help as I face attached image.

2021-01-17-23_36_06-Microsoft-Visual-Basic-for-Applications-import-image-1-1.xlsm-Module3-Co.png

 

 

Thank you very much; your support is greatly appreciated.

Thanks;

Marsil

 
Posted : 18/01/2021 5:40 pm
(@questvba)
Posts: 125
Estimable Member
(@questvba)
Posts: 125
Estimable Member
 

Hi, Marsil,
I just left on another version to avoid the previous problems. It should work.

BR,

Lionel

 
Posted : 19/01/2021 2:11 am
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi Lionel,

Wow! This is awesome and it works like a charm. Thank you so much!!!

Thanks;

Marsil

 
Posted : 19/01/2021 8:27 pm
Share: