Answered

Microsoft Power Automate Desktop - Paste Screenshot in Excel Worksheet

(2) Share

Report

Posted on by PS-05051208-0

I am using Microsoft Power Automate Desktop. I want to take screenshot of current application present on screen(web application / desktop application...) and add that screenshot in new worksheet of excel. How to do that?

Categories:

Power Automate Desktop

Capture.PNG

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report
Hi @PS-05051208-0

Try this vbscript using run vbscript action - this helps to paste an image file to the excel cell range in sheet.

Dim objExcel, objWorkbook, objWorksheet, objImage Dim cellRange, imagePath,excelfilepath,sheetname ' Define your variables sheetname="%sheetname%" cellRange = "%CellRange%" ' Change to your desired range imagePath ="%ImageFile%" ' Change to your image file path excelfilepath= "%FilePath%" Set objExcel = CreateObject("Excel.Application") objExcel.Visible = False ' Make Excel visible Set objWorkbook = objExcel.Workbooks.Open(excelfilepath) ' Change the file path Set objWorksheet = objWorkbook.Sheets(sheetname) ' Select the first sheet ' Add the image to the worksheet Set objImage = objWorksheet.Pictures.Insert(imagePath) ' Set the image position based on the specified range objImage.Left = objWorksheet.Range(cellRange).Left objImage.Top = objWorksheet.Range(cellRange).Top ' Resize the image to fit within the specified range objImage.Width = objWorksheet.Range(cellRange).Width objImage.Height = objWorksheet.Range(cellRange).Height ' Save and close workbook objWorkbook.Save objWorkbook.Close objExcel.Quit ' Clean up Set objImage = Nothing Set objWorksheet = Nothing Set objWorkbook = Nothing Set objExcel = Nothing

I have tried below sample flow to test its functionality.

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
PS-05051208-0 11 on at

Like (0)

Report

@Nived_Nambiar Thanks for you answer it worked for me. Can you please do the same for CSV file? That would be really helpful. Thanks :)

Was this reply helpful? Yes No