Macro's not working on other computers (help please)

[4lowie]

Hi All
I've been building a spread sheet with some good help from the forum, Thanks very much.

It's at a useable stage now (one last thing to do but it's beyond me at this stage...) so I've put it out for others to try. Trouble is that a couple of the macro's don't work on their computers. Works perfectly on mine!
I'm sure I have the code saved correctly, eg save to worksheet modules on to the private excel. (maybe both)

Can someone please have a look and see why this won't run correctly on other computers.

Thanks again for all your help.
Dave


FPM YAN 20131213 REFM Outstanding Notifications.xlsm

[ryan4646]

you need to create personal file. u can follow below link.

http://office.microsoft.com/en-001/e...102174076.aspx
http://techinfo.laurenceholbrook.com...lWorkbook.html

Hope this helps.

[abousetta]

I cleaned up code a bit. You should try to get in the habit of adding Option Explicit to the top of your modules and declaring the variables.

The only areas that I could see where you might be going wrong is

1) Running this on a computer not running Windows as you are using WScript
2) Trying to create a PDF in a version of Excel that doesn't have this capability (can't remember if this came out in 03 or 07)

You never said what line of code was causing the errors.

abousetta

[Alf]

Trying to create a PDF in a version of Excel that doesn't have this capability (can't remember if this came out in 03 or 07)

Excel 2003 don't have this capability, for Excel 2007 you must first install this microsoft add-in.


http://www.microsoft.com/en-us/downl...ails.aspx?id=7

Alf

[4lowie]

Thanks everyone for your help, much appreciated!

Now only need to sort out the rolling graph function.

Anyone keen to look at this for me??

Cheers Dave

[abousetta]

Now only need to sort out the rolling graph function.

Hi Dave,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can start a new thread explaining in more detail the issue with the rolling graph function?

Thanks.

abousetta