|
09-19-2008, 02:28 PM
|
#1 |
|
Reds Slacker '07
Join Date: May 2004
Posts: 3,783
|
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" 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
__________________
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! Jockstocks Homepage Do you have your shirt on? - Adam Dunn to Marty on the Bananna Phone. |
|
|
 |
| Thread Tools | |
| Display Modes | |
|
|
|
Board Moderators may, at their discretion and judgment, delete and/or edit any messages that violate any of the following guidelines: 1. Explicit references to alleged illegal or unlawful acts. 2. Graphic sexual descriptions. 3. Racial or ethnic slurs. 4. Use of edgy language (including masked profanity). 5. Direct personal attacks, flames, fights, trolling, baiting, name-calling, general nuisance, excessive player criticism or anything along those lines. 6. Posting spam. 7. Each person may have only one user account. It is fine to be critical here - that's what this board is for. But let's not beat a subject or a player to death, please. |
Linear Mode
