Finding Workbook name - HELP
I need to show an inputform only when a certain workbook is open. the problem
i am having is that when i open the file, i input info into the inputform and
when i hit enter, it saves a copy of the file as another name but with the
same code, hense "inputform.show" stuff. I dont want the new file name to
show the inputform when it is open, only show when origional is opened.
something like this maybe? thx
If WorkbookName = "Filename.xls" Then
InputForm.Show
Else
Do nothing
End If
|