Why is Publisher being phased out, and what is Microsoft replacing it with? Will Microsoft 365 be cheaper since they are phasing out the program?

Thank you so much!

Lamar,

The macro in excel seems to be working well with an occasional error. looking in Debug, this line is  highlighted: appPub.ActiveDocument.ExportAsFixedFormat pbFixedFormatTypePDF, strParentname & "" & strBasename & ".pdf"And  then looking for more information I get a window that that is labeledRun time error '2147467259 (80004005)Method'ExportAsFixedFormat' of object' _Document'failed.If I go to the folder and delete the file (easy to find as it is not proceeded with a pdf file of the same name) then run the debugger again it starts over and goes through each file it has already exported to pdf over again. Is there a line of code I can add (and where would it go) to skip and continue when it reached such an error. I  have only had to move or delete 3 of hundreds of files it has completed successfully. But time is consumed rerunning  from the start after encountering an error.I do so appreciate your help with this as it has already saved me hours, even with this little problem. the only thing I see different in failed documents, is there is some text included in the  Alt Text tab when checking picture format properties. Removing Alt text doesn't seem to help.  And as you can see, I am an amateur user. Could I trouble you one more time for some help?

I have loved Publisher since its inception in 1993!  I became skilled in it and I have used many files for school, personal cards, work presentation, even a home business.  Word is more difficult to manage, and PowerPoint does not have the functionality of Publisher either.  I have recommended Publisher to countless friends and colleagues.  Now SO many people will have to find a replacement!  Why would MS drop such a popular program that has been a success??  To just delete it in a few months’ time seems harsh and insensitive.  You would make users grateful for MS to announce that it will be in full force in the future!  

Think of the loyalty these users will have for your next roll outs.  According to the comments, you might keep customers!

Diane, sorry I did not write the macro and am myself a novice at writing macros. I did a search and found the macro. I have written some macros, but not on that level. If you have a large number in one folder, maybe spilt then up into smaller folders. I had a bunch of folders with only around 50 files in each and had no trouble. Try that and see if it works without errors. Another way is to move the completed PUB files into a separate folder and the macro want see them and will skip over the PDF files That way you will have the PUB files and the PDF files in separate folders. Hope that helps.

Thanks for the quick reply. The folder I am exporting is rather large and a smaller one I did first ran without issue. I will move the several cards I still need to expert to a new folder and see if that works. Again, I do so appreciate your willingness to help.