software

I have a process which generates Excel reports and formats them (well when it works it will). All goes well until i get to the following bit of code
With xlObj.worksheets(1).cells(1, 1) .Copy .PasteSpecial PASTE:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False .Font.size = 14 .Font.ColorIndex = 5 .Font.Bold = True End With

at which point I get Automation Error. The server threw an exception.

Any Ideas on what this means and how to overcome it?
You'd want to have dots starting every line of code:

..Copy
etc.

--
Jim
quot;xlEntquot; gt; wrote in message
...
|
| I have a process which generates Excel reports and formats them (well
| when it works it will). All goes well until i get to the following bit
| of code
|
| With xlObj.worksheets(1).cells(1, 1)
| Copy
| PasteSpecial PASTE:=xlValues, Operation:=xlNone,
| SkipBlanks:=False, Transpose:=False
| Font.size = 14
| Font.ColorIndex = 5
| Font.Bold = True
| End With
|
| at which point I get Automation Error. The server threw an exception.
|
| Any Ideas on what this means and how to overcome it?
|
|
| --
| xlEnt

Originally Posted by Jim RechYou'd want to have dots starting every line of code:

..Copy
etc.

--
Jim
quot;xlEntquot; wrote in message
...
|
| I have a process which generates Excel reports and formats them (well
| when it works it will). All goes well until i get to the following bit
| of code
|
| With xlObj.worksheets(1).cells(1, 1)
| Copy
| PasteSpecial PASTE:=xlValues, Operation:=xlNone,
| SkipBlanks:=False, Transpose:=False
| Font.size = 14
| Font.ColorIndex = 5
| Font.Bold = True
| End With
|
| at which point I get Automation Error. The server threw an exception.
|
| Any Ideas on what this means and how to overcome it?
|
|
| --
| xlEnt

That's really odd. . . . the dots rae there in the code but diudn't survive the quote process in your reply