Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box input data concatenate to file name
Is there any suggestions on how to use text boxes to concatenate a file name?
If I have 3 text boxes I want to have the user select or input information and then concatenate this with the date time (hr-sec) to create a unique name that will save the this name as the workbook name in the same location |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box input data concatenate to file name
The following is an example of the type of code required:-
Dim strNowTime As String Dim strTextBox As String Dim strFileName As String strTextBox = ActiveSheet.TextBox1.Value strNowTime = Format(Now, "dd mmm yyyy hh-mm-ss") 'Concatenate TextBox value, space, time, file extension strFileName = strTextBox & " " & strNowTime & ".xls" Regards, OssieMac "gbpg" wrote: Is there any suggestions on how to use text boxes to concatenate a file name? If I have 3 text boxes I want to have the user select or input information and then concatenate this with the date time (hr-sec) to create a unique name that will save the this name as the workbook name in the same location |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate & Write to Text File | Excel Programming | |||
Concatenate to a text file | Excel Programming | |||
Concatenate Text File | Excel Programming | |||
Concatenate Text File | Excel Programming | |||
Input from Text file | Excel Programming |