Basically what i;m trying to do is to get into the property of the element. Thank you

HI, i struggle to get next path: document.getElementsByTagName("svg")[1].getElementsByTagName("path")[4].__data__.markerData(0).cy Trouble here is that Excel VBA says that __data__ is an invalid character? do you have any thoughts? Thank you PS: i changeover square brackets to round ones.

Hi Kamal, great videos. I struggle to implement the readystate while using an existing internet explorer opened. One of your previous videos using the SHDocVw.InternetExplore. Thank you

THANK YOU so much for this! It did work!

Hi, is there a way to get the body of email from postmaster

I think this is the solution I am looking for. Very good content, even 4 years later.

How to know how any jobs ran on a sever in the last 24 hours

Great video. This works; however, when you replace .Body with .HTMLBody I lose the paragraph breaks I had before. How do I fix this? For example, before you replace .Body with .HTMLBody, you had three different lines in the VBA generated email. Those would now show up as concurrently running sentences?

Hi sir i just need the email body in excel sheet with matching headings how can i do that with vba

thanks man, u helped me

nice tq

what if to open Chrome or Microsoft edge? there is no Internet explorer at my workplace

Multiple word doc then what can we do

How can I do it using Google Chrome?

Hi , is it possible to create an Outlook VBA macro to extract emails sent in 2023 and extract emails where I have not been answered and extract reply emails in long times? thanks

Hi sir can u say about xml schema validation

i am getting error as No keyword with name 'and' found. for the condition Run Keyword If '${visible_date}' == 'True' and '${enabled_done}' == 'True' Click Element ${DONE_XPATH} Please help me to tackle this issue

I have a project where I have to find the latest xml file in specified folder (where multiple folders are there with same or diff file with different modified date)

I have a pleasures , if I could see the name of the import excel files name as progress bar,It would be much better,Each import file has its name displayed during data collection.In this way, the import would be completed by displaying one after the other. I have searched a lot tutorial in internet or youtube but did not find, such as the progress bar will be added as a percentage according to the number of files selected to import, the mouse is busy during the import time, this is busy time. It will have a progress bar attached, is it possible to create such a difficult program, which is not available till date, if you could do it, my hope would be fulfilled, but it is a very difficult task, hope you will try,

can't say how much I appreciate Kamal's teaching style and pace. So good! Quick, to the point, good examples, makes learning fun and easy! - okay tbh I have struggled a bit with the web scraping stuff but now trying to go from the basics up, we'll see how we go

this series has been so good

Could you please provide the code here so we can copy it ?

What is introduction?

Still can't believe how good you are at explaining this stuff mate! love your pace

Dude, this is literally amazing. so much info, so clearly explained/demonstrated, and so quick. Best I've seen on VBA yet

How to use the same code to add custom signature which is created in outlook apart from the one which is set to default.

Microsoft Outlook x.xx Object Library missing what to do?

Excellent

Excellent

Like your explanation - very well & simple

works perfect! - how do i search specific file (based on filename) and find the latest filename based on last modified date and move to specified location?

thankyou please share you mail id

very helpful... thanks Kamal

I'm trying to setup a web scraper for facebook marketplace, can you help me with that?

thanks bro

Is there a way to change accounts for lecture 6?

Where can I get this code

Thank you for this very interesting tutorial, I ask you, in the same subject, to make a video which explains, using vba, how to keep the ten recent files and delete the others I managed to make a backup folder but I still want to keep the ten recent copies only, thank you

Hi, can anyone please help? Keep getting error that word doc is locked for editing, open read only. Thanks a lot in advance! Runtime error 462: The remote server does not exist or is unavailable. Here's the code: Sub GenerateCertificates() Dim wd As Word.Application Dim doc As Word.Document Set wd = New Word.Application wd.Visible = True For i = 2 To 5 Set doc = wd.Documents.Open("D:\CPD\Certificates\template.docx") With wd.Selection.Find .Text = "<<name>>" .Replacement.Text = Cells(i, 2).Value .Execute Replace:=wdReplaceAll End With With wd.Selection.Find .Text = "<<date>>" .Replacement.Text = Cells(i, 1).Value .Execute Replace:=wdReplaceAll End With doc.ExportAsFixedFormat OutputFileName:=ActiveWorkbook.Path & "/" & Cells(i, 2).Value & "_" & Cells(i, 1).Value & ".pdf", ExportFormat:=wdExportFormatPDF Application.DisplayAlerts = False doc.Close SaveChanges:=False Application.DisplayAlerts = True Next wd.Quit End Sub

Thank you for this. I have one question.. you explained on known number of columns. My case i want to pass the no of columns dynamically. In this case how can we do that

Sir how to make such template to attached on mail rather than on mail body and send automail on emails

output console dose not show the message in free freestyle job in jenkins !!!

Thanks a lot!!!

great video. This is close to what I am looking. I have a list in excel like this and Word mail merge. Do you know how to create a print button to print what row I select? or enter a row number to print?

Can some one tell me how to add current date between sentence in the body of the mail using macro or html

can u help me. (Office 2012) So i already follow ur step completely. no error but it wont create the PDF. can u help me? Thank you Sub createPDFs() Dim wd As Word.Application Dim doc As Word.Document Set wd = New Word.Application wd.Visible = True For i = 2 To 7 Set doc = wd.Documents.Open("D:\Folder Sampah\Surat CB\template.docx") With wd.Selection.Find .Text = "<<store>>" .Replacement.Text = Cells(i, 1).Value .Execute Replace:=wdReplaceAll End With doc.ExportAsFixedFormat OutputFileName:=ActiveWorkbook.Path & "/" & Cells(i, 2).Value & "_" & Cells(i, 1).Value & ".pdf", _ ExportFormat:=wdExportFormatPDF Application.DisplayAlerts = False doc.Close SaveChanges:=False Application.DsplayAlerts = True Next wd.Quit End Sub

thanks

Thanks ! helped me a lot :)