I have a macro in a WB that has been working for years. Even when i moved to
XL2007, it worked fine, until i saved as xlsm. It will not work when the
book is saved as xlsm (so, my workaround is to keep using the xls version).

Here is the line that gives the error:
pt(1).PivotFields("Acct").CurrentPage = "Moe"

The error is "invalid procedure call or argument".

Any thoughts or ideas? How to fix/work around? Would be nice to save as
xlsm, since XL autrecovery saves are soooo slow with XLS for a fairly large
workbook.

Thanks, tom

--
Message posted via http://www.officekb.com

Is the error number 5?, do you have the pivot table name and sheets
names correct with no trailing spaces!

TomCon via OfficeKB.com;308307 Wrote:
I have a macro in a WB that has been working for years. Even when i
moved to
XL2007, it worked fine, until i saved as xlsm. It will not work when
the
book is saved as xlsm (so, my workaround is to keep using the xls
version).

Here is the line that gives the error:
pt(1).PivotFields("Acct").CurrentPage = "Moe"

The error is "invalid procedure call or argument".

Any thoughts or ideas? How to fix/work around? Would be nice to save as
xlsm, since XL autrecovery saves are soooo slow with XLS for a fairly
large
workbook.

Thanks, tom

--
Message posted via 'MS Office forums. More than 400,000 of Word, Excel,
Outlook, PowerPoint, Publisher, InfoPath discussions.'
(http://www.officekb.com)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86193

Yes, it is error #5! But, i don't think that there are any trailing spaces.
And, the macro works perfectly well when it is saved as xls. Only if it is
saved as xlsm, that the error occurs.

Can you tell me any more, or give any further tips?

Thanks
tom

Simon Lloyd wrote:
Is the error number 5?, do you have the pivot table name and sheets
names correct with no trailing spaces!

TomCon via OfficeKB.com;308307 Wrote:
I have a macro in a WB that has been working for years. Even when i
moved to
[quoted text clipped - 19 lines]
Outlook, PowerPoint, Publisher, InfoPath discussions.'
(http://www.officekb.com)


--
Message posted via http://www.officekb.com

On Apr 15, 12:12*am, "TomCon via OfficeKB.com" <u50688@uwe wrote:
I have a macro in a WB that has been working for years. *Even when i moved to
XL2007, it worked fine, until i saved as xlsm. *It will not work when the
book is saved as xlsm (so, my workaround is to keep using the xls version).

Here is the line that gives the error:
pt(1).PivotFields("Acct").CurrentPage = "Moe"

The error is "invalid procedure call or argument".

Any thoughts or ideas? *How to fix/work around? *Would be nice to save as
xlsm, since XL autrecovery saves are soooo slow with XLS for a fairly large
workbook.

Thanks, tom

--
Message posted viahttp://www.officekb.com

Check to make sure you have the same add-in programs loaded you had
with 2003,
Also check the settings under Excel Options - make sure the save
function is set to the newer versions of excel.