Re: Excel change by 1 month
Re: Excel change by 1 month
- Subject: Re: Excel change by 1 month
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 14 Dec 2008 13:31:11 -0800
- Thread-topic: Excel change by 1 month
On 12/14/08 11:10 AM, "Mail" <email@hidden> wrote:
> I have just upgraded to Office 2008 and rewriting my marco's in
> Applescript because Office now doesn't support VBA anymore. I want to
> change dates in my expenses to the next month. I was using the below
> macro.
>
> Sub NextMonth()
> Dim i As Integer
>
> For i = 3 to 21
> Sheets("Expenses").Range("A" & i) = dateadd("m", 1,
> sheets("Expenses").Range("A" & i))
>
> End Sub
>
> Can anyone help with this.
>
> Also if I want to put a line in to describe what the Script is doing
> at at any point, how do I have to start it.
As I no longer have access to Excel VBA in 2004 or earlier, I'm wondering if
that 'dateadd' function was a built-in VBA Method (I really don't think so)
or was calling another function in your macro module named "DateAdd()".
Check your full macro. If you see a DateAdd() tell us what the code for it
is. In fact, best just transcribe the code for the entire module, as there
may be more dependencies (other subsidiary subroutines).
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden