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?
|All times are GMT -4. The time now is 08:20 PM.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.