object

Hi I have the below code that sends an email if tow conditions are met. I have two questions: Sub email() Dim i As Long, lr As Long, scdata As String, myolapp As Object, myitem As Object lr = Range("A" & Rows.Count).End(xlUp).Row scdata = "" For i = 19 To lr Step 1 If Cells(i, 21) <> 0 And...

I am looking to have some code to import the 2 most recent files in a folder. With the way my code is currently set up it writes every filepath in the folder. I am looking to only write the filepaths of the 2 most recent files placed in the folder. I have placed the code I am looking to modify...

I´m trying to scrape a page for a specific table. there´s three tables available but I only get the first table returned. Url: https://www.dhl.dk/exp-da/express/shipping/forsendelsesraadgivning/express_olietillaeg.html I can get the details for the first table. This is also expanded by...

With help from Stackoverflow I managed to get a working solution for getting Google Maps XML data, parsing it and inputting to Excel cells. However my next intention get it working for several requests when there are 5 different locations to be analyzed and data from each XML should be inputted...

Hello I am new of VBA. I can generate the pdf with new name every time, however i am not able to attached latest generated file in email. it is giving me me error " Path does not exist, verify the path in correct." here is the code. please help me expert Sub sendReminderMail() ChDir...

I am having trouble writing a code to recognize if a number is odd or not and then determining what to do from there... It keeps pooping up with an "object required" error. Please let me know how I can fix it, or if you have ever come across this problem. Here is my code STNDRD=17 If STNDRDR...

Greetings, I have a large application developed in Excel that integrates to a small extent with MS Word. I have a VBA macro that creates a Word object and then copies varies elements from the Excel workbook to the Word document. For this VBA macro to function correctly, there must be...

Hi All, Im trying to connect a webpage using a code which i got from a website. When I tried with the default URL available in the code it worked perfectly. I changed the URL to the URL which i need to open and i get the following error "Automation error The object invoked has disconnected...

I'm attempting to use HTTP requests using https://codingislove.com/parse-html-in-excel-vba/ as a guide in order to bypass having to use internet explorer. When I use the following macro it doesn't assign T_Object_S to do anything and skips over the for loop. Desired url...

I was performing some edits today ... creating a new macro for a worksheet to run when that sheet is activated. Strange thing occurred ... I noticed that a graphic object on that sheet that had an assigned macro no longer functioned. I right clicked on the graphic object and noticed that there...

Hi guys! I'm not sure if the excelforum website is also part of this forum or not, but I posted a question there and I'm gonna post it here as well because I'm a little short on time. Thanks for any help you guys can give. I'm not great with VBA but I found this article that can help quite a...

Hi goodafternoon, I have thecode below where I am trying to add another line after the Comments which iswith a checkbox. I want to add ‘ Job Type’ as a heading and the ComboBox6 Data if the Checkbox1 isclicked, can you help please? [HTML] Private SubCommandButton2_Click() If...

Hi, How can this code be modify just to open the file and not open a new workbook too. When I click in the macro open the file in the path but also open a blank sheet. here is the code: Public Sub OpenVendorMappingAccountsTracking() Dim File$ Dim Xl As Object ' Excel.Application Dim Wb...

Hi, I am trying to apply custom data labels to my chart from a series. This is the relevant section of my code. ActiveChart.FullSeriesCollection(2).Select ActiveChart.SetElement (msoElementDataLabelCallout) ActiveChart.FullSeriesCollection(2).DataLabels.Select...

Hi Everyone. Appreciate if you can help me before I go insane. I have some started some code where I am making a search Bing (I had trouble finding google headers) search bing using a string (I have code which splits it apart and I have some formulas to get the url) Find all h2 Headings...

Hi For the first part my code works fine, it does what it is meant to do. 1) I place a search item in Sheet2 Cell A1 e.g. "Laptops" and it opens Google and extracts all the url for laptops 2) It paginates to the next page, for which I have set to 5 pages, so URL from all 5 pages are...

HI,all , I am using following macro for extracting the data from sub folders my macro is working fine. just need a help if macro can update the reference of folder in column "Z" from where the data is copied. Ex : if data is copied from Folder no - 1 then my reference should be - 1 in column...

Hi, I found this macro online that works perfectly for what I want. However, would someone be able to modify it so that when you print all your pdfs, it also prints the date of the day it was printed? Thanks. Sub BatchPrintAllAttachmentsinMultipleEmails() Dim objFileSystem As Object...

Hi, How to refer Application.WorksheetFunction to the variable which represents column of table? This macro works perfect: Public MyTable as Object Sub test () Set MyTable = ThisWorkbook.Worksheets("Sheet1").ListObjects("MyTable_table") Msgbox...

<tbody> Account Object code Description 001 -111141- 001 -14559 - 001 -99-01-X -121-00-54080 - 001 -99-04-X -122-73-5L010 - 001 -02-02-X -152-00-56133 - </tbody> I am looking to extract the string between the 2 last hyphens. For example, i need to extract the object...