Re: Find&Replace on a lot of *.doc' s via an excel macro?
From: Martyn (ayes_at_post.com)
Date: 06/09/04
- Next message: Peo Sjoblom: "Re: flaw in Excel's filter command for negative numbers"
- Previous message: Pat K: "Excel 2000 & XP with Vision Add In"
- In reply to: Tom Ogilvy: "Re: Find&Replace on a lot of *.doc' s via an excel macro?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 17:08:20 +0300
Thanks for the suppot Tom.
"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:e5sLLyYTEHA.1472@TK2MSFTNGP12.phx.gbl...
> 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
- Next message: Peo Sjoblom: "Re: flaw in Excel's filter command for negative numbers"
- Previous message: Pat K: "Excel 2000 & XP with Vision Add In"
- In reply to: Tom Ogilvy: "Re: Find&Replace on a lot of *.doc' s via an excel macro?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
