View Full Version : Help with Excel and Macros

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?