Automation Error

[xlEnt]

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?

 

[Jim Rech]

You'd want to have dots starting every line of code:

..Copy
etc.

--
Jim
|
| 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

 

[xlEnt]

You'd want to have dots starting every line of code:

..Copy
etc.

--
Jim
"xlEnt" (e-mail address removed) 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