guid

  1. T

    Immutable identifier for ListObject

    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...
  2. T

    InternetExplorer Object from Hwnd...

    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...
  3. Jaafar Tribak

    How to Automate a second instance of Excel via the IDispatch Interface .

    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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top