Royal Presence
Board Regular
- Joined
- Feb 27, 2003
- Messages
- 92
Hello everyone,
The board has been very generous in offering tips and suggestions to me. Most recently, some formulas were supplied for me to assist in a project. I successfully applied such and then I thought I was brave enough for macros. I actually made a few and they worked, of course I have new questions.
1st- what is best practice- would it be writing the VBA or doing a macro? I really don't know much about either, so figure I will take some classes.
2nd- In the development and learning curve of my new macro, I found out that changes to the original data were made, after we ran our report. Based on production issues, we don't want this to happen. First action is to notify anyone involved to not add data after a certain cutoff. But, second action might be to figure out how to incorporate this perhaps at midday on this weekly run. The report is to be run on a weekly basis and serves as production capacity. If re-run mid day, I would see these changes, but if not, the data is there, but I don't see it, because I haven't looked. If I have to go the second route, how do I go about rerecording the macro, or is best to incorporate solid code that I should learn. This particular report will be essential and we test drove it today, finding the above issue of change.
3rd- I really don't want to increase file sizes incredibly, so think I may need to know the most efficient way to keep the data clean and running smoothly.
Any ideas to any of the above?
The board has been very generous in offering tips and suggestions to me. Most recently, some formulas were supplied for me to assist in a project. I successfully applied such and then I thought I was brave enough for macros. I actually made a few and they worked, of course I have new questions.
1st- what is best practice- would it be writing the VBA or doing a macro? I really don't know much about either, so figure I will take some classes.
2nd- In the development and learning curve of my new macro, I found out that changes to the original data were made, after we ran our report. Based on production issues, we don't want this to happen. First action is to notify anyone involved to not add data after a certain cutoff. But, second action might be to figure out how to incorporate this perhaps at midday on this weekly run. The report is to be run on a weekly basis and serves as production capacity. If re-run mid day, I would see these changes, but if not, the data is there, but I don't see it, because I haven't looked. If I have to go the second route, how do I go about rerecording the macro, or is best to incorporate solid code that I should learn. This particular report will be essential and we test drove it today, finding the above issue of change.
3rd- I really don't want to increase file sizes incredibly, so think I may need to know the most efficient way to keep the data clean and running smoothly.
Any ideas to any of the above?
