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
"Hi there,
I am Sajib a Excel vba developer. I am interested in this project and want to work with you. Please send me a message for more discussion. Thanks"
Hi Hope you are doing good,
I can perfectly help you with that. I am a professional Excel expert
holding 7 years of experience in utilizing advance level tools and
functions of Google sheets & Excel (including VBA and Macro) to perform
Data Analysis, Data Visualization,I hereby humbly request you to
consider my bid for QUALITY and PROFESSIONAL work.
Kind Regards
Arun
Hello there!
Good day!
I am interested in this project. I can help you with this. I am an excal VBA expert with more than 8 years of expereience. Please reach out to me to discuss further.
Thank you!
Hey, I can get this done for you. Honestly, Code is right and it will populate image but its not setting the right dimensions. Would have even tried the solution but would be needing the excel file as well. Worst case, can design a new macro altogether to solve this problem. So with these solutions, I assure you that I can complete it soon with proper quality and visibility. I even am open to work by sharing my screen as well so that you have complete visibility. Hit me up if interested. (Would charge for 2-4 hours - depending on complexity - But be assured, it won''t take more then 4). Hoping to hear soon from you. Thanks!
Good day!
Cool task. Our team offers to do it for free for review.
Note:
The term of the order is conditional.
The exact term of the order - we will inform you after the agreement and approval of the Terms of Reference.
Regards, Alek Rasly
Hello!
I have examined your code and would like to make a few adjustments to your resolution parameters.
Please share the related Excel file and I shall be able to determine the changes required.
Thanks & Stay Safe
Bernard