Printer error building Excel workbook...?
 

Hi everyone,

I've written a c# application which generates an Excel workbook (with
tables & graphs). After a few weeks of it working fine in production,
a bug has appeared out of nowhere and I can't figure out how to solve
it.

The Excel workbook runs fine until it suddenly stalls for a variable
amount of time (up to fifteen minutes sometimes) after which a series
of message boxes appear, one after the other, each containing one of
these error messages:

3080: OSPDLReg.c::Generatepaths unable to OpebPrinter
3025: OSPDLReg.c::OpenRegistryWithFriendlyName
3030: OSPD::OpenRegistryWthFriendlyName
Name \\ILEVELUK03\TOSHIBAe-Studio45515-PCL6UC {that's the
printer name}
3072: OSPDL::GetModelNameFromFriendlyName
1023: EFPCLDLG.c::OEM_BeginSession
3015: EFPCLReg.c::InitializeCustomDateArea
1024: EFPCLDLG.c::OEM_BeginSession
1044: EFPCLDLG.c::OEM_GetCustDataSize

(Note: Someone wrote these error messages down for me, so they might
not be completely accurate).

Does anyone have an idea what could be causing this? I'm presuming
it's something to do with the printer, since the printer name is
written on one of the error messages. We've reinstalled the printer,
but that doesn't seem to have solved the problem.

Has anyone seen this error before? Would be great if you could help me
out, as I'm at my wits end and I need to get this application running
again pretty urgently.


Thanks for your help,

Martin.

Printer error building Excel workbook...?
 

Sometimes external applications etc. cannot accept data as fast as th
macro can send it, so something has to give - usually the macro.

This looks like your problem. A way of getting round this is to pu
delays in the programme to allow for this. eg. 10 seconds ..
Application.Wait Now + TimeValue("00:00:10")

I suggest you dalso try an 'On Error Goto' line to exit more gracefull
while you are tweaking this to see what is suitable. I did do one som
time ago for a printer that included a wait line and included anothe
On Error line to keep trying/waiting. Can't find it though

--
Message posted from http://www.ExcelForum.com