Hi There - using Mac Excel 2011.

Have been searching through these forums looking for a solution, but although I see similar things, none quite do what I want.

I have a folder:

Excel doc is in here
Along with Folder "22 Feb 13"

Within "22 Feb 13" folder are the following folders:

Australia
Dubai
France
Hong Kong
New York
Singapore

Within each of these folders are a number of folders named by Company

Within each Company folder is a number of .png images.

So individually I can:

Insert Hyperlink to Document

This will display as:

22 Feb 13/Australia/Company/image.png

The below I assume I can just record a basic macro:

Using Text to Columns - using "/" as a delimiter this will output to columns -

22 Feb 13
Australia
Company
image.png


Is it possible to automate the Insert Hyperlink function, so that It will look at all folders and sub folders of current directory and insert all .pngs in a row on its own?

As it can be done on an individual basis, it makes me think it can be done in a batch, but I really have no experience of VB to understand the queries I would have to make.

Any assistance is gratefully received!