View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
 
Posts: 92
Default Still Macro Warning w/o Macros ...

Hello -

Sorry to bug you guys again but I have been using code to strip out any
possible VB code and module from my file. Then I do a SaveAs and close
it.

ActiveWorkbook.SaveAs Filename:="Dummy.xls", FileFormat:=xlNormal
ActiveWorkbook.Close

When I open the file Excel will still prompt me with the macro warning.

So I played with it and added the following lines after the above code
.... essentially re-opening the file and saving it again.

Set lLogFile = Workbooks.Open("Dummy.xls")
lLogFile.Save
lLogFile.Close

For whatever reason this helped and now I don't get the warning anymore
when I open Dummy.xls.

I would rather not do it that way so maybe somebody out there has an
idea what is going on?

Thanks,
Joe