Is there a workbook open in Excel?
If workbooks.count0 then
end if
"ExcelMonkey" wrote:
how do you tell in VBA if there is workbook open in excel. That is, when I
launch my xla, I want to check to see if there is at least one workbook open.
If not, I will prompt user to open workbook and exit the xla.
Thanks
|