Is there a way in VBA to determine whether or not a given Jet Report was saved in Design or Report mode? We have a boatload of Jet Reports and I don't want to have to open them all up manually and look at them to determine how they were last saved. Is there any way to programatically kick a report into DesignMode outside of using the Ribbon? Thanks...
Date
Votes
3 comments
-
Heather Rowe It seems the simplest way to do this might be to use VBA to review the files - look to see if column A is hidden or not. If it's hidden, then you know the file is saved in report mode.
Probably some code like this: Range(“A1”).EntireColumn.Hidden, if that returns true column1 is hidden.
-
j2associates Hello Heather,
Duh, that is so simple it is almost embarrassing. Thanks for the quick and timely response.
-
Heather Rowe Never be embarrassed - I know I've been faced with more than a few 'duh' moments in my Excel/VBA travels....
glad I could help :)
Please sign in to leave a comment.