I guess I forgot to ask one extra question: is there an easy way to have the macro to simply look for open reports and apply the macro to them if any is there available to receive it, regardless of its name? I mean to add flexibility to the macro by removing the hard-coded name of the report it is applied to. Would you light my lantern on those ones? (I'm a firm believer in explicit variable declaration). I could easily figure out that "i" could be declared as an integer, but I was a little more challenged when trying to figure out the exact type of data "ocontroller", "oreportdoc", "oTexttable", "orows" & "orow" were. You haven't declared any of your variables.Is there a way to automatically run the macro when the report is generated?.Since I grouped one of the fields in the report, I had to slightly modify the macro in order for it to run over every other table. You can also copy the entire row and 'paste special' (Ctrl+Shift+V) selecting the option to shift the cells down I just didnt find a way to insert many rows at once with the data. Hi F3K Total, and thanks for this helpful trick. Select the entire row (clicking on the row number), hold Ctrl+Alt and drag the row to the line below.
0 kommentar(er)
