Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the suppot Tom.
"Tom Ogilvy" wrote in message ... Instead of using Activedocument.SaveAs, use Activedocument.Save The ActiveDocument.Save requires no arguments. I am not sure why you saved the recorded macro in word at all. I thought you wanted to do this from Excel. You should have recorded the macro, then copied it an pasted into notepad or into an Excel module, then closed the document in word without saving or deleted the macro. So to get rid of the elements, I guess you should go to the module, do Ctrl+A, then delete. Then save the document. If they are in a general module, then you can delete the module in the VBE using the project explorer. I am not a big Word users, so if you need help working in word, you might want to use the word newsgroups for better answers. -- Regards, Tom Ogilvy --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.701 / Virus Database: 458 - Release Date: 07.06.2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Find and Replace | Excel Discussion (Misc queries) | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
find&replace macro | Excel Worksheet Functions | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
find and replace macro need help | Excel Programming |