Results 1 to 16 of 16

Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function

Threaded View

Doc.AElstein Dictionary or... 07-12-2016, 04:48 AM
xlnitwit Re: Dictionary or... 07-12-2016, 05:49 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:37 AM
xlnitwit Re: Dictionary or... 07-12-2016, 05:58 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:38 AM
xlnitwit Re: Dictionary or... 07-12-2016, 07:54 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 08:00 AM
xlnitwit Re: Dictionary or... 07-12-2016, 06:01 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:39 AM
xlnitwit Re: Dictionary or... 07-12-2016, 06:06 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:39 AM
xlnitwit Re: Dictionary or... 07-12-2016, 07:58 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 08:15 AM
xlnitwit Re: Dictionary or... 07-12-2016, 08:02 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 08:28 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:49 AM
  1. #11
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Func

    Quote Originally Posted by xlnitwit View Post
    .....
    If your function returns a specific object type, there is no benefit to late binding your variable. You may as well avail yourself of the benefits of early binding. .
    Thanks,
    I understand generally, I think, the advantages and disadvantages of Late and Early binding. I allways use Early Binding myself.
    I tend to use Late Binding mostly just when I give Codes to OPs. ( The OPs I am capable of helping know often even less than me... which is saying something!, - so trying to explain to them about adding a library refference can be problamatic ( But I allways include the Early Binding equivalent with explanations 'commented out.....) )

    _.............................


    Quote Originally Posted by xlnitwit View Post
    ........ If, on the other hand, the function returns a generic object, you would have to consider why it does so before you can determine whether to late or early bind the receiving variable.
    _....
    _..........I only have a vague idea about what you are saying here. I have seen in the practice that only one or the other works sometimes. But i am getting out of my depth ( I am not a Programmer, BTW, - I know virtually nothing about Computing and am just learning to help use it in a personal project )

    I am afraid this is foreign languuage to me ......"....the function returns a generic object...."......
    If you had time to translate that into Layman's terms I would be greatful...... but that is not too important -- I may start getting out of my depth and drown... lol

    _...................................




    Thanks Again
    Last edited by Doc.AElstein; 07-12-2016 at 07:48 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scripting dictionary help
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2016, 09:32 PM
  2. [SOLVED] VBA Scripting.Dictionary Code Late Binding Error
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-20-2015, 03:06 AM
  3. Scripting dictionary help
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-14-2014, 09:51 AM
  4. need help with scripting dictionary
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 10-04-2014, 04:33 PM
  5. [SOLVED] Using Dictionary in VBA scripting
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-04-2014, 02:54 PM
  6. Scripting Dictionary
    By Tendla in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2013, 05:41 AM
  7. [SOLVED] Scripting Dictionary help
    By williams485 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-13-2012, 08:22 AM

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