Excel Forum

Import Images

Marsil Sarvis

Member

Members

Forum Posts: 73

Member Since:
September 6, 2019

Offline

January 15, 2021 - 7:06 am

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

See Answer

Lionel Baijot

Member

Members

Forum Posts: 119

Member Since:
September 9, 2020

Offline

January 15, 2021 - 3:37 pm

Hi Marsil

Here is a solution found on the net.

BR,

Lionel

Answers Post

Marsil Sarvis

Member

Members

Forum Posts: 73

Member Since:
September 6, 2019

Offline

January 16, 2021 - 2:58 am

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/d.....I3SSYxttD0

https://media-exp1.licdn.com/d.....CPd2n2Vz9k

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

That's a huge help.

Thanks;

Marsil

Marsil Sarvis

Member

Members

Forum Posts: 73

Member Since:
September 6, 2019

Offline

January 16, 2021 - 11:55 pm

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/d.....I3SSYxttD0
https://media-exp1.licdn.com/d.....CPd2n2Vz9k

Thanks;

Marsil

Lionel Baijot

Member

Members

Forum Posts: 119

Member Since:
September 9, 2020

Offline

January 17, 2021 - 9:44 pm

Marsil,

Here is an adaptation.

BR,

Lionel

Marsil Sarvis

Member

Members

Forum Posts: 73

Member Since:
September 6, 2019

Offline

January 18, 2021 - 7:40 am

Hi Lionel,

Please can you help as I face attached image.

Thank you very much; your support is greatly appreciated.

Thanks;

Marsil

Attachments

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

Lionel Baijot

Member

Members

Forum Posts: 119

Member Since:
September 9, 2020

Offline

January 18, 2021 - 3:21 pm

Marsil,

This ? I hope.

NB : https://docs.microsoft.com/en-.....fe-keyword

Lionel Baijot

Member

Members

Forum Posts: 119

Member Since:
September 9, 2020

Offline

January 18, 2021 - 4:11 pm

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

BR,

Lionel

Marsil Sarvis

Member

Members

Forum Posts: 73

Member Since:
September 6, 2019

Offline

January 19, 2021 - 10:27 am

Hi Lionel,

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

Thanks;

Marsil

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Srikanth Amudhan, Kumud Patel

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Import Images|VBA & Macros|Excel Forum|My Online Training Hub