Compile error after including a Function in my code

[demarc]

Hi all,

I have a program I have been working on for some time that works in the OneDrive environment. I grabbed some code online to be able to save a PDF of a worksheet while offline in a file on OneDrive and ever since I a reoccurring compile error:

Capture.GIF

Generally if I comment out the code and then compile the program compiles, I then un comment the code and then compile again and good to go. Maybe two weeks later the same thing happens and I repeat the process and it works again for a while.

This is the function:

Please Login or Register  to view this content.

and this is how I call it:

Please Login or Register  to view this content.

FilePath is Dimmed as a string.

Can anyone see anything wrong with this code that could be causing the error or maybe a better way to achieve the same result?

Kind regards,
Marcus

[6StringJazzer]

The error message says that the compile error is in ThisWorkbook. Is that where the function is? Is there any other code in ThisWorkbook? If so please show all the code in ThisWorkbook.

The error you get is unusual. Normally a compile error will result in a dialog box that allows you to enter the VBA environment, shows you where the error is, and allows you to debug.

Is it possible for you to attach your file?

[demarc]

Hi there,

There's probably 50k lines of code so no point attaching the whole WB or the code. The error only started appearing after I added this Function and its related call. Mostly it does go to a point in the code and the error is that a particular sub that gets called in another module is undefined. It is a sub that has been in the code for years and has always worked with no issues. I generally stop the code, comment out the above code and re compile which works fine, then uncomment the above code and compile again. Program then works for another week or so and then same thing.

It almost always happens if I do not compile the code before closing the program if I have been working on the code. On open I get the error, however if I compile before closing the error will not appear.

Its quite strange but hoping someone has experienced something like this before..

Kind regards,
Marcus