Results 1 to 5 of 5

Thread: Finding or extracting documentation for VBA procedures such as MSXML

  1. #1
    New Member
    Join Date
    Feb 2016
    Location
    Upstate NY
    Posts
    48

    Default Finding or extracting documentation for VBA procedures such as MSXML

    How does one get or extract procedural definition and associated parameters from a "project" like MSXML 6.0? I am doing some basic web scraping but am only mirroring VBA snippets, rather than really learning. This same question would apply to any project, so generic answers are aok. The work will be done in Excel 2016 on a Win10 home equipped desk computer. I have written several VBA scripts but am still a tyro with lots to learn.

    My goal is to do several scrapings that will aid in tracking my investments, then to develop some aggressive retrievals of county tax records for real estate investing

  2. #2
    Board Regular
    Join Date
    Feb 2012
    Location
    Florida, USA
    Posts
    9,385

    Default Re: Finding or extracting documentation for VBA procedures such as MSXML

    Quote Originally Posted by wornhall View Post
    How does one get or extract procedural definition and associated parameters from a "project" like MSXML 6.0? I am doing some basic web scraping but am only mirroring VBA snippets, rather than really learning. This same question would apply to any project, so generic answers are aok. The work will be done in Excel 2016 on a Win10 home equipped desk computer. I have written several VBA scripts but am still a tyro with lots to learn.

    My goal is to do several scrapings that will aid in tracking my investments, then to develop some aggressive retrievals of county tax records for real estate investing
    If you are referring to the syntax, properties, methods, etc. then most of that can be found in the Excel and VBA help files. To access the VBA help, open the vb editor and click the Question Mark in the blue circle. Don't know how your system will bring it up, but you want to get to 'VBA Language Reference' and you can either pick subject from the listing on the left of the screen or type a topic in the search box and click the search icon or press enter. It might not be so easy for a tyro to use that method, but it is where the details of the VBA code exists. Some topics are better illustrated and explained than others. There are also free tutorials on the web for vba that might be helpful. Just type 'VBA free tutorial' in your browser or search engine and it will bring up several options. You can pick through them for what you consider useful. Other than that, it is Amazon, Barnes and Noble or some other hardcopy source and a lot of reading. Or enroll in some of the classes offered on this site from time to time.
    Using Windows 10, Excel 2013.
    Any code provided by me should be tested on a copy or a mock-up of your file before applying it to your original file. Some actions generated by VBA code cannot be reversed with the undo facility in Excel. To open the VB editor, press Alt + F11. To run code from the Excel window, press Alt + F8. Please do not attempt to learn everything about VBA in one thread, especially from me. See this link for attaching images: Attachments

  3. #3
    New Member
    Join Date
    Feb 2016
    Location
    Upstate NY
    Posts
    48

    Default Re: Finding or extracting documentation for VBA procedures such as MSXML

    Thank you for the fine response. In Excel, the help function refers directly to MSDN on-line which is not very helpful for an addin. What I think is needed is a breakout of the referenced dll, namely MSXML6.dll in this case.

    Opening this library entry in Notebook and "find"ing MSXML about half way down, one will find a couple of tables with entry points for the functions available and a little further down, their descriptions. It is most promising, and there must??? be a way to break out this information.

    How else can one learn all the methods available within an addin?

  4. #4
    Board Regular
    Join Date
    Feb 2012
    Location
    Florida, USA
    Posts
    9,385

    Default Re: Finding or extracting documentation for VBA procedures such as MSXML

    Quote Originally Posted by wornhall View Post
    Thank you for the fine response. In Excel, the help function refers directly to MSDN on-line which is not very helpful for an addin. What I think is needed is a breakout of the referenced dll, namely MSXML6.dll in this case.

    Opening this library entry in Notebook and "find"ing MSXML about half way down, one will find a couple of tables with entry points for the functions available and a little further down, their descriptions. It is most promising, and there must??? be a way to break out this information.

    How else can one learn all the methods available within an addin?
    Looks like you are referring to source code data. I do not believe you are going to find a public reference to that on line. That is generally considered proprietary information and closely controlled by the originator. You might be able to parse it out in the manner you describe, but if I am correct about what you are after, you won't find it by googling.
    Using Windows 10, Excel 2013.
    Any code provided by me should be tested on a copy or a mock-up of your file before applying it to your original file. Some actions generated by VBA code cannot be reversed with the undo facility in Excel. To open the VB editor, press Alt + F11. To run code from the Excel window, press Alt + F8. Please do not attempt to learn everything about VBA in one thread, especially from me. See this link for attaching images: Attachments

  5. #5
    New Member
    Join Date
    Feb 2016
    Location
    Upstate NY
    Posts
    48

    Default Re: Finding or extracting documentation for VBA procedures such as MSXML

    Quote Originally Posted by JLGWhiz View Post
    Looks like you are referring to source code data. I do not believe you are going to find a public reference to that on line. That is generally considered proprietary information and closely controlled by the originator. You might be able to parse it out in the manner you describe, but if I am correct about what you are after, you won't find it by googling.
    Thanks anyhow.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com