object

  1. B

    Adding vba macro to outlook on runtime

    Hi, I have found some code that allows the user to add a macro to an excel workbook at runtime. Is this possible to do for an outlook object? This method works for dynamically adding a macro to an excel object but I cannot find an equivalent for outlook. <code class="" style="box-sizing...
  2. B

    method value of object metaproperty failed

    I am running a macro that saves a certain cell data to a property in sharepoint metadata. It works great. But, there's always a but, there are times that the string has a comma, then an intentional space at the end. When that is the case, I receive the following error: "method value of object...
  3. M

    Web scraping on Mac

    I'm using the following macro to scrape a DropBox web page for a string and compare it to a stored value within a worksheet to determine if an update for the workbook is available. This all works on Windows but I get an error when I try and dim a HtmlDocument object or use...
  4. R

    Navigate website through VBA

    Hi All, I am trying to doing web scrapping through VBA. Login website is working perfect but m stuck in next step where i need help to choose a right property to navigate. Below is the HTML codes extract via inspect element. and below is my VBA code: Sub xyz() Dim butt As Object Dim objcoll...
  5. F

    Find Computer Serial Number

    What code can I use to find the serial number of my computer? Below is what I have been using but I have discovered it is not the serial number that is on the computer. I now do not know what the number I do get represents. Public Function GetSerialNumber() As String Dim objs As Object Dim Obj...
  6. J

    XML http: Trying to get outertext!

    URL in E1 is: https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1&count=48 I am trying to get the outertext, which should for example return: Tesco British Salted Block Butter 250G↵Write a review↵↵Sorry, this product is currently unavailable↵↵Rest of ↵Block...
  7. J

    Error handling

    Hello, If the VBA below cannot find anything for the particular pull I'd like it to Goto 1: and put a blank/1, can anyone help? Thanks. Public Sub Data_Pull_Products_and_Prices_2() Dim http As Object, html As New HTMLDocument, topics As Object, topics2 As Object, titleElem As Object, topic...
  8. J

    VBA Looping issue

    Hello, I am trying to pull data xml from the web into 2 columns, A and B. With the 2 topics below; topics and topics2, I need to try and pull it one - i.e. column A then B, rather than all of A's and then B. I cannot quite get the code to loop correctly below, any ideas? Thanks. Public Sub...
  9. J

    VBA Xml Loop

    Hello following code works fine for 1 URL, I am trying to adapt so it runs for all the numerical pages it can find from the baseURL, so for instance the 1 up to the max until there is an error, is this possible? Thanks. baseUrl =...
  10. J

    Parsing HTML

    Hello, Trying to pull all the names of the items and then the price on this page, https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1 e.g. Tesco British Salted Block Butter 250G £1.50 Tesco Gala Apple Minimum 5 Pack £1.60 But the code fails on this line...
  11. RavosJ

    Send Attachment via E-mail (extra)

    Hi all, I was able to create a macro that allows me, with the push of a button, to send he Excel file to a certain address. Sub Mod_SendWorkbook() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0)...
  12. J

    VBA, IE getelements, change to xml http

    How would I adapt the following code please so I could get it into a XMLHTTP web pull instead? e.g. Private Function getprices(ByVal URL As String) As Variant Dim source As Object Dim Http As New XMLHTTP60, Html As New HTMLDocument Dim ret(1 To 1) As String Dim elem As Object With Http...
  13. J

    How do I ignore hidden files?

    Hi, I currently have the below code to pull a list from a file path every time the worksheet is activated. Sub worksheet_Activate() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder =...
  14. C

    Error in Loading DLL while using late binding (Outlook)

    tl;dr - Converted from early to late binding to email a report using Outlook, now getting "Error in Loading DLL" Good morning! I developed a tool for our production operations that automatically generates an email when a report is run. It was working fine for me using early binding, but then I...
  15. V

    Copying and Pasting Images/Objects to another workbook.

    Hi All, I have been lurking around for an answer but haven't been able to find one for my issue. I am making a macro in Excel that will compile files into a larger file. These files to be compiled also have images in specific boxes that I haven't been able to get to come over. I would select...
  16. E

    Object Qualifies

    I am new to VBA. I am trying to change the background color of a text box based on another cell value. I am getting a Runtime error 424 Object required error. Here is my code - what am I doing wrong? Public Sub TextBoxColor() If Worksheets("Sheet1").Range("E1").Value = "Name" Then...
  17. Z

    How do i identify an open powerpoint presentation in excel?

    I'm trying to write a macro that automatically uploads a chart to powerpoint but it currently makes a new presentation everytime I try to do it. I got the macro from the internet and tried to modify it but nothing I try seems to be working Here's the code(not my code) below Sub ChartX2P()...
  18. C

    IE Automation in VBA

    Afternoon, I am trying to automate some IE navigation. I am running into an issue when trying to populate a field. The object will allow for text entry - but i cannot seem to find a way to fire/trigger an event to populate the dropdown list that will then allow me to select from their...
  19. B

    Windows API to check if currently selected object is of the outlook data type

    Is there a windows api function to check the data type of the last item focused on or clicked down on (this includes a dragged object) is of the outlook object type? For instance, if you clicked on your desktop icon to drag it highlights to show its been selected and when you select an email in...
  20. N

    Change sheetname, file name and range by cell value

    Public Sub DATA_noibang()Dim cn As Object, rs As Object, i As Byte, lr As Long, fso As Object Set cn = CreateObject("adodb.connection") Set fso = CreateObject("Scripting.FileSystemObject") Sheets("noibang").AutoFilterMode = False...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top