VBA in Excel : Replace hard-coding with variables - capture values via input ?
in my VBA proc, I'm trying to replace as many instances of having to edit the code every time - even if I have to type manually, that's ok...
How would I input the current date of May 1st in MMDDYYYY format, 05012015 in an input box instead of going in the code and manually changing it
[code]
ChDir "C:\Users\stever\PCDW"
Workbooks.Open Filename:= _
"C:\Users\stever\PCDW\PCDW_CRD_FSR_Combo_Lookup_For_Disposition.xls"
Windows("PCDW_Universal_Report_05012015.xls").Activate[\code]