Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Works on one computer, but not another
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulaed cell response varies from computer to computer | Excel Discussion (Misc queries) | |||
New Computer HPVAL no longer works | Excel Worksheet Functions | |||
How do I open a floppy from a Works file in Excel on new computer | New Users to Excel | |||
How do I copy all Excel files from old computer to new computer? | Excel Discussion (Misc queries) | |||
Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) |