I totally feel you rn, as I have found myself in this situation. Last time was only about 6 weeks ago when i needed someone to drive me somewhere to buy a motorhome I'd dell in love with at a bargain price.
I even said using my car not even theirs!
I found the response from a couple of ppl was "can do it in 2 weeks" err, yeah, like the motorhome will still be available in 2 weeks! That, to me, is basically a saying an insincere yes (knowing it's pointless) without saying no!
I got the train in the end.
Cost more than the fuel Would have.
I am always the taxi, always happy to drive someone anywhere and I mean anywhere, I don't ask for fuel either I let them offer unless it's only a few miles away I don't take anything in return.
Always picking friends and partner's friends from a pub or restaurant, if I am with them i drive, cba with taxis and i choose not to drink alcohol. i have 5 spare seats for anyone wanting a lift home.
Anyway, it seems that whenever I need a lift, the excuses come in thick n fast from everyone.
So, my advice is simple, Take pleasure I saying a big fat "NO!" whenever someone asks you for a favour in future .
It's what I'm doing going forward.
And that really is going against my nature of a helpful person.
Hope this helps.