Recent content by Jarvonimbus

Thanks PH - yes I think that would be the best way forward

Thanks bubba - nope still getting same message

It is Outlook VBA - it was originally written in Outlook2000 References selected: Visual Basic for Applications Microsoft Outlook 12.0 Object Library OLE Automation Microsoft Office 12.0 Object Library

There isn't one - that line given is the first (non-comment) line in the sub. This has worked in both Outlook2000 and Outlook2003 I can say I have tried Dim myOlApp As New Outlook.Application But this gives exactly the same outcome

I have been using Outlook VBA on a new PC which was already set-up with Office 2007. Initially, these would would run successfully. I have also used them in the past on Outlook 2000 and 2003. However, I have subsequently installed Excel2000 to run in parallel with Office2007, as our existing...

Thanks Skip. Anotherhiggins - the exchange rate isn't relevant in this case - it's a spreadsheet for completion by the user not a report. Cheers anyhows

I have a spreadsheet with many cells formatted as either currency or custom with pounds sterling as the currency. I have to re-design this for use by a site in Germany. Is there any way to change the currency easily to Euros via a setting/options change or am I going to have to re-format...

Thanks again Still no joy I'm afraid "Is there a sheet, Tick List Dealer containing PivotTable named PivotTable1?" Yes It has three page fields "Dealer", "Franchise Group" and "Year";column field "Period" and multiple data fields

Thanks Skip - see what you mean and I've applied it but I'm still getting the error. Dealer1 does contain a value that is one if the PivotItems in PivotField Dealer.

Thanks Steve I'm afraid that doesn't change the result - it still falls over when it reaches line 3

Hi There, I have a problem with some code which causes a pivot table to change. I have a page with drop-down boxes. After these are selected, I hit a button and want it to update three pivot tables which are in the workbook I get "Run-time error 1004: Unable to set the _Default property of the...

Help! I'm having exactly this problem as well - can anyone help please Cheers!

Yep - job done Much appreciated :-)

I have a pivot table which has 7 data fields, 1 row field and no column fields Now Excel puts the seven datafields as rows in the piot table e.g. Dealer Data Wilmslow Opportunities 10 Contacted 20 Missed etc etc 10 I would like to have the datafields as columns...

That's the one! Thank you very much :)