Variable Folder Name Based on Excel Cell Value

[LiamDuffield]

Hi Everyone,

Just need a bit of help, not exactly the best with VB.

I've got the below code to print out everything in a specified target folder, which works quite nicely.

However, I want to change this so the main path stays the same, but the end folder is based on a cell value in Excel

Cell value would eventually be a number.

E.g. TargetFolder = "C:\Stuff\CELLVALUE"

Any ideas/guides would be great.

Please Login or Register  to view this content.

[ragulduy]

You can do something like:

Please Login or Register  to view this content.

[LiamDuffield]

Frustration makes us all blind.

No idea why I didn't see this before.

Thanks very much!