
Completed
Posted
Paid on delivery
Fix Image Download Functionality in LibreOffice Calc VBA Macro I have a working LibreOffice Calc macro that successfully generates product descriptions, keywords, and DALL-E images via OpenAI API. However, the image download functionality is failing due to network/DNS resolution issues on my Windows system. What's Working - OpenAI Vision API calls (product descriptions) - OpenAI GPT API calls (keyword generation) - DALL-E 3 image generation (returns valid image URLs) - All API integrations are functional - Spreadsheet data processing and writing The Problem DALL-E generates valid image URLs, but downloading them to local disk fails with DNS/network errors. All attempted download methods fail with the same root cause: curl: Exit code 6 (couldn't resolve host) PowerShell: Blocked by execution policy, and when bypassed, DNS resolution fails VBScript with MSXML2: "Server name or address could not be resolved" Windows URLDownloadToFile API: Error code 0x800C0005 (DNS resolution failure) WinHTTP/MSXML2 COM objects: Connection failures System Environment - OS: Windows (cmd shell) - Application: LibreOffice Calc (not Excel) - Language: VBA/LibreOffice Basic - curl version: 7.55.1 (installed but DNS fails) Requirements - Fix the DescargarImagenLocal() function to successfully download images from DALL-E URLs to D:\macro_images\ folder. Must Have: - Download images from HTTPS URLs (DALL-E Azure blob storage) - Save as PNG files with specific naming convention - Work within LibreOffice Basic/VBA environment - Handle special characters in URLs (Azure SAS tokens with &, %, =) - Return local file path on success - Work despite apparent DNS/network restrictions on the system Current Code Structure - File: [login to view URL] - Function to fix: DescargarImagenLocal(sURL, sCarpetaDestino, sNombreArchivo) - Returns: Local file path string or error message - Called by: GenerarImagenesProducto() which generates 6 images per product Deliverables - Working DescargarImagenLocal() function that successfully downloads images Brief explanation of why the solution works when others failed - Any system configuration changes needed (if applicable) Files Available - Complete macro code with all context - Error logs showing DNS resolution failures Budget: 10$ Urgency: High - macro is 95% complete, only download functionality missing Ideal Freelancer Experience with VBA/LibreOffice Basic Knowledge of Windows networking APIs Experience with HTTP downloads in restricted environments Problem-solving skills for network/DNS issues Familiarity with COM objects and Windows APIs Additional Notes The macro processes multiple rows, so the solution must be reliable and repeatable DALL-E URLs expire in 2 hours, so downloads must happen immediately Manual browser downloads work, suggesting the issue is specific to programmatic access All previous attempts have been documented with detailed error logs To Apply: Please describe your approach to solving the DNS/network restriction issue and any similar problems you've solved before.
Project ID: 40188916
20 proposals
Remote project
Active 3 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Having developed numerous API integrations in my Full-Stack career, I'm confident I can tackle and resolve your DNS/network issue swiftly. My multi-faceted skill set that includes Node.js, [login to view URL], and Built complex back-end systems will aid in better understanding the DNS issue you've encountered. This, combined with the Apache configuration I have implemented to resolve similar issues in past projects, demonstrates my familiarity with handling network restrictions effectively. I've also dealt with data processing and writing extensively, which aligns perfectly with the requirement of your macro's functionality. Not only am I proficient in VBA/LibreOffice Basic but I know how to troubleshoot issues that occur within this environment well. Additionally, my experience using COM objects and Windows APIs will come in handy while resolving the current issue. Lastly, I've even worked on HTTP downloads in restricted environments before and was successful in finding reliable and robust solutions. My approach to problem-solving coupled with my understanding of network/DNS infrastructure allows me to solve such issues effectively. Combining these skills I'm positive we can fix the DNS resolution failures and get your LibreOffice Calc macro up and running smoothly again.
$10 USD in 1 day
0.0
0.0
20 freelancers are bidding on average $20 USD for this job

Dedicated Freelancer Ready to Elevate Your Project for LibreOffice Calc Macro DNS Issue Resolution. I have a solid background in Visual Basic, Excel, Python, LibreOffice, DNS, Visual Basic for Apps, Image Processing and API Integration, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan
$10 USD in 1 day
4.1
4.1

Hi there, I understand the urgency of resolving the download functionality for your LibreOffice macro, especially since you're so close to completion. With my experience in VBA and Windows networking APIs, I'm confident in fixing the DescargarImagenLocal() function to successfully download images from DALL-E URLs, addressing the DNS issues you've encountered. I'll ensure the solution handles HTTPS URLs, special characters, and provides reliable repeatability for processing multiple rows. Thanks,
$30 USD in 1 day
3.6
3.6

As a BIM Graduated with a strong background in IT management and an expertise in many programming languages, including VBA and LibreOffice Basic, I am confident that I have the skills necessary to tackle your project. I have extensive experience using MS Office applications, particularly Excel, which has honed my problem-solving abilities for similar networking issues like the DNS resolution problem you've encountered. Having worked in environments that demanded high efficacy with HTTP downloads in restricted settings, I can confidently handle the working environment limitations your project presents. Overall, my capacity to work within boundaries and come up with innovative solutions make me adaptable and resourceful. The reliability factor is guaranteed given my experience handling macros that process multiple rows without fail and within tight deadlines. With me on board, you can expect not only the completion of this project but acquisition of concrete deliverable that will boost the productivity of your LibreOffice Calc macro. Let's begin solving your DNS/network restriction issue together!
$20 USD in 7 days
3.4
3.4

Hi there, I see that you're facing some frustrating challenges with your LibreOffice Calc macro, especially regarding image downloads due to DNS issues. I have extensive experience in VBA and have successfully tackled similar problems with network restrictions in the past. To resolve the download functionality for DALL-E images, I will focus on refining your DescargarImagenLocal() function to effectively address the DNS resolution failures you've encountered. By utilizing alternate HTTP libraries and refining the handling of HTTP requests, I can ensure that images are downloaded reliably under the constraints you've described, while maintaining compliance with your file-naming conventions. I can start this project immediately and am confident in my ability to diagnose and resolve the issues you've faced. Utilizing my prior experience with network API integrations, I'm dedicated to delivering a polished solution within the next few days. Thanks, Sadam
$30 USD in 3 days
2.5
2.5

Hi there, I have 7+ years of experience in Python, Visual Basic, Excel and can deliver a clean, reliable solution for your project. I value clear communication and timely delivery, and I’m ready to get started immediately. Let’s connect and discuss your goals. Best regards, Dorian
$20 USD in 1 day
2.5
2.5

Hello Oscar, I hope you’re doing well. I have carefully reviewed your requirements for the LibreOffice Calc Macro DNS Issue Resolution, and l believe I am the best fit candidate for this due to my extensive experience in Excel. I would like to grab this opportunity and will work till you get 100% satisfied with my work. I bring 7+ years of hands-on experience working with Python, Visual Basic, Excel, DNS, Visual Basic for Apps, Image Processing, LibreOffice, API Integration. I have successfully handled similar projects recently. You can expect clear communication and 100% satisfaction. Please come over to chat and discuss your requirements in detail. Best regards, Ismail
$13 USD in 1 day
1.6
1.6

Hi Oscar, I am Vasyl, with 8+ years of experience in React, Angular, Node.js, and Python with expertise in API Integration. I have carefully reviewed your requirement for fixing the image download functionality in LibreOffice Calc VBA Macro. I propose to address the DNS/network resolution issue by implementing a custom solution within the DescargarImagenLocal() function. This solution will involve handling special characters in URLs, utilizing Windows networking APIs, and ensuring compatibility with restricted environments. I have extensive experience in resolving similar network/DNS issues and have a strong background in VBA/LibreOffice Basic, making me well-equipped to tackle this challenge effectively. I look forward to discussing this project further with you. Thanks, Vasyl
$25 USD in 7 days
1.6
1.6

Your logs are misleading you—this likely isn't a DNS issue at all, but a "shell context" problem. I’ve fixed this specific LibreOffice glitch before; the system blocks the download because the long DALL-E URL is getting cut off or treated as a command due to special characters like &. Most freelancers will waste time trying to fix your internet settings or firewall, but that will fail because the browser works fine. My fix handles the URL passing differently, bypassing the shell restrictions entirely so the connection stays alive. This ensures the file saves to your folder every single time without needing admin permissions or complex PowerShell scripts. I’ll also throw in a simple instruction file so you can manage this yourself later without hiring another dev. I know exactly how to debug this network behavior and can stop the error loop immediately. I am free to fix the code right now and send it back to you working perfectly. Let's get this finished.
$27 USD in 2 days
1.2
1.2

Hi I’ve fixed LibreOffice Basic macros on Windows where HTTPS downloads failed due to DNS issues by switching to a working WinHTTP/Windows API path that handles signed URLs correctly. Is this machine behind a corporate DNS or proxy setup? Are system-wide DNS settings working for other non-browser tools? Thank you, Emmanuel
$25 USD in 3 days
1.0
1.0

Hey , I just finished reading the job description and I see you are looking for someone experienced in Image Processing, Python, Visual Basic for Apps, Visual Basic, API Integration, LibreOffice, Excel and DNS. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? Deliver high-quality work with a strong focus on accuracy, efficiency, and client objectives. Maintain a proven record of long-term client satisfaction with consistently positive feedback. Earn 5-star ratings on recent projects, reflecting reliability and clear communication. Work with a structured, detail-oriented approach to ensure timely and accurate delivery. Availability: Full-time freelancer with flexible availability and fast response times (Eastern Time). I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Hassan.
$10 USD in 6 days
0.0
0.0

Hi, I’ve carefully reviewed your LibreOffice Calc macro DNS issue and understand the challenges with the DescargarImagenLocal() function failing to download images due to DNS resolution errors on Windows. I have hands-on experience with VBA and LibreOffice Basic, including integration with APIs like OpenAI and managing file downloads under restricted network environments. I am confident I can diagnose why traditional methods fail here, likely due to system-level DNS/configuration restrictions, and implement a robust image download solution that handles complex URL characters and respects your naming conventions. I’ll provide a reliable method plus a clear explanation to ensure future stability across multiple rows. I propose to complete this fix promptly given your urgency and deliver a tested solution that works seamlessly in your environment. Could you share any system security or network policies you suspect might be influencing DNS resolution on your machine? Best regards, Andrew
$15 USD in 1 day
0.0
0.0

Hello there, I am experienced in VBA programming and I would like to propose my services for your project to fix the image download functionality in your LibreOffice Calc VBA macro. I have identified the network/DNS resolution issues causing the download failures for the DALL-E images generated via the OpenAI API. With expertise in troubleshooting and resolving technical issues, I am confident in my ability to address and rectify the problem to ensure seamless image downloads within your macro. Regards, accentrasoftware
$20 USD in 4 days
0.0
0.0

Hello, I have reviewed your VBA issue and I understand that the problem was intentionally created and requires analysis and correction. I can analyze the existing VBA code, identify the root cause of the issue, and implement a clean and reliable solution. My approach includes debugging the logic, validating data handling, and ensuring the final solution works as expected without breaking existing functionality. I will also provide clear explanations of what was causing the issue and how it was resolved, so the code remains maintainable and easy to understand. I have experience working with VBA, data processing, and debugging legacy code, and I am confident I can resolve this efficiently. I am available to start immediately and deliver the solution within the agreed timeframe. Best regards, Kauãh
$10 USD in 1 day
0.0
0.0

Bucaramanga, Colombia
Payment method verified
Member since Nov 14, 2023
$10-30 USD
$10-30 USD
$30-250 USD
$10-30 USD
$30-250 USD
₹400-750 INR / hour
₹1500-12500 INR
$30-250 USD
$30-250 USD
$15-25 USD / hour
$15-25 USD / hour
₹1500-12500 INR
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR / hour
₹600-1500 INR
€250-750 EUR
$8-15 USD / hour
€250-750 EUR
$250-750 USD
$10-30 USD
₹12500-37500 INR
$250-750 USD