Macro from WORD to FRONT PAGE

G

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
 
J

Jezebel

Add a button to any toolbar (or create your own) and attach the macro to it.
How can you write 100 macros without reading the Help file?
 
G

you didn't understand. i need to put the button in the web page, and not in
the toolbar!!!

so, do i need to write the correct code in the html section?
 
J

Jezebel

Gù said:
you didn't understand. i need to put the button in the web page, and not
in the toolbar!!!

That's not the question you asked.
so, do i need to write the correct code in the html section?

Well, hey. Derrr of the century. Sheesh. You were thinking or writing the
INcorrect code?
 
E

Edward Thrashcort

If I understand you correctly, you want a button on a HTML WEB page to run a
macro in Word?

No-way-Jose! That would be an unacceptable security breach since a Word
macro can interface directly with the OS.

(Having said that I bet MS have found a way to (viz left a door open to)
allow such a security blunder!)

Eddie
 
E

Ed

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top