Last seen: Jun 10, 2026
The first message is quite normal - you just need to say Yes and check the box to not ask again. (the code is not saving the files so there will be no...
Using a template actually fixes the first error (you hadn't defined olMailItem) too: Option Explicit Sub SendEmailList() On Error GoTo ErrHandl...
Yes, it looks like the forum software stripped out any occurrences of a 'less than' symbol followed by a 'more than' symbol (presumably treated it as ...
You could do something like this (it could probably do with a bit of refactoring and some error handling, but should get you started): Option Expli...
"I'm not sure saying 'rethink your approach coz using formatting to calculate is bad' is helpful. And "you really shouldnt be calculating anything on ...
For the difference, you could also use: =MAX(0,B2-C2)
Instead of hardcoding them in the code, refer to ranges like this: startDate = sheets("sheet name").range("A1").value for example.
That looks like OpenOffice to me, in which case try changing the comma to a semicolon: =C11*($D$9+ISNUMBER(FIND("PGS";B11))*1.5%)
How are you opening the new instance? If you do it in code using automation (I.e. not Shell) then no startup files are loaded (that has always been th...
Apologies - that's the legacy method. You would actually want (now that I'm at my computer) Data - New Query - From Database - From SQL Server Databas...
Your colleague should be choosing Data - From other sources - from SQL server database (the first option).
No worries - I confess my eyes tend to glaze over if I see MMULT in a formula. 😉
Just to note: cross posted in a couple of places:
Something like this?
Are there any hidden sheets in the workbook?