RedsMan3203
09-19-2008, 02:28 PM
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"
End Sub
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?
Thanks,
Nick
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"
End Sub
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?
Thanks,
Nick