Sub ExportImages_ExtendOffice()
'Updated by Extendoffice 20220308
Dim xStrPath As String
Dim xStrImgName As String
Dim xImg As Shape
Dim xObjChar As ChartObject
Dim xFD As FileDialog
Set xFD = Application.FileDialog(msoFileDialogFolderPicker)
xFD.Title = "Please select a folder to save the pictures" & " - ExtendOffice"
If xFD.Show = -1 Then
xStrPath = xFD.SelectedItems.Item(1) & "\"
Else
Exit Sub
End If
On Error Resume Next
For Each xImg In ActiveSheet.Shapes
If xImg.TopLeftCell.Column = 6 Then
xStrImgName = xImg.TopLeftCell.Offset(0, -1).Value
If xStrImgName <> "" Then
xImg.Select
Selection.Copy
Set xObjChar = ActiveSheet.ChartObjects.Add(0, 0, xImg.Width, xImg.Height)
With xObjChar
.Border.LineStyle = xlLineStyleNone
.Activate
ActiveChart.Paste
.Chart.Export xStrPath & xStrImgName & ".png"
.Delete
End With
End If
End If
Next
End Sub
##############################################################
ms access image path
=[CurrentProject].[Path] & "\images\" & [Item No].[png]
=CurrentProject.Path & Item No
?CurrentProject.Path & "\" & CurrentProject.Name in vba
F:\Rai Singh Rana\Site data\products images with id no\1.png
Autoclaves are essential devices in medical, laboratory, and industrial settings, known for their effectiveness in sterilizing equipment and materials. Their functionality revolves around the principle of moist heat sterilization, where steam under pressure is used to sterilize various items. This article delves into the autoclave's working principles, sterilization process, diagram, uses, pressure requirements, and the role of manufacturers and exporters in India. Autoclave Working Principle The working principle of an autoclave is based on the principle of moist heat sterilization. This method uses steam under pressure to kill harmful bacteria, viruses, fungi, and spores, ensuring that the items being sterilized are free from any microorganisms. The autoclave generates steam inside a closed chamber, increasing the pressure, which in turn raises the boiling point of water, allowing the steam to reach higher temperatures than boiling water at normal atmospheric pressure. Autoclav...