Re: Macro from WORD to FRONT PAGE by Ed
Ed
Tue Sep 27 14:21:50 CDT 2005
Guido, you may need to think through *exactly* what you want to make happen
with this. I may be wrong, but it sounds like you want to put all of your
Word, Excel, and Access macros into web pages, with buttons on the pages
linked to your macros. That way, you can have them available to you
wherever you go, on any machine. Or maybe you are hoping to just better
organize your macros.
I can see some problems (besides the obvious security issues of a macro
program on a web server reaching into a client's computer to diddle with
their files!):
-- A web page and a Word file (for example) exist inside two different
applications. Are you sure you can launch a Word application macro in a
Front Page document opened in the Internet Explorer application, and have
the macro find your Word application, Word document, and perform the correct
actions?
-- You may have to recode major parts of your macros, especially if any of
them rely on the ActiveDocument (or equivalent) property. The
ActiveDocument would probably be the Front Page document, not the Word doc.
You would have to set an object to the proper application and to the proper
file, and use that object reference in your code.
What are you wanting to accomplish by doing this? What will be the
improvement to you that would make it worth all the work?
Ed
"Gù" <guidoautelli@alice.it> wrote in message
news:PolZe.12490$kA.651748@news3.tin.it...
> Hallo everybody.
> I have a really big problem: I made many macro in WORD, EXCEL an ACCESS (I
> made quite 100 macros, in OFFICE 2000). Now, to make my work simpler, I
want
> to prepare a web site with the links I need to work, and some commands in
> the pages.
> So: I need to prepare a button that, on click, run my macro. What can I do
> to obtain this?
> Please help me!!!
>
> Guido
>
>