VBA and Javascript

  • Thread starter Thread starter QB
  • Start date Start date
Q

QB

Is it possible to execute javascript through ms access? Or execute and html
page,hidden to the user, that in turn execute javascript and then closes?

I need to perform an action, that sadly I have been unable to get an answer
to using standard vba, but have found a way to do it using javascript, hence
the question.

Thank you for your input!

QB
 
What are you trying to do? If you can do it in Javascript, I'd be extremely
surprised if you cannot do it with VBA.
Your approach would be very inadvisable.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
QB said:
No one has been able to propose a solution to my original post (see below)
using vba thus far, and I have come across some possible solutions using
javascript that I would like to explore. Obviously, if there was a vba
native method I would far prefer it!

http://www.microsoft.com/office/com...&p=1&tid=ac17aeee-b1ad-4b86-9ace-f31df370171d
Click to expand...

If Acrobat reader is COM-compliant, chances are you can do what you want in
VBA. However, I do not know of good resources on programmatically working
with Acrobat Reader via VBA. I'd start with the Adobe site, but my guess is
that you already looked there.

I seem to recall, vaguely, discussions of a way to run vbscript from Access
so it could be used as a scripting language (because you'd need a very
widely-distributed commercial app to justify the cost of licensing VBA
itself), but for the life of me, I can't focus my memory any more than that.
Perhaps some searching on that combination, and/or Windows Scripting Host
might find the data you need.

Of course, with luck, you'll turn up someone who has the answer in one of
these newsgroups. Did you, by the way, search the archives of the USENET
newsgroup comp.databases.ms-access at Google Groups... if I were looking for
that old discussion, it's one of the places I'd search.

Larry Linson
Microsoft Office Access MVP
 
I seem to recall reading somewhere that you could use:

Application.FollowHyperlink ScriptFile.js

I've never tried this, but it looks reasonable.

HTH,
Alex.
 
Back
Top