Fix vba excel macro

Hello,

i have this macro

Sub GenerateProductLabelTranslate()

Dim destinationPathbongiovanni As String

Dim cellFormula As String

Dim chtObj As ChartObject

destinationPathbongiovanni = GetFolder("Dove salvo etichette TRADOTTE")

If destinationPathbongiovanni = "" Then Exit Sub

For i = 2 To Sheets("Farine").Range("A10000").End(xlUp).Row

If UCase(Sheets("Farine").Cells(i, 34)) = UCase("bongiovanni") Then

'save location

fname = destinationPathbongiovanni & "\" & Sheets("Farine").Cells(i, 33) & ".jpg"

' label id (where foreach working in template

Sheets("TemplateMicro").Cells(5, 19) = Sheets("Farine").Cells(i, 1)

'move to Template farine sheet

Sheets("TemplateMicro").Activate

'set zoom

Windows(1).Zoom = 100

cellFormula = Cells(5, 24).Formula

boldAlergensInIngredientsbong

Sheets("TemplateMicro").Range("A1:p14").Select

[login to view URL] xlScreen, xlBitmap

w = [login to view URL]

h = [login to view URL]

With [login to view URL]

.Activate

Set chtObj = .[login to view URL](100, 30, 400, 250)

[login to view URL] = "TemporaryPictureChart"

'resize obj to picture size

[login to view URL] = w

[login to view URL] = h

[login to view URL]("TemporaryPictureChart").Activate

[login to view URL] = xlNone

[login to view URL]

[login to view URL] Filename:=Replace(fname, "/", " "), FilterName:="jpg"

[login to view URL]

End With

Cells(5, 24).NumberFormat = "General"

If Cells(5, 24).HasFormula = False Then Cells(5, 24).Formula = cellFormula

' set zoom to 40%

'Windows(1).Zoom = 40

End If

Next i

Sheets("INSTRUCTIONS").Activate

MsgBox "Done!", vbInformation

End Sub

------------------------------------------

But the result is a bad image, i need a new one with and better resolution.

In attachment the image

Excel Visual Basic Visual Basic for Apps Data Processing VB.NET

Project ID: #30955360

About the project