Excel marco to search for unique Word file ref, then enter value in cell

bradleydave

New Member
Joined
May 4, 2021
Messages
1
Office Version
  1. 2010
Platform
  1. Windows
Good afternoon everyone,

I am looking to improve upon the speed in which a 1500 Excel sheet is populated, in order to create a total value.

The list shows basically three columns; 1 column of unique ID references (Asset Ref); 1 column for the value of this asset; 1 column to confirm the asset has been checked. The way in that the asset has been checked is that a Word report is uploaded to the relevant drive. This Word filename will always start with the unique asset reference in its title.

I am looking for a formula or VBA code that will lookup the Asset reference and search in a specific folder & subfolders to see if the Word document exists. If so, then add the Asset value to Col C, if not, then leave blank.

book1.JPG



I've looked across the web and found examples that will identify if one file or folder exists, but potentially I have 1500 files to check for, so would this be possible under one command?

Thanks in advance.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,147,498
Messages
5,741,504
Members
423,663
Latest member
kaveh87rsh

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