|09-19-2008, 03:28 PM||#1|
Reds Slacker '07
Join Date: May 2004
Help with Excel and Macros
I'm creating a workbook for my work for simple inventory tracking... Its a daily and monthly update via email...
I've gotten the daily updates completed and working well...
The monthly updates have given me a fit... I'm creating a macro to handle each month...
Why? Because I'm not sure how to make the macro skip a row set each time it runs to copy/paste the information needed...
Right now I have this....
Private Sub Workbook_Open()
ChDir "C:\Documents and Settings\ssirefresh\Desktop"
Workbooks.Open Filename:= _
"C:\Documents and Settings\ssirefresh\Desktop\Outgoing Inventory FY09.xls"
Application.OnTime DateValue("2008/09/19") + TimeValue("13:52:10"), "OctMonthly08"
Application.OnTime DateValue("2008/09/19") + TimeValue("14:13:10"), "NovMonthly08"
I have them set up to run at a certain time... Well as a test I tried my logic and it failed. They both are running when the workbook loads up.
Any ideas or help on this?
You think you got what it takes to play a real fantasy game? Join me at Jockstocks. You can play Baseball, Basketball, Football, Golf, Nascar and even Hockey!
Do you have your shirt on? - Adam Dunn to Marty on the Bananna Phone.