VB Formula / Macro Advice

b5nrd

New Member
Joined
May 22, 2014
Messages
2
Hi Everyone!,

Here is my dilemma, I have an excel sheet that I use to collate survey photo’s.

At the moment the workbook is a template where the only thing that changes is the photos I insert. I have a box for the photo and a box underneath that describes the photo.

For example box which is in cell "B7" is for photograph 11.1.1.1 and the description underneath "B8" states 11.1.1.1 – Tower at 300m.

I would like excel to read the same folder and pull the photographs through in one big go and resize them to fit if possible.

I was thinking about using VB and setting up a Variable then I was thinking it wouldn't be hard to just have one spreadsheet with one folder in one location I can drag photo’s into and once am done delete them and start again.

That way I do not need to change anything or consider locations of folders that will change.

Sorry for the vagueness in my head I know what I want to do, just before I dust off the old VB cobwebs just wondered if anyone has encountered this before?

I have 400 telecoms sites and each sites can have something like 100 photo’s in, so hope you can understand why I would like my life to be that tad easier.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

b5nrd

New Member
Joined
May 22, 2014
Messages
2
It is ok, got it in the end.

Surprised at how much I remember after all these years.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,290
Messages
5,600,759
Members
414,405
Latest member
Zaurb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top