Find Jobs
Hire Freelancers

Fix vba excel macro

€8-30 EUR

Zavřený
Zveřejněno před více než 2 roky

€8-30 EUR

Zaplaceno při doručení
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
IČ projektu: 30955360

O projektu

12 nabídky
Vzdálený projekt
Aktivní před 3 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
12 freelanceři nabízejí v průměru €30 EUR za tuto práci
Avatar uživatele
"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"
€12 EUR v 1 dni
5,0 (74 recenze)
5,8
5,8
Avatar uživatele
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
€30 EUR v 1 dni
5,0 (11 recenze)
3,5
3,5
Avatar uživatele
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!
€50 EUR v 7 dnech
4,7 (5 recenze)
3,1
3,1
Avatar uživatele
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!
€12 EUR v 1 dni
4,9 (2 recenze)
0,3
0,3
Avatar uživatele
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
€19 EUR v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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
€14 EUR v 1 dni
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z ITALY
Villanova Mondovì, Italy
4,9
208
Ověřená platební metoda
Členem od čvn 25, 2014

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.