a customer of mine has a critical problem.
He wants to import data from a variety of excelsheets into one single excel sheet via a macro.
While the file has the correct data when opened via mouseclick from the Windows Explorer, the file has different data when opened via macro. It seems that a value using the EOMONTH (or MONATSENDE in German) function (EDIT: from the analysis toolpak) isnt calculated when opened via Macro, while its calculated correctly when opened with a mouseclick.
The atpvbaen.xls in VBA is activated, so is the analysis toolpak and analysis toolpak (VBA) in Excel.
He is using an English Version on an english OS, so there shouldn't be a language problem.
Does anyone have a clue how to solve this ?
Thanks a lot,