Thread: [Solved] CommandButton, 3 PCs with 3 different office(s)
View Single Post
 
Old 12-13-2015, 05:31 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,355
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The main problem is that your IGeL-Buch 2016.xls file has nearly 2000 links to the IGeL-Buch 2016.xlsm file, on the 'Preise & Auswertung' sheet. Consequently it is trying to retrieve the data from the 'Dateneingabe' sheet on the IGeL-Buch 2016.xlsm file instead of from its own 'Dateneingabe' sheet. Fix that and your command button should work. You can do that by using Find/Replace to delete the IGeL-Buch 2016.xlsm file's path and name from the formulae on the 'Preise & Auswertung' sheet.

I don't know what macro support OpenOffice has but, whatever it is, it is unlikely to support Excel macros and neither would OpenOffice macros be likely to work in MS Office.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote