I need a tool in Excel/VB/Macro to download PDF files from a server to my desktop

Completed Posted 3 weeks ago Paid on delivery
Completed Paid on delivery

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where:

- I'll write the day, month and year

- I'll write the first invoice number and last invoice number that I want your tool to search

- I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL.

The URL for these files is a standard URL. It's always an URL like this:

[login to view URL]

The only part that changes is day, month, year and invoice number.

Example: if I want to download any available invoices between numbers 5000 and 10000 that were issued on February 3rd 2024, I'll write:

- 03/02/2024

- 5000

- 10000

And your tool will search and download any available invoices from 5000 to 10000 that was issued on that specific date, like this:

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

.....

[login to view URL]

[login to view URL]

[login to view URL]

.....

[login to view URL]

[login to view URL]

[login to view URL]

It would be a plus if your tool generate a TXT log file at the end, saying if each invoice was downloaded or not downloaded.

Excel Visual Basic VB.NET Excel Macros

Project ID: #38017582

About the project

11 proposals Remote project Active 3 weeks ago

Awarded to:

MimiFL

Hi, this is definitely possible and i've done similar automation many times before. If you are interested, feel free to share a sample file, so i can see exactly what you have so far and what needs to be done next. I More

$55 USD in 1 day
(819 Reviews)
7.6

11 freelancers are bidding on average $85 for this job

ESOLUTIONSSS

As an experienced Excel professional comprising of a plethora of relevant skills, I am more than equipped to undertake your task in creating a streamlined downloading tool for your invoices. With my expertise in Excel More

$50 USD in 1 day
(198 Reviews)
7.0
MamukaB

Hello, I can help with this job. Can start right now and finish it soon I have very good experience in data process automation I have check information details that you give and Yes I can do this job using VBA and del More

$45 USD in 2 days
(73 Reviews)
5.7
Abuzar00

With my extensive experience as a Backend Developer, I have constantly focused on creating solutions that simplify complex operations and streamline processes. Your project to download invoices in bulk clearly aligns w More

$140 USD in 2 days
(2 Reviews)
3.5
mian62

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?

$45 USD in 1 day
(6 Reviews)
2.2
ajeshjanardanan

Hi Andy C., How are you doing? As a professional developer with expertise in Excel, Excel Macros, VB.NET and Visual Basic, I eagerly anticipate the opportunity to complete this project for you. Please drop me a message More

$50 USD in 5 days
(0 Reviews)
0.0
omnitech0223

I can write this program for you. I created several programs that performed tasks exactly like you are looking to create. I am able to program the items you are looking to create. I am also able to create various pro More

$140 USD in 7 days
(0 Reviews)
0.0