Valkie (valkyri) wrote in ms_access,
Valkie
valkyri
ms_access

Excel question

I know this is an Access forum, but taking a shot that someone might know enough about Excel VBA.

Here is my dilemma. I have a sheet that needs to be formatted in order to be imported to an Access database. I've created a macro to do this, but the problem is that the guy who keeps the sheet up to date keeps adding comments in little comment boxes.

Is there a way to delete all comments from an excel sheet? Like, can I loop through a collection or something?

Thanks.
  • Post a new comment

    Error

    default userpic
  • 2 comments