Hello,
This one is pretty difficult.
I have a folder with many many workbooks, and I would like to determine automatically whether these workbook has some linked info or include macros.
In other terms, for people who prefer code as words:
for each WORKBOOK in FOLDER
if IsLink(WORKBOOK)=true then Msgbox "WORKBOOK" & WORKBOOK " has link"
if ISMacro(WORKBOOK)=true then Msgbox "WORKBOOK" & WORKBOOK " has Macro" next WORKBOOK
Good luck,
Pierre
This one is pretty difficult.
I have a folder with many many workbooks, and I would like to determine automatically whether these workbook has some linked info or include macros.
In other terms, for people who prefer code as words:
for each WORKBOOK in FOLDER
if IsLink(WORKBOOK)=true then Msgbox "WORKBOOK" & WORKBOOK " has link"
if ISMacro(WORKBOOK)=true then Msgbox "WORKBOOK" & WORKBOOK " has Macro" next WORKBOOK
Good luck,
Pierre