collection

  1. A

    Nested Dictionary?

    I have a set of data: Domains; Users; Machines I have a task that requires me to check to see if a domain user has logged into a particular machine in the past. There are unlimited domains, an undefined number of users, and the machine name could potentially change at any time. The tool has to...
  2. C

    Copy multiple rows

    Im looping a range of cells in column A. If it meets a certain criteria need to copy that whole row. Instead of individually copy and pasting the row everytime i loop when the if statement is true i want to keep adding that row to an array, collection or whatever is a better solution and once...
  3. L

    thisworkbook and activebook access without usign workbooks collection

    Hi The code below is going to run no problem to my surprise. It will also run without typing Application. Now I am confused. I know to access a workbook I need to go through the workbook collection like the following msgbox(application.workbooks(1).name) So why the code below is OK? Thank...
  4. T

    Inspecting elements of a collection

    This code checks the version of Excel installed: Option Explicit Sub Test() Dim abc As Collection Set abc = New Collection abc.Add Module2.Version abc.Item (0) ' FAILS HERE End Sub Option Explicit Public Function Version() As Collection...
  5. B

    Automation Error when building collection

    Dear Excel Experts, I have a simple piece of VBA code with some (messy) error handling that builds a collection by constructing a string and seeing if it exists in a larger collection. This code generates an application execution error on the second pass through the for next loop. Private...
  6. A

    No event is triggered upon pressing tab

    Hello All, I have one userform on which I have a multi pahe. Each tab of multi page has 4 text boxes in column format . Each column having two text boxes. At the bottom of the user form, there are three command buttons (Next Page, Cancel and Close). All controls are added to a collection and...
  7. J

    Excel VBA events only working on last element of Collection

    Hello Everyone, I have a Multipage that is generating new pages with various CheckBox, ComboBox, TextBox and Button objects. Currently I'm just focusing on the CheckBox objects but the same code will applied for every different objects. I know that all 5 CheckBox objects are added to the...
  8. N

    how to get values in a collection of arrays in VBA

    Hi , can anyone help me with below query. i have a collection of arrays. and i need to read the values. eg: Dim resColl As New Collection resColl.Add Array(key, Key3("UserName"), Key3("Password")) in above add method i added arrays with 3 elements. and after adding i need to read the...
  9. S

    Opening PDF from VBA

    I am trying to use the following code to open a pdf file from a folder, but I keep getting the "File not found" error. Shell "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Adobe Acrobat DC.exe " & FullPath & """, vbMinimizedFocus" Is there something I am missing? Below if the whole...
  10. M

    Collection Item Attribute Change

    Hi, as I am new on this Forum, I don't know if my question has already been posted. If yes, please just show me which post. I have a collection with n classes (Batch) and I like to change attributes of the items. These attributes are strings like (Name, Adress, Phone, etc...) A create a GUI...
  11. S

    CodeName value not available on imported sheets

    Hi, 1: I have an Access DB that I use to copy Worksheets X, Y, Z from WorkBook 1 to WorkBook 2 (WorkBook 2 already has Sheets (A, B & C). objWBSource.Worksheets("MySheetName").Copy Before:=objWBDest.Sheets(1) 2: I save and close both WorkBooks. 3: WorkBook 2 then has sheets A, B & C and the...
  12. 1

    Unique to clipboard

    I did find a most beautiful macro somewhere in the net making it possible for me to just make a selection and it would make the unique values in the selection go to the clipboard sorted It worked fine in Excel 2010 but stopped working in Excel 2014. I get no sensible output , just ￿￿ Could...
  13. E

    Html table scrape with vba

    Hi, I am new in data scrape via VBA. I want to get my order history over amazon. I can get all the info from html table with the code below. However, this code gives td elements in a single and it is hard to parse it again. I attached the html code of web page and highlight the info I want...
  14. N

    Same Array/msgbox to display different messages

    Currently my array brings up three different msgboxes, as shown with the Functions 'Expired', 'Expiring', and 'NoTraining'. The array msgboxes display information based on whether a date is Expired (older than current date), Expiring (within 31 days), and is a date is missing (NoTraining). No...
  15. N

    Same Array/msgbox to display different messages

    Currently my array brings up three different msgboxes, as shown with the Functions 'Expired', 'Expiring', and 'NoTraining'. The array msgboxes display information based on whether a date is Expired (older than current date), Expiring (within 31 days), and is a date is missing (NoTraining). No...
  16. S

    Removing Elements from Collection

    I am trying to remove empty elements from a Collection. Here is the code I have so far. Sub T() Dim i As Integer Dim Altered As New Collection Altered.Add Range(Cells(12, 2), Cells(19, 12)).FormulaR1C1 For i = 1 To Altered.Count If Altered.Item(i) = "" Then Altered.Remove i...
  17. C

    Collection, class, printing

    I have a collection with a custom class and I don't know how to print the items in the collection. Can someone help me? The collection = datacollection. The class = bobjclass class variables = country name, Amount, Account, Account name.
  18. K

    Use collection to store class objects

    Hello I want to use a collection that contains different car objects. I'm familiar to do this in Java but I don't find the solution in VBA. I want to create a class car where I can create my car object with contains the following parameters make model year therefore I have to make a class...
  19. M

    Tricky AutoFilter VBA Question for the VBA Gurus

    Hopefully some Excel VBA guru can help me on this :-) I need a solution for the case below that I plan on using for an application I'm developing: Case: A sheet can have an Autofiltered Range and many Autofiltered Tables(ListObjects). Requirement: I need VBA code which can identify these...
  20. C

    Auto complete with source sheet

    I have multiple links between spreadsheets, one in particular uses a data validation drop filter menu which when changed from one week to another, it should update the information it gathers, which it does, provided I have the source sheet open. Is there a way around this, so that I don't need...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top