I have been working on a complex Excel project that produces several new pages (with auto-generated names) based on user interaction. The intent of the workbook is to store X number of staffings and follow-up forms for a month of staffing activity. I have set up a Save Workbook macro to pull up the Save As... dialog box with a pre-written name for the workbook, which is StaffForms[MonthDate]. What I'd like to do is add the Case Numbers for all the initial staffings generated in the file name so people can tell what cases are stored in a particular workbook.
There is a region on a sheet that has each case number listed in a single column. I'd like to iterate thru the case number block and write out a string like so: [case number], [case number], [case number]...[MonthDate]
Any suggestions on how to do this? I can reference the array and loop thru it no problem but can't figure out how to pull out the cell contents and concatenate a string. CONCATENATE does not seem to exist in VB (doesn't come up in the Object Browser) and the Concatenate formula works sorta but you can place ", " or any other text stuff into the formula.