Cutepdf writer on cpw211/18/2023 Mybookname = Left(mybook.Name, LPosition) LPosition = InStr(1, mybook.Name, ".") - 1 Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum)) MyPath = "c:\Documents and Settings\shuerya\Desktop\ExcelFiles\"įor Fnum = LBound(MyFiles) To UBound(MyFiles) 'Fill in the path\folder where the Excel files are Sub Convert_Excel_To_PDF()ĭim MyPath As String, FilesInPath As String Hopefully this helps you to convert one or many files, to PDF. It takes all Excel files in a folder, and converts each to a PDF file. Here is some code that I developed a while back. "Acrobat could not open 'FileName'.pdf because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded)." This worked well the first few times but now I get the following message whenever I try to open any new file created. MyVal = myLocation & myName & myFileType 'example C:\My Documents\FileName.pdfĪ Copies:=1, Preview:=False, _ĪctivePrinter:="CutePDF Writer on CPW2:", Collate:=True, _ MyLocation = Sheets("Lists").Range("U2").Value MyName = Sheets("RequestedNursingHomes").Range("A11").Value & " " & Format(Now(), "dd") & Format(Now(), "mm") & Format(Now(), "yyyy") See the event user data for context information.I have file that generates a worksheet based on user selection and then saves the worksheet to a pdf file as followsĭim myName As String, myLocation As String, myFileType As String The print spooler failed to load a plug-in module C:\Windows\system32\spool\DRIVERS\W32X86\3spool\DRIVERS\W32X86\3\HPCPN082.DLL, error code 0x7e. See the event user data for context information. The print spooler failed to load a plug-in module C:\Windows\system32\spool\DRIVERS\W32X86\3\hpmdp082.dll, error code 0x7e. The print spooler failed to load a plug-in module C:\Windows\system32\spool\DRIVERS\W32X86\3\KMUU51E5.DLL, error code 0x7e. The default printer was changed to \\DCMAIN\REDept_MFP,winspool,Ne01. ![]() The print spooler failed to load a plug-in module C:\Windows\system32\spool\DRIVERS\W32X86\3spool\DRIVERS\W32X86\3\hpcpn083.dll, error code 0x7e. The print spooler failed to load a plug-in module C:\Windows\system32\spool\DRIVERS\W32X86\3\hpmdp083.dll, error code 0x7e. The print spooler failed to load a plug-in module C:\Windows\system32\spool\DRIVERS\W32X86\3\PS5UI.DLL, error code 0x7e. The default printer was changed to CutePDF Writer. The print spooler failed to load a plug-in module HPMPW081.DLL, error code 0x7e. This can occur because of system instability or a lack of system resources. The system cannot find the file specified. \\DCMAIN\REDept_MFP initialization failed at \\DCMAIN\print$\BIDI\HPBOID.DLL. The default printer was changed to \\DCMAIN\REDept_MFP. \\DCMAIN\Color LJ- 15 initialization failed at \\DCMAIN\print$\BIDI\HPBOID.DLL. The default printer was changed to \\DCMAIN\Color LJ- 15,winspool,Ne01. The default printer was changed to \\DCMAIN\KM-8030-14,winspool,Ne02. The default printer was changed to \\DCMAIN\REDept_MFP,winspool,Ne00. The default printer was changed to CutePDF Writer,winspool,CPW2. Here's some of the printer event logs if they help: Information I have to say I'm kinds stumped on this one and would greatly appreciate help! ![]() The client is using Windows 7 professional 32-bit and the network printer is shared through a windows server (I think 2003). I'm pretty sure it's not the printer itself because several other people have it set as the default printer and have never had this issue.Įverything is on LAN and the computers are always connected to the network. I have tried removing all the printer drivers and whatnot using the steps in threads like this one, but it made We keep trying to set his default printer to a networked HP LaserJet M4345 printer, but when he restarts his computer, and occasionally when it's idle, it will switch theĭefault printer to CutePDF (a program to print to PDF files). I work IT for a company and one of our clients is having printer issues.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |