Runtime Error 5 Invalid Procedure Call or Argument

**Pezzaa** · 03-10-2020, 08:40 AM

Afternoon Excel Forum!

I posted back in January for some help to fine tune a Print to PDF macro. This went well and we have enjoyed using the functionality... until today, today I cannot fix the 'Runtime Error 5'

I've posted my code below, the error is on:

'Save as PDF
ActiveSheet.ExportAsFixedFormat...

Please Login or Register  to view this content.

I've seen varying responses on Google, none that quite match what i'm trying to achieve and also struggling to understand what error Runtime 5 is!

Any advice would be greatly appreciated

**romperstomper** · 03-10-2020, 09:08 AM

Are you sure that A19 on the active sheet contains a valid file name?

**Pezzaa** · 03-10-2020, 09:52 AM

It does indeed. I have it set to white text so users can't see it but it's definitely there.

**Pezzaa** · 03-10-2020, 09:58 AM

I did wonder if it might be because there is nothing to specify A19 in Sheets HSE052 Fall PPE Certificate, but this code has been working for a few months now.

**romperstomper** · 03-10-2020, 10:06 AM

You should add that:

Please Login or Register  to view this content.

**Pezzaa** · 03-10-2020, 10:08 AM

Added the code in and re ran the macro, it returned with 'Run-time error' '9' Subscript out of range'

**romperstomper** · 03-10-2020, 10:15 AM

Based on your original code the sheet name starts with HS052 not HSE052, so you'll need to change that.

**Pezzaa** · 03-10-2020, 10:18 AM

I've just been reading the code again and spotted the same, now i'm back to the Runtime Error 5

**romperstomper** · 03-10-2020, 10:19 AM

What exactly is in A19?

**Pezzaa** · 03-10-2020, 10:21 AM

A19 is a concatenation of 3 cells within HS052 Fall PPE Certificate sheet. The formula reads '=CONCATENATE(H6," ",B6," ",F7)'

**romperstomper** · 03-10-2020, 10:28 AM

I mean what is the actual value in that cell when the error occurs?

**Pezzaa** · 03-10-2020, 10:30 AM

'sn 100551492 & sn 10551797 Spanset RA Harness with Adjustable Restraint Lanyard Pass' is the currently the result of the concatenate. Do you think this could be too long?

**romperstomper** · 03-10-2020, 10:32 AM

It's possible, particularly as that is quite a long folder path too. Test it with a short file name and see if that makes a difference.

**Pezzaa** · 03-10-2020, 10:33 AM

The spreadsheet works on a number of tabs:

1. Harness Register
2. Withdrawn from Service Register
3. Thorough Inspection Form -- This is where the serial number is pasted into, from the Harness Register, to build the the Checklist and Certificate sheets
4. HS052 Fall PPE Checklist
5. HS052 Fall PPE Certificate

I have just taken a shorter serial number and gone through the process of creating the certificate, used the macro and hey presto! it worked!

I also did an =LEN( on 'sn 100551492 & sn 10551797 Spanset RA Harness with Adjustable Restraint Lanyard Pass' which came back as 83 characters, i think this is too long for a filename perhaps.

**Pezzaa** · 03-10-2020, 10:37 AM

Hurrah!

That's worked wonderfully, thank you for your time and help rorya!

**romperstomper** · 03-10-2020, 10:45 AM

I think it's the combination of the file name and path being too long. Perhaps you could output them somewhere locally first, then move them later?

**Hasanali** · 03-22-2021, 04:00 AM

Invalid procedure call or argument (Error 5) excel
how to resolve

**romperstomper** · 03-22-2021, 04:37 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Runtime Error 5 Invalid Procedure Call or Argument

LinkBack

Thread Tools

Rate This Thread

Display

Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Re: Runtime Error 5 Invalid Procedure Call or Argument

Thread Information

Users Browsing this Thread

Similar Threads

VBA Log function Runtime Error '5': Invalid procedure call or argument

[SOLVED] Invalid procedure call or argument error

Help! Run-Time Error '5': Invalid procedure call or argument

[SOLVED] runtime error 5, invalid procedure call or argument ??

Invalid procedure call or argument (Error 5)

Runtime Error 5: Invalid procedure call or argument

Invalid procedure call or argument error

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions