infamousbarfly

Hi I'm working with a school who wanted to change their timetable for the latter part of the summer term. The timetabler has sent the timetable to SIMS more than once, and has not used the same end date every time. This has knocked out the students' class memberships so that now when looking in Curriculum Assignment by Scheme all the group lists are blank. I know that problem has stemmed from the inconsistencies in the timetable end-date, but I wondered if anyone knows of a way to restore the group memberships other than manually re-entering them all (not really an option as it is a large secondary with post 16)? Any suggestions greatly appreciated!

Hi again As far as I'm aware, I haven't used a Sheets.Select command in my code. The thing that is baffling me is that if I call my routine from before or at the beginning of FixAddressColumn I get the error, but if I call my routine from the end of FixAddressColumn, without making any changes to it whatsoever, no error appears but the formatting is wrong. This leads me to assume that the error is not in my code, however I'm happy to be told otherwise if I can eliminate the error! Can I send you my code for you to have a look at? I don't want to put you to any trouble so please feel free to say no if you don't have time. Cheers

Brilliant - thanks for this. I realised from looking through the code that a csv is produced and used as the basis for an excel sheet but I wondered if there was a specific reason for entering my macro in FixAddressColumn as I can't tell what it 'does' if you know what I mean. Having said that, what I know about vba syntax you could write on half a postage stamp so I can't tell what the majority of the AutoRun routine is doing! The reason for my question really is that I have managed to achieve 99.9% of what I want - the final 0.1% that is stumping me is that I run my report from SIMS, the excel sheet opens and looks all fine but I receive "error 1004: Method 'Select' of object 'sheets' failed" and I cannot figure out why! If I place my macro at the end of the FixAddressColumn and run the report, the error does not appear but the formatting of the table that opens (as a result of my macro) is all incorrect. I was trying to figure out the purpose of FixAddressColumn, and the effect it has on the report output, but I haven't got very far as none of it makes much sense to me. I wondered if I could remove the whole FixAddressColumn and run my macro for elsewhere in the routine?

Hi Apologies for butting in here - I found this forum post via a google search - I wonder if you could answer me a question please? I'm currently trying to get my head around using SIMS reports with excel & macros, making slow but steady progress as I've never really used macros or vba before. Could you explain the reason why I have to call up my macro from the FixAddressColumn part of AutoRun? Why does it go there and not somewhere else? Thanks Sarah