View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chadersmith Chadersmith is offline
external usenet poster
 
Posts: 12
Default Saving as a 2003 file in 2007

Hi Guys,

I've created a macro on 2003 that is associated with a 2003 xls (it has an
ActiveWorkbook.Save function in there). I had tested the macro on my computer
(running Office 2003) multiple times without failure. I then tested the macro
on a collegue's computer (office 2007) without failure.

I then attempted to make some updates on my computer but ran into a dll
issue. I resaved the entire file from my collegue's comp as a 2003 and was
fine. Is there a way to have an activeworkbook.save function in VBA that will
save as a 2003?

As always, any help is greatly appreciated. Please let me know if I was not
clear.