Search results

One other thing...now that I've decided to do it the way you suggested... what's the easiest way to send them the macros AND have it show up on a menu everytime they bring up excel? I know how to create menus but I seem to be having trouble attaching them. I want all users to have an extra menu...

Thanks for the suggestion. That seems like the most "foolproof" way of doing it. Maybe I can send the macro workbook with a macro to save it (I can imagine getting all kinds of questions on where to save it, what to call it, even if I spell it out--you know the drill). I'm going to try that and...

I am going crazy re this. I have reports that come off our system unformatted, and launch a new excel session with the data in .txt format. Needs to be parsed/formatted, etc. before printing. I have created macros that I use to automate this; other than running everyone's reports for them, what...

It worked! Thank you, thank you! :0

Not exactly sound It's not calculating correctly...most are showing the month correct for the next year but the year is mostly 03. This is probably what you meant by the "01" which I misinterpreted to be the YEAR... I'm going to go with what you have and see how it turns out. Thanks! It's...

Thanks...I figured it out a slightly different way. Here's what I did (probably lengthy, but works): --LotDate--(to convert 4#s to text with"/": Left([WhseJobInfo]![DDIJobID],2) & "/" & Mid([WhseJobInfo]![DDIJobID],3,2) --InvDate--to display lot date plus one yr) DateAdd("d",365,[LotDate])...

Here's what I've got: --a code for the "lot" of a product Ex: 0501-0061.xxxxxxxx (date is 1st 4 char) --the products mature in 12 months. So in a report for the example above I need to show 5/02... What is the best way to do this? I've done a Left function to extract as 0501...but how do I...