guid

Here is the VBA script I wrote to add a new table row at top of table and automatically fill in the ID column by running a macro only in that cell. The macro works fine on its own but I cannot get it to work here. The idea is that a new GUID is auto entered into the ID column of my new row...

Is there any way to get an immutable identifier for a ListObject? A ListObject has a Name and Index property and belongs to a parent worksheet, but suppose I have a ListObject called 'Table1' and then I delete that table and then add a new ListObject also called 'Table1' that also has Index=1...

Hi All, I'm aware a number of people have asked this around the internet, and that the accepted solution in general uses the SHDocVw.ShellWindows collection. However, this doesn't work properly for me ("Out of memory error" when constructing the class, probably I'm working on a VM which doesn't...

Hi all, I've been reading on COM and how to connect to automation servers and query their Properties and Methods. As far as I know, this is done via the IDispatch Interface through which the Server application exposes its Properties and Methods. This way of handling automation is obviously...