Find Jobs
Hire Freelancers

Fix vba excel macro

€8-30 EUR

Suljettu
Julkaistu yli 2 vuotta sitten

€8-30 EUR

Maksettu toimituksen yhteydessä
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
Projektin tunnus (ID): 30955360

Tietoa projektista

12 ehdotukset
Etäprojekti
Aktiivinen 3 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
12 freelancerit tarjoavat keskimäärin €30 EUR tätä projektia
Käyttäjän avatar
"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 1 päivässä
5,0 (74 arvostelua)
5,8
5,8
Käyttäjän avatar
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 1 päivässä
5,0 (11 arvostelua)
3,5
3,5
Käyttäjän avatar
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 7 päivässä
4,7 (5 arvostelua)
3,1
3,1
Käyttäjän avatar
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 1 päivässä
4,9 (2 arvostelua)
0,3
0,3
Käyttäjän avatar
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 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan ITALY lippu
Villanova Mondovì, Italy
4,9
208
Maksutapa vahvistettu
Liittynyt kesäk. 25, 2014

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.