Hi,
My Laptop is connected the company domain, I've written a script that
works fine when connected, but if the network goes down the script
runs extremley slow. When debugging it seems to be slow because of the
following line:

oXLSheet.Range("J" & cStr(intLastRow)).Font.ColorIndex = 1

Does anyone have any idea on why this is? When connected to the domain
does my laptop use fonts from the network rather than my local ones?

Any help would be appreciated

Rich

Just a guess...

I'd guess that it's not the font or color that's really the problem. I'm
guessing that it's inability to get to the printer (printer driver) that's the
problem.

Can you change to a local printer (driver)--even if it doesn't exist to test?

rich wrote:

Hi,
My Laptop is connected the company domain, I've written a script that
works fine when connected, but if the network goes down the script
runs extremley slow. When debugging it seems to be slow because of the
following line:

oXLSheet.Range("J" & cStr(intLastRow)).Font.ColorIndex = 1

Does anyone have any idea on why this is? When connected to the domain
does my laptop use fonts from the network rather than my local ones?

Any help would be appreciated

Rich

--

Dave Peterson

Thanks for the reply, but unfortunately no printers had been added.

Try adding a local printer and using that.

rich wrote:

Thanks for the reply, but unfortunately no printers had been added.

--

Dave Peterson