I have a macro with the following code:
The macro prompts the user to save the file to computer. When the OK button is clicked, it presents the "Invalid Procedure Call Or Argument" error message. I believe this has something to do with the specific computer. This code works on other systems (deployed this code to 10 different machines and this is the only one with this issue).
Please Login or Register to view this content.
Any ideas?
Which line is giving you the error? Saving as a PDF uses an AddIn, do all computers have the AddIn installed?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
They all use Excel 2007. I believe that functionality is built into it somehow.
It doesn't show which line is giving the error either. It just errors out right after clicking OK on the save dialog box
That functionality is built in if you have SP2 installed, but if not, it requires an addin.
Remember what the dormouse said
Feed your head
XP Machine running SP3. It does have the .Net applications installed as well.
I mean Office 2007 SP2, not a windows service pack. .Net components are irrelevant here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks