Using value user inputs into text box as part of File Name

[richand1]

Hi all.

I am working on a project that involves formatting a vast array of workbooks in exactly the same way.

One of the problems I have come across is, although the bulk of the filename will be different across the books - Coffee.xls, Tea.xls, Hot Chocolate.xls, for example - the reporting period will the same for them all - P10 for example. These reporting periods may not always be in chronological order however, for one reason or another.

So, my question is, is there anyway way to open a textbox in order for the user to input the reporting period number - 1-12 - so that I can use this value in the filename when I come to save it down in my existing code?

All help will be much appreciated.

Thanks
Rich

 

[PHV]

Have a look at InputBox in the VBA help.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[richand1]

Thanks PH! That was exactly what I needed!