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

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 :)

great videos , just a question if i want to rename the file and copy to another path ? the old file list in different sub folder

Why is it showing an error - run time error '53': File not found?

Excellent video. I will sub to this channel. Best regards from Brazil

Keep getting this error, "This value doesn't match the data validation restrictions defined for this cell". And holiday sheet is missing 🙄

Great and simple solution. Thank you very much.

Very helpful indeed. Works perfectly. Many thanks!

Can we use Intellij Idea for the robot framework?

Can anyone please say me that how did his word file is automatically sepleting name from excel file

Signature is not working..could u plz help me😊

T

Thank you!!

Very usefull video before my board exam on today 2nd April 2024....I'm watching this video at 2nd April 2024 at 01:47 A. M.

Great videos sir, really helping me a lot in my current Role and also improving the way of thinking and analyzing new things

I don't know my code is not working. Please help me out

❤Thanks a lot! You saved my life!

I am a QA. I am doing automation tests with java and selenium. i want to learn robot framework. what i want to know is can i use robot framework with java?

Bro how to enables the suggestion while writing the vba code

Super Thank You So Much 🎉

Thanks for your excellent video. The either Quick access tab or Customize tab for these email templets are not working properly. the QAT works only for one macro run. After that those tabs are dysfunction. How to fix the issue?

Thank you man. I was stuck on how to change a new tab for 6 hours and your video solved my problem. You are the guy

Sir What if I used jenkins docker compose to create jenkins image . I tried same steps of yours but when I run pipeline script I got docker not found error

Really very clear and precise explanation on the topic when should we use git init and git clone<Repository url> . A lot of thanks sir

Is this still feasible ❓❓Internet explorer is discontinued. From what i understand you have to use Selenium in conjunction with Chrome to scrape using VBA code.

Thanks Kamal!! This will save me a lot of time!!

Thank you very much!!!

Hi, how to filter excel table just by entering a part of number in the cell value, please code here

Hi, What if we need to execute the job concurrently via a single pipeline... with parallel it executes the stages under same job say job 7 for all the environment parameters which are selected, but I need that all the stages should run for each environment I selected under different job number say for env1 all the stage of build deployment should run under job 7 the similarly for env2 the job should run all the stages of build n deployment under job 8 and similarly under job 9 it should do same for env3 n so on.. I select build with parameter and have set up environment name and build file name as parameters then click on build now button now I want that Jenkins should trigger as many job as many environment I have selected during build with parameters and execute all the stages defined within the jenkinsfile for each Please advice

is the variable a immutable in different module or different sub?

hi please help me if you have any video that will teach , how to download pdf attachment in multiple mail from e mail or out look

Hi, How to count how many string?

How if in case there are xls files if we can change the sheet name as well at the same time

Please share code for better understanding. Without code this tutorial is useless...

Hi kamal in this macro from the range provided if a row is blank i want it to get automatically deleted please help with this

Hi @Kamal - If i want to add multiple email ids how to handle that in this code please respond

PUEDES DEJARME LA CONTRASEÑA DEL ARCHIVO AMIGO?

Hi, i want to source the email for a hard drive path and extract the table on the macro excel worksheet, what code do i use ?