
Open
Posted
•
Ends in 6 days
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
9 proposals
Open for bidding
Remote project
Active 22 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 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.5
3.5

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

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

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

Bucaramanga, Colombia
Payment method verified
Member since Nov 14, 2023
$10-30 USD
$10-30 USD
$30-250 USD
$10-30 USD
$10-30 USD
$750-1500 AUD
$25-50 USD / hour
€3000-5000 EUR
₹750-1250 INR / hour
£20-250 GBP
$250-750 USD
€3000-5000 EUR
$2-8 USD / hour
$15-25 USD / hour
₹12500-37500 INR
$10-30 USD
$25-50 USD / hour
$30-75 USD
₹600-1500 INR
€250-750 EUR
$30-250 USD
$250-750 USD
$10-150 USD
₹600-1500 INR
₹750-1250 INR / hour