+ Reply to Thread
Results 1 to 4 of 4

predective text in vba

  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    predective text in vba

    Hi All

    I am using a vba code to open a word document. I have declared a variable as an object and using a with statement to do few actions
    but i dont get the prompt /predective test. is there a way that i can know what all actions that i can do with in that with statement with that object

    Please Login or Register  to view this content.
    Last edited by grkchakri; 09-05-2020 at 12:09 PM. Reason: Typo error
    Never confuse a single defeat to the final defeat.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: predective text in vba

    You need to use early binding to get Intellisense. Set a reference to Word and declare Word objects as ... Word objects:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Re: predective text in vba

    Thank you very much Shg. Learned a new point today. very helpful also understood this will work only if the MSword is checked in our available references.

    Also there are concepts such as early binding and late binding.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: predective text in vba

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find specific text within text and result dependent text in specified column
    By Eftychia in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2019, 08:39 AM
  2. Replies: 1
    Last Post: 12-17-2015, 03:35 AM
  3. [SOLVED] Need to Mod Code on red text, I have VBA to distinguish Paid(Black Text) Unpaid(Red Text)
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2014, 07:55 PM
  4. Replies: 0
    Last Post: 04-22-2013, 12:13 PM
  5. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM
  6. [SOLVED] Use .text from previous text box in form to prefill text in second text box
    By chromachem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2012, 10:04 PM
  7. EXCEL predective list use
    By edward1975 in forum Excel General
    Replies: 1
    Last Post: 08-26-2006, 03:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1