Problems with dashboard VB code not working

[worthm]

Hello,
I'm using Office 2010 and I am not a programmer. I have a macro and VB code which saves each sheet in a workbook to a file location and each sheet is saved as a PDF with the name of the tab from which it came. After the December 2014 Microsoft update it stopped working. My IT dept. removed the update so it should work now but its not and I cant figure out why. The VB code is in module three. Can someone tell me what I'm doing wrong? I've attached the dashboard

Thanks for your help!

[Paul_Hossler]

There used to be a sticky, but I think this might help

http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/


Basically, you just delete all the 'old format' .EXD files

The post-December version will re-create them

[worthm]

Thanks, I've been there many times.

I've followed all of the steps, the .exd files are not there, and the spreadsheet still isn't working. I've done a reboot and my IT dept. has rolled back the update and hidden it so it should no longer affect my PC. What now?

[worthm]

Can someone take a look at the visual basic code on module three and tell me if it should work? I'm rolling this dashboard out to 100 employees on Monday and its not working

[worthm]

Also, is there another way to do this? I need to dump all sheets into their own PDF file and I cant think of any other way to do it

[JKwan]

Well, I have no problem running your code. I made a minor change to the code in order to make it run. Since the PASSWORD tab is hidden, it choked at that sheet. I made an exclusion to it and it ran fine.



If sht.Name <> "Welcome screen" And sht.Name <> "Passwords" Then

[worthm]

JKwan,

Oh My God! I've been banging my head on this problem since 12/1/14. I've posted this at 4 or 5 websites. No one figured his out but you!

Thank you!
Thank you!
Thank you!

No I can roll this out to all of the employees

Thank you again!

[JKwan]

oh, you are so very welcome. I can see that you a slightly happy :-)

[worthm]

Yes, this is HUGE

[Paul_Hossler]

After the December 2014 Microsoft update it stopped working


Glad it works now, but I'm hoping the Dec Update was a coincidence. Did you test to see if it works on a PC that has the update?