Re: newby small programmer in excel/vba
Re: newby small programmer in excel/vba
- Subject: Re: newby small programmer in excel/vba
- From: Stan Cleveland <email@hidden>
- Date: Mon, 19 Oct 2009 08:52:44 -0700
- Thread-topic: newby small programmer in excel/vba
On 10/19/09 7:02 AM, "Peter Cox" wrote:
> Hello People,
>
> I'm new here. I'm working on a apple for the first time. I noticed that the
> VBA macro's in EXCEL (office) does'nt work any more!
> Can sombody tel me how i made a button with a macro under it? And can somebody
> translate the text for me? I must learn a different language to programme in
> Appplescript. can sombody reach me a hand were on the internet can i learn
> programmin in excel in applescript
>
> Sheets("Factuur").Select
> Sheets("Factuur").Copy After:=Sheets(3)
> Sheets("Factuur (2)").Select
> Sheets("Factuur (2)").Name = ActiveSheet.Cells(24, 3).Value
> ActiveSheet.Select
> ActiveWindow.SelectedSheets.Visible = False
> Sheets("Factuur").Select
> Range("h55").Select
> ActiveCell.FormulaR1C1 = "'0" & Range("G55")
> Range("G55").Value = Range("G55").Value + 1
> Range("a23").Select
> ActiveWindow.SmallScroll Down:=13
Hi Peter,
One good resource is MacTech magazine's online reference called "Moving
from Microsoft Office VBA to AppleScript: MacTech's Guide to Making the
Transition." Additionally, they include a list of other online and published
resources for scripting Office applications.
Here's the URL to the introduction:
http://mactech.com/vba-transition-guide/index.html
FYI, I have no connection to MacTech (except as a satisfied reader).
Stan C.
_______________________________________________
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