Hello. As you'll see very quickly I am not a web programmer. One of my
co-workers uses front page to create an intraweb site for the company. I
wrote some code in vba that will open a word document and print specific
pages from it. However, I mistakenly assumed that it would run like other
vba modules (excel, word, etc.) and allow me to place a button on the page
that will kick off my sub-routines. If it can do this, I would greatly
appreciate someone telling me what I am missing. If not... how do I go
about running macros in vba from a web page? Maybe I'm looking at it
incorrectly. Any help you can offer is greatly appreciated.

Steven Craig Basham

Re: Running VBA from a .htm page? by Kevin

Kevin
Wed Apr 20 16:19:21 CDT 2005

Hi Steven,

No, it wouldn't work. VBA is a language for extending existing applications.
A web page is not an application. A web page is a text document that is
returned to the browser as a result of a Request to a web server or a local
HTML file.

What you're talking about is not something a web page can do. It isn't
something a web server can do. It is something only a custom application can
do. In your case, you would need to write an ActiveX control (in VB, NOT
VBA) and embed that in a web page.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.

"Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote in
message news:u$UuUseRFHA.252@TK2MSFTNGP12.phx.gbl...
> Hello. As you'll see very quickly I am not a web programmer. One of my
> co-workers uses front page to create an intraweb site for the company. I
> wrote some code in vba that will open a word document and print specific
> pages from it. However, I mistakenly assumed that it would run like other
> vba modules (excel, word, etc.) and allow me to place a button on the page
> that will kick off my sub-routines. If it can do this, I would greatly
> appreciate someone telling me what I am missing. If not... how do I go
> about running macros in vba from a web page? Maybe I'm looking at it
> incorrectly. Any help you can offer is greatly appreciated.
>
> Steven Craig Basham
>
>



Re: Running VBA from a .htm page? by Steven

Steven
Wed Apr 20 16:26:31 CDT 2005

Thank you for your reply Kevin. I will look into another way to accomplish
my mission. :)

"Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
news:ubAFg6eRFHA.996@TK2MSFTNGP09.phx.gbl...
> Hi Steven,
>
> No, it wouldn't work. VBA is a language for extending existing
applications.
> A web page is not an application. A web page is a text document that is
> returned to the browser as a result of a Request to a web server or a
local
> HTML file.
>
> What you're talking about is not something a web page can do. It isn't
> something a web server can do. It is something only a custom application
can
> do. In your case, you would need to write an ActiveX control (in VB, NOT
> VBA) and embed that in a web page.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> .Net Developer
> What You Seek Is What You Get.
>
> "Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote
in
> message news:u$UuUseRFHA.252@TK2MSFTNGP12.phx.gbl...
> > Hello. As you'll see very quickly I am not a web programmer. One of my
> > co-workers uses front page to create an intraweb site for the company.
I
> > wrote some code in vba that will open a word document and print specific
> > pages from it. However, I mistakenly assumed that it would run like
other
> > vba modules (excel, word, etc.) and allow me to place a button on the
page
> > that will kick off my sub-routines. If it can do this, I would greatly
> > appreciate someone telling me what I am missing. If not... how do I go
> > about running macros in vba from a web page? Maybe I'm looking at it
> > incorrectly. Any help you can offer is greatly appreciated.
> >
> > Steven Craig Basham
> >
> >
>
>



Re: Running VBA from a .htm page? by Steven

Steven
Thu Apr 21 15:45:06 CDT 2005

Kevin,
Hopefully you can point me in the right direction. I've created the
activex control I needed and used microsoft's control panel to embed it in
my webpage. It worked beautifully!!... until I tried to run the web page
from another machine. Am I correct in thinking that I will have to register
the control in every machine prior to the web page viewing? If so, it
didn't look simple... suggestions?

TIA,
Steve

"Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
news:ubAFg6eRFHA.996@TK2MSFTNGP09.phx.gbl...
> Hi Steven,
>
> No, it wouldn't work. VBA is a language for extending existing
applications.
> A web page is not an application. A web page is a text document that is
> returned to the browser as a result of a Request to a web server or a
local
> HTML file.
>
> What you're talking about is not something a web page can do. It isn't
> something a web server can do. It is something only a custom application
can
> do. In your case, you would need to write an ActiveX control (in VB, NOT
> VBA) and embed that in a web page.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> .Net Developer
> What You Seek Is What You Get.
>
> "Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote
in
> message news:u$UuUseRFHA.252@TK2MSFTNGP12.phx.gbl...
> > Hello. As you'll see very quickly I am not a web programmer. One of my
> > co-workers uses front page to create an intraweb site for the company.
I
> > wrote some code in vba that will open a word document and print specific
> > pages from it. However, I mistakenly assumed that it would run like
other
> > vba modules (excel, word, etc.) and allow me to place a button on the
page
> > that will kick off my sub-routines. If it can do this, I would greatly
> > appreciate someone telling me what I am missing. If not... how do I go
> > about running macros in vba from a web page? Maybe I'm looking at it
> > incorrectly. Any help you can offer is greatly appreciated.
> >
> > Steven Craig Basham
> >
> >
>
>



Re: Running VBA from a .htm page? by Kevin

Kevin
Fri Apr 22 07:06:36 CDT 2005

Hi Steven,

First, congratulations! Nice work.

I believe the following MSDN article , and the related sections you'll find
with it, will answer your questions. If you still need help, come on back!

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.

"Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote in
message news:ui78BMrRFHA.3140@tk2msftngp13.phx.gbl...
> Kevin,
> Hopefully you can point me in the right direction. I've created the
> activex control I needed and used microsoft's control panel to embed it in
> my webpage. It worked beautifully!!... until I tried to run the web page
> from another machine. Am I correct in thinking that I will have to
> register
> the control in every machine prior to the web page viewing? If so, it
> didn't look simple... suggestions?
>
> TIA,
> Steve
>
> "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
> news:ubAFg6eRFHA.996@TK2MSFTNGP09.phx.gbl...
>> Hi Steven,
>>
>> No, it wouldn't work. VBA is a language for extending existing
> applications.
>> A web page is not an application. A web page is a text document that is
>> returned to the browser as a result of a Request to a web server or a
> local
>> HTML file.
>>
>> What you're talking about is not something a web page can do. It isn't
>> something a web server can do. It is something only a custom application
> can
>> do. In your case, you would need to write an ActiveX control (in VB, NOT
>> VBA) and embed that in a web page.
>>
>> --
>> HTH,
>>
>> Kevin Spencer
>> Microsoft MVP
>> .Net Developer
>> What You Seek Is What You Get.
>>
>> "Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote
> in
>> message news:u$UuUseRFHA.252@TK2MSFTNGP12.phx.gbl...
>> > Hello. As you'll see very quickly I am not a web programmer. One of
>> > my
>> > co-workers uses front page to create an intraweb site for the company.
> I
>> > wrote some code in vba that will open a word document and print
>> > specific
>> > pages from it. However, I mistakenly assumed that it would run like
> other
>> > vba modules (excel, word, etc.) and allow me to place a button on the
> page
>> > that will kick off my sub-routines. If it can do this, I would greatly
>> > appreciate someone telling me what I am missing. If not... how do I go
>> > about running macros in vba from a web page? Maybe I'm looking at it
>> > incorrectly. Any help you can offer is greatly appreciated.
>> >
>> > Steven Craig Basham
>> >
>> >
>>
>>
>
>



Re: Running VBA from a .htm page? by Steven

Steven
Fri Apr 22 07:37:43 CDT 2005

? I must've missed something: I can't find the following MSDN article you
mention. Would you mind trying again for me?

Again, thank you for all of your help!

Steven Craig Basham

"Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
news:utfz8OzRFHA.3944@TK2MSFTNGP10.phx.gbl...
> Hi Steven,
>
> First, congratulations! Nice work.
>
> I believe the following MSDN article , and the related sections you'll
find
> with it, will answer your questions. If you still need help, come on back!
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> .Net Developer
> What You Seek Is What You Get.
>
> "Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote
in
> message news:ui78BMrRFHA.3140@tk2msftngp13.phx.gbl...
> > Kevin,
> > Hopefully you can point me in the right direction. I've created the
> > activex control I needed and used microsoft's control panel to embed it
in
> > my webpage. It worked beautifully!!... until I tried to run the web
page
> > from another machine. Am I correct in thinking that I will have to
> > register
> > the control in every machine prior to the web page viewing? If so, it
> > didn't look simple... suggestions?
> >
> > TIA,
> > Steve
> >
> > "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
> > news:ubAFg6eRFHA.996@TK2MSFTNGP09.phx.gbl...
> >> Hi Steven,
> >>
> >> No, it wouldn't work. VBA is a language for extending existing
> > applications.
> >> A web page is not an application. A web page is a text document that is
> >> returned to the browser as a result of a Request to a web server or a
> > local
> >> HTML file.
> >>
> >> What you're talking about is not something a web page can do. It isn't
> >> something a web server can do. It is something only a custom
application
> > can
> >> do. In your case, you would need to write an ActiveX control (in VB,
NOT
> >> VBA) and embed that in a web page.
> >>
> >> --
> >> HTH,
> >>
> >> Kevin Spencer
> >> Microsoft MVP
> >> .Net Developer
> >> What You Seek Is What You Get.
> >>
> >> "Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com>
wrote
> > in
> >> message news:u$UuUseRFHA.252@TK2MSFTNGP12.phx.gbl...
> >> > Hello. As you'll see very quickly I am not a web programmer. One of
> >> > my
> >> > co-workers uses front page to create an intraweb site for the
company.
> > I
> >> > wrote some code in vba that will open a word document and print
> >> > specific
> >> > pages from it. However, I mistakenly assumed that it would run like
> > other
> >> > vba modules (excel, word, etc.) and allow me to place a button on the
> > page
> >> > that will kick off my sub-routines. If it can do this, I would
greatly
> >> > appreciate someone telling me what I am missing. If not... how do I
go
> >> > about running macros in vba from a web page? Maybe I'm looking at it
> >> > incorrectly. Any help you can offer is greatly appreciated.
> >> >
> >> > Steven Craig Basham
> >> >
> >> >
> >>
> >>
> >
> >
>
>



Re: Running VBA from a .htm page? by Kevin

Kevin
Fri Apr 22 09:02:07 CDT 2005

Oh my goodness! I forgot to post the link!

http://msdn.microsoft.com/library/default.asp?url=/workshop/components/activex/tutorial.asp

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.

"Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote in
message news:eHwhVgzRFHA.3356@TK2MSFTNGP12.phx.gbl...
>? I must've missed something: I can't find the following MSDN article you
> mention. Would you mind trying again for me?
>
> Again, thank you for all of your help!
>
> Steven Craig Basham
>
> "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
> news:utfz8OzRFHA.3944@TK2MSFTNGP10.phx.gbl...
>> Hi Steven,
>>
>> First, congratulations! Nice work.
>>
>> I believe the following MSDN article , and the related sections you'll
> find
>> with it, will answer your questions. If you still need help, come on
>> back!
>>
>> --
>> HTH,
>>
>> Kevin Spencer
>> Microsoft MVP
>> .Net Developer
>> What You Seek Is What You Get.
>>
>> "Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com> wrote
> in
>> message news:ui78BMrRFHA.3140@tk2msftngp13.phx.gbl...
>> > Kevin,
>> > Hopefully you can point me in the right direction. I've created the
>> > activex control I needed and used microsoft's control panel to embed it
> in
>> > my webpage. It worked beautifully!!... until I tried to run the web
> page
>> > from another machine. Am I correct in thinking that I will have to
>> > register
>> > the control in every machine prior to the web page viewing? If so, it
>> > didn't look simple... suggestions?
>> >
>> > TIA,
>> > Steve
>> >
>> > "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
>> > news:ubAFg6eRFHA.996@TK2MSFTNGP09.phx.gbl...
>> >> Hi Steven,
>> >>
>> >> No, it wouldn't work. VBA is a language for extending existing
>> > applications.
>> >> A web page is not an application. A web page is a text document that
>> >> is
>> >> returned to the browser as a result of a Request to a web server or a
>> > local
>> >> HTML file.
>> >>
>> >> What you're talking about is not something a web page can do. It isn't
>> >> something a web server can do. It is something only a custom
> application
>> > can
>> >> do. In your case, you would need to write an ActiveX control (in VB,
> NOT
>> >> VBA) and embed that in a web page.
>> >>
>> >> --
>> >> HTH,
>> >>
>> >> Kevin Spencer
>> >> Microsoft MVP
>> >> .Net Developer
>> >> What You Seek Is What You Get.
>> >>
>> >> "Steven Craig Basham" <sbasham@REMOVETHISFIRSTgilbraltardesign.com>
> wrote
>> > in
>> >> message news:u$UuUseRFHA.252@TK2MSFTNGP12.phx.gbl...
>> >> > Hello. As you'll see very quickly I am not a web programmer. One
>> >> > of
>> >> > my
>> >> > co-workers uses front page to create an intraweb site for the
> company.
>> > I
>> >> > wrote some code in vba that will open a word document and print
>> >> > specific
>> >> > pages from it. However, I mistakenly assumed that it would run like
>> > other
>> >> > vba modules (excel, word, etc.) and allow me to place a button on
>> >> > the
>> > page
>> >> > that will kick off my sub-routines. If it can do this, I would
> greatly
>> >> > appreciate someone telling me what I am missing. If not... how do I
> go
>> >> > about running macros in vba from a web page? Maybe I'm looking at
>> >> > it
>> >> > incorrectly. Any help you can offer is greatly appreciated.
>> >> >
>> >> > Steven Craig Basham
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>