Posts by Kyle123

    Re: Adding a collection to a class object

    It depends how far you want to go into this, the simplest method is simply to expose the collection on the parent class. The calling code then deals with the inserting.

    [color=blue]Private[/color] pColWeeksTasks              [color=blue]As[/color] [color=blue]Collection[/color]
    [color=blue]Public[/color] [color=blue]Property[/color] [color=blue]Get[/color] [color=darkcyan]ColWeeksTasks[/color]() [color=blue]As[/color] [color=blue]Collection[/color]: [color=blue]Set[/color] [color=darkcyan]ColWeeksTasks[/color] = pColWeeksTasks: [color=blue]End[/color] [color=blue]Property[/color]

    If you want to have the Parent class deal with adding children then you're probably looking towards a custom collection class, have a look here:…/custom-collection-class/

    Re: Excel Macro that utilizes's API

    MD5 hashing is easiest using the .Net objects, this creates the same output as the PHP MD5

    Re: Excel Macro that utilizes's API

    This is perfectly possible, if a little bit of a pain in the arse - sending and receiving data to a website is very straightforward and since the website returns xml, it's very easy to parse. Have a look at the MSXML2 classes, they will handle both sending and parsing. The bit that's a pain in the arse is the format that you need to send your data in, it expects JSON formatted strings, that are url encoded. There is nothing in Excel that is going to do this for you, but the JSON is pretty straightforward - so you should be able to write functions to build it.

    I obviously can't check the below, but adding would look something like (obv with no error handling):

    As far as I can see, the biggest pin will be generating the api key - Excel doesn't have any means of creating an MD5 hah, so you have to get a bit creative ;)

    Re: Completely Redesign the Microsoft Excel/Access interface forAutomated Reporting

    That doesn't look like Excel or Access to me, I would say that it's a windows application that possibly provides add-ins to Excel and Access. The biggest giveaway that this is the case is this from the faq:


    Do I need to have Excel installed?
    No, you do not need to have Excel installed to review the results. However, you will need Excel if you wish to export graphs or tables.

    So your questions largely becomes moot, since office isn't used to produce any of the interface graphs, charts and the suchlike are not bound by the restrictions of Excel or Access.

    So in summary, to produce an application like that, then yes, you would need to learn a new programming language, to have it look like that, it would need to be within the Microsoft .Net framework so C++, C#, VB.NET, F# etc. The advantages of these languages are that they are infinitely faster than VBA and give you much more control and free you from the limits of office. To produce something similar to the application you linked to, would require a huge amount of work, probably with multiple programmers working on different aspects of it - it's not a simple thing to accomplish. Things like pivot tables are extremely complex and for larger datasets, you would probably be better looking at other underlying technologies OLAP etc, working within the Excel/Access environment you take a lot of things for granted, MS has put a huge amount of work into making tools like pivot tables and you'd need to design those sort of tools again - which would be no small task in itself let alone just as an aspect of an application. (though a quick google of windows forms pivot table turn up a lot of controls that you could add to your application - they ain't cheap though)

    The reason that commercial data analysis tools are so expensive are down to the amount of work that has gone into creating the product. So, this probably isn't the ideal starter application for learning a new language.

    Re: SQL statement in .sql file through VBA

    You are almost there, you've got past there and gone too far ;)

    Re: Bowen and Groves M1 ERP software & communciation with Excel via VBA

    lol it's probably worth asking your vendor what options you've got - I can guarantee that you won't be the only person to ask. I'd be amazed if there's no way of pulling custom data out of it - most ERP systems need to integrate to other systems so this is pretty much a fundamental requirement.

    M1:Object:PO:mad:xxxxx is interesting though, in what context would you use that?

    Re: Bowen and Groves M1 ERP software & communciation with Excel via VBA

    It might be. When we've looked at ERP systems before, the vendors/developers have always either offered direct access to the database or a webservice if hosted remotely. They also usually offer the db schema to allow you to write custom sql and query whatever you like.

    It might be worth asking your vendor what options they have, custom queries are pretty standard in software of this type so I'd be surprised if they don't offer some way of extracting data.

    Re: Fetching data from multiple URL

    Why on earth would you want the data as per the unformatted tab?

    I've told you how to do it as a one stage operation, why would you want to add a second stage "sort and filter"?