Posted by Derick J. on February 13, 2001 9:36 AM
I'm pre-loading the filename into an input box, but I need to concatenate the value (subject) from A1. This is what I have so far...
DestFile = InputBox("Enter the destination filename" & Chr(10) & "(with complete path):", "KSUCVM Excel File Exporter", "C:\Windows\Desktop\diff_" & A1.Value & ".txt")
It works with a static filename, but not with the concatentation. Any help would be GREATLY appreciated.