LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro warning even though macros have been removed. Stu Excel Discussion (Misc queries) 2 January 3rd 07 03:25 PM
macro warning - but no macros GJR3599 Excel Discussion (Misc queries) 1 April 13th 05 08:15 PM
Macro Warning in File w/o Macros? Joe HM Excel Programming 4 March 29th 05 08:38 PM
Macro warning when no macros Allison Excel Programming 8 October 22nd 04 11:26 PM
Macro warning when no macros in workbook BillS[_2_] Excel Programming 15 October 25th 03 01:29 PM


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"