14344 Convert Word Macro to Access Procedure?
Sign Up |  Live StatsLive Stats    Articles 37,301| Comments 176,940| Members 19,397, Newest birinder| Online 440
Home Contact
 (Forgotten?): 
    Sikhism
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




Sikh Philosophy Network » Sikh Philosophy Network » Current News » Information Technology » Convert Word Macro to Access Procedure?

Convert Word Macro to Access Procedure?

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 500 USD, Received: 100 USD (20%)
Please Donate...
     
Related Topics...
Thread Thread Starter Forum Replies Last Post
Mail merge: Word/Access ok but Access/Word is problem Kevryl Information Technology 4 28-Jul-2006 08:33 AM
How can I convert an Access database file into a Word Document? Chris Hicks, Bookbinder Information Technology 2 28-Jul-2006 08:32 AM
Convert a Word Document Phil Stewart Information Technology 1 28-Jul-2006 08:31 AM
Stored procedure/Macro... JOM Information Technology 1 28-Jul-2006 08:14 AM
SQL stored procedure in Access output to Excel wnfisba Information Technology 7 28-Jul-2006 08:08 AM


Tags
convert, word, macro, access, procedure
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 01-Nov-2005, 13:40 PM
Tom Brown's Avatar Tom Brown
Guest
 
Posts: n/a
   
   
Convert Word Macro to Access Procedure?

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
Is it possible to convert a VBA Macro from MS Word into an Access VBA
Procedure? Instead of running the procedure (Macro) from MS Word, I would
like to run it from an Access form with a Command Button. The goal is to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6334-convert-word-macro-to-access-procedure.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6334
extract data from a Word document into an Access table.

For example, the following line gets a compile error

vCity = Source.FormFields("City").result



It tells me "The Method or data member is not found." The .FormFields is
highlighted on the error.



Any help will be appreciated,



Tom






Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 01-Nov-2005, 13:40 PM
Tom Wickerath's Avatar Tom Wickerath
Guest
 
Posts: n/a
   
   
RE: Convert Word Macro to Access Procedure?

  Donate Today!  
Hi Tom,

Yes, this should be possible. Start by writing early bound code so that you
will have intellisense to help you. You'll need to set a reference to the
"Microsoft Word X.XX Object Library", where X.XX represents your version of
Word. Then you'll need to declare an object variable and set it in the
procedure, like this:

Dim objWord As Word.Application
Set objWord = GetObject(, "Word.Application")

(You don't need to name it "objWord"--you can name it whatever you want).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6334

An example of retrieving data from a Word document into an Access table can
be found here:

http://msdn.microsoft.com/library/de...ml/imo1200.asp

I have a copy of the sample database that goes with this article. If you
send me a private e-mail message, with a valid reply-to address, I will send
you this file. My slightly obfuscated e-mail address is shown below. You
should have 18 characters remaining, after removing the indicated letters and
spaces. Whatever you do, please do not post your unaltered e-mail address to
any newsgroup message.


Tom

QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"Tom Brown" wrote:

Is it possible to convert a VBA Macro from MS Word into an Access VBA
Procedure? Instead of running the procedure (Macro) from MS Word, I would
like to run it from an Access form with a Command Button. The goal is to
extract data from a Word document into an Access table.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6334

For example, the following line gets a compile error

vCity = Source.FormFields("City").result



It tells me "The Method or data member is not found." The .FormFields is
highlighted on the error.



Any help will be appreciated,



Tom
Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
Fresno Sikh Who Was...
Today 01:30 AM
0 Replies, 1 Views
Textbooks Spotted...
Today 01:30 AM
1 Replies, 2 Views
Guns of the Nihangs...
Today 01:24 AM
0 Replies, 1 Views
Saudi Woman Makes...
Today 01:01 AM
0 Replies, 1 Views
Of Serpents, Pigs,...
Today 00:55 AM
36 Replies, 854 Views
Do you believe in...
Today 00:28 AM
165 Replies, 3,454 Views
Map shows world's 'most...
Yesterday 23:56 PM
7 Replies, 101 Views
The Great Imp Debate
Yesterday 23:12 PM
31 Replies, 451 Views
Thought of the Moment!
Yesterday 20:55 PM
104 Replies, 4,960 Views
Sikhs making Their...
Yesterday 20:51 PM
0 Replies, 47 Views
Panjabi
Yesterday 11:53 AM
8 Replies, 188 Views
A Sydney [Aust] man who...
By Ishna
Yesterday 11:04 AM
0 Replies, 58 Views
Sikh Spokesman (ਪੰਜਾਬੀ...
Yesterday 10:42 AM
164 Replies, 4,266 Views
BHOOTS (Ghosts) and...
Yesterday 08:20 AM
91 Replies, 13,704 Views
Before He Was Sir...
Yesterday 05:40 AM
6 Replies, 131 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +6.5. The time now is 01:53 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.32819 seconds with 32 queries
0