I'm working on a vba enhanced macro that publishes a pdf to the desktop. I'm
in an office with about 10 computers, all using MSOffice 2007. So far, it
works on 3 of 5 computers.

Here is the sample of code that the debugger flags:

ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:="C:\test\test.pdf"
Openafterpublish:=False

The error message is "Runtime error #5, invalid procedure call or argument"

I just checked and both computers were not updated with the Office SP2. I
haven't tried it since both have been updated.

Also, on the computer that doesn't work, there are little pop-up syntax
helpers while you're typing arguments in the VBA editor, similar to when
you're typing arguments in excel's formula bar. My computer's VBA editor
does not do this. I don't know if they're different versions, or some
obscure option is enabled/disabled on one of them.

Please help! I'm pulling my hair out.

BD

hi Beric

Read the first part on this page
http://www.rondebruin.nl/pdf.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Beric Dondarrion" wrote in message
...
I'm working on a vba enhanced macro that publishes a pdf to the desktop. I'm
in an office with about 10 computers, all using MSOffice 2007. So far, it
works on 3 of 5 computers.

Here is the sample of code that the debugger flags:

ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:="C:\test\test.pdf"
Openafterpublish:=False

The error message is "Runtime error #5, invalid procedure call or argument"

I just checked and both computers were not updated with the Office SP2. I
haven't tried it since both have been updated.

Also, on the computer that doesn't work, there are little pop-up syntax
helpers while you're typing arguments in the VBA editor, similar to when
you're typing arguments in excel's formula bar. My computer's VBA editor
does not do this. I don't know if they're different versions, or some
obscure option is enabled/disabled on one of them.

Please help! I'm pulling my hair out.

BD

Cool. Office SP2 fixed it.

Thanks

"Ron de Bruin" wrote:

hi Beric

Read the first part on this page
http://www.rondebruin.nl/pdf.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Beric Dondarrion" wrote in message
...
I'm working on a vba enhanced macro that publishes a pdf to the desktop. I'm
in an office with about 10 computers, all using MSOffice 2007. So far, it
works on 3 of 5 computers.

Here is the sample of code that the debugger flags:

ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:="C:\test\test.pdf"
Openafterpublish:=False

The error message is "Runtime error #5, invalid procedure call or argument"

I just checked and both computers were not updated with the Office SP2. I
haven't tried it since both have been updated.

Also, on the computer that doesn't work, there are little pop-up syntax
helpers while you're typing arguments in the VBA editor, similar to when
you're typing arguments in excel's formula bar. My computer's VBA editor
does not do this. I don't know if they're different versions, or some
obscure option is enabled/disabled on one of them.

Please help! I'm pulling my hair out.

BD

.

I have the same problem, but I've just rolled back from SP2 due to my graphs corrupting when they were saved as pdfs (as per the issue he http://groups.google.co.uk/group/mic...hl=en&ie=UTF-8 )

It therefore seems that to save to pdf using VBA, I can either have a corrupted file using SP2, or an invalid procedure call on SP1!

Surely there has to be a way round this?

Thanks!



Beric Dondarrion wrote:

Cool. Office SP2 fixed it.Thanks"Ron de Bruin" wrote:
17-Nov-09

Cool. Office SP2 fixed it.

Thanks

"Ron de Bruin" wrote:

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Create Function in SQL Server
http://www.eggheadcafe.com/tutorials...in-sql-se.aspx

or an invalid procedure call on SP1!

What do you mean with this ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rhodri Richards" wrote in message ...
I have the same problem, but I've just rolled back from SP2 due to my graphs corrupting when they were saved as pdfs (as per the
issue he
http://groups.google.co.uk/group/mic...hl=en&ie=UTF-8 )

It therefore seems that to save to pdf using VBA, I can either have a corrupted file using SP2, or an invalid procedure call on
SP1!

Surely there has to be a way round this?

Thanks!



Beric Dondarrion wrote:

Cool. Office SP2 fixed it.Thanks"Ron de Bruin" wrote:
17-Nov-09

Cool. Office SP2 fixed it.

Thanks

"Ron de Bruin" wrote:

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Create Function in SQL Server
http://www.eggheadcafe.com/tutorials...in-sql-se.aspx