While I know there is an answer that would make microsoft happy (upgrade all 2-300 users of office 2003 to 2007 ) I'm wondering of the is a way in scheduler to save an xlsx (or xlsm) sheet as xls
We have reports that are emailed roughly every two weeks to those users and unfortunately the Sheets are designed to run with a lot of the 2007 functionality that 2003 didn't have. Then it gets tricky in that a 40 sheet workbook gets emailed to multiple people in different selections. A manager sees the sheet for his property only District manager 5 or 6 and Regional as many as 15 . ( Bottom line html option in scheduler isn't an option) .
The user generating the reports has been opening them in the output folder and then saving as 2003 format but it would make everyones live easier if there is/was a way inside scheduler to do a save as other file type then what the workbook is ( This might be more of nice to have but I'm hoping someone has tackled this one and won <S>
Date
Votes
2 comments
-
Jet Reports Historic Posts My question, you say they have been designed with 2007 functionality, but if you save them as 2003 that will get lost. So then why bother using 2007 functions?
Regardless, I have two suggestions:
1) Write a macro that does the saving thing automatically
- Call the macro auto_open (or whever the correct name is) so it runs when the sheet is open
- Have the code check if its in your 'output' directory.
- If so, run the code to re-save as .xls
- Have it auto-exit when done
- Create a seperate scheduled task that just runs the sheet from the output directory.
- Not sure if you'll be able to automate the email bit though.
2) Install the compatibility pack on users machines. It allows 2007 documents to be opened in 2003. We have been running it here for a while with only good results.
http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
Good luck! -
Jet Reports Historic Posts The 2007 functionality makes it easier for users here ( date stuff mostly) and since the recepients do not have access ot navision for drilldowns etc what they get is only the results non of the formula's etc .
The macro idea may well work but past experience with macros and excel security has led us to avoid them.
I'll have to check and see whether the support team(s) for remote sites tried the compatibility pack I thought they had tried this and had problems ( possibly because users tend to open the reports in email) but wouldn't hurt to check
Still if Jet can produce a way to save reports out of scheduler in std formats other than excel I think it would be a usefull feature ( .doc pdf csv etc)
Van
Please sign in to leave a comment.