JonnyBT123
New Member
- Joined
- Jul 23, 2018
- Messages
- 14
Good morning all!
I’m after a bit of advice, as my issue is one I’ve neverexperienced until recently, and one that has personally never happened to me,but instead around 20% of my colleagues. I’ll explain below, but won’t post thevba unless necessary as it’s very long, and there’s no debug option that tellsanyone where the error is:
I have an emailer that goes out to my colleagues nationwide,asking them to complete orders they’ve requested, and the mailer creates theirown workbook, titled NAME – ORDER COMPLETIONS – DDMMYY (where DDMMYY is thedate the emailer’s ran) and also the sheet name is renamed to their name.
Emails with their personalised workbooks attached are sentout weekly, and contain the details of their order(s) and a tick box to mark ascomplete or leave blank for uncomplete. They then press a submit button which copiesthe order numbers they’ve ticked to complete and pings it back to me in anemail automatically.
It’s a process that every time I’ve tested it on myself andwith a select few colleagues in my office, works a treat, no issues whatsoever,however, around 1/5 of these colleagues come back to me with “I just get ‘InvalidProcedure or Argument’” or “Bad File Name” however when I open their workbook(which I save in a sharepoint site when sending out) and replicate the ones they wish to complete,I never have an issue.
Sorry it’s long winded, and I hope I’ve drawn up thescenario well.
Open for further interrogation to hopefully find a solutionto this issue which is letting me down so much! Thanks to all helpful comments in advance.
I’m after a bit of advice, as my issue is one I’ve neverexperienced until recently, and one that has personally never happened to me,but instead around 20% of my colleagues. I’ll explain below, but won’t post thevba unless necessary as it’s very long, and there’s no debug option that tellsanyone where the error is:
I have an emailer that goes out to my colleagues nationwide,asking them to complete orders they’ve requested, and the mailer creates theirown workbook, titled NAME – ORDER COMPLETIONS – DDMMYY (where DDMMYY is thedate the emailer’s ran) and also the sheet name is renamed to their name.
Emails with their personalised workbooks attached are sentout weekly, and contain the details of their order(s) and a tick box to mark ascomplete or leave blank for uncomplete. They then press a submit button which copiesthe order numbers they’ve ticked to complete and pings it back to me in anemail automatically.
It’s a process that every time I’ve tested it on myself andwith a select few colleagues in my office, works a treat, no issues whatsoever,however, around 1/5 of these colleagues come back to me with “I just get ‘InvalidProcedure or Argument’” or “Bad File Name” however when I open their workbook(which I save in a sharepoint site when sending out) and replicate the ones they wish to complete,I never have an issue.
Sorry it’s long winded, and I hope I’ve drawn up thescenario well.
Open for further interrogation to hopefully find a solutionto this issue which is letting me down so much! Thanks to all helpful comments in advance.