hi all,
I'm trying to save as excel sheet to image( jpg or png) and i write this code but its not working :
fileSaveName = Application.GetSaveAsFilename(fileFilter:="Image (*.jpg), *.jpg")
If fileSaveName <> False Then
Sheets("Sheet2").Export Filename:=fileSaveName, FilterName:="jpg"
End If
can someone provide the correct method to use?
I'm trying to save as excel sheet to image( jpg or png) and i write this code but its not working :
fileSaveName = Application.GetSaveAsFilename(fileFilter:="Image (*.jpg), *.jpg")
If fileSaveName <> False Then
Sheets("Sheet2").Export Filename:=fileSaveName, FilterName:="jpg"
End If
can someone provide the correct method to use?