|
|
|
|
|
|
| |
| |
|
|
|
|
| |
| |
|
|
scott wrote:
>> And this stuff isn't really documented anywhere.
>
> Rubbish!
>
> Try looking up "range" or "cells" or "worksheet" in the object browser
> and reading the help.
What is the "object browser"?
> Worksheets(1).Cells(1, 1).Value = 24
>
> ActiveSheet.Cells(2, 1).Formula = "=Sum(B1:B5)"
>
> How could it be any more clear what to do?
That seems reasonably clear.
Now, if you call a macro with a cell range as its argument, how does
that work?
> Or, as Gilles said, record a
> macro and then look at the code (and the help related to the code
> generated) - a nice trick for learning how to do lots of things in Excel
> (like creating charts, changing borders, sorting etc).
I'm still at the level of not really knowing how to work the VB editor,
and not understanding basic VB syntax constructs...
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
47d7eaea$1@news.povray.org...
> Yes. But Access has an additional "macro language" that only Access uses.
> By default it seems to record macros with that.
No, you can't record a macro in Access. Recording macros is an
Excel/Word/Powerpoint thing and it (now) produces VBA code. I agree that
"macro" as a term is inconsistently used in MS Office (a legacy issue I
guess).
G.
--
*****************************
http://www.oyonale.com
*****************************
- Graphic experiments
- POV-Ray, Cinema 4D and Poser computer images
- Posters
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
> I'm still at the level of not really knowing how to work the VB editor,
> and not understanding basic VB syntax constructs...
RTFM? It is all explained...
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Nicolas Alvarez wrote:
> RTFM? It is all explained...
Manual? Chance would be a fine thing!
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
> What is the "object browser"?
Right click in the code view and choose "Object Browser". It basically
shows every "object" available, and what its members are. Help is available
for every item.
> Now, if you call a macro with a cell range as its argument, how does that
> work?
I don't have any experience with that, but I assume that the range would
just be placed into a variable, just like if you passed a number or
individual cell etc. Look up "range" in the object browser and you'll see
its member functions to work with it.
> I'm still at the level of not really knowing how to work the VB editor,
> and not understanding basic VB syntax constructs...
Get a book? Read a tutorial online? Trial and error?
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
scott wrote:
> Get a book?
I think if I ever need to do this for real, that would be the only
viable option...
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Gilles Tran wrote:
>
> I don't understand what you're saying... The entire Office suite uses VBA.
> Actually that's one big selling point of Office (for businesses): one can
> automate all the Office applications using the same language and have them
> interact with each other.
And that's a darn good thing. I've avoided tens or even hundreds of
hours of clicking around spreadsheets with VBA in past 5 years.
What comes for the missing pre-defined functions, I haven't found an
"explode" -function so far, so I did need to code one. It wasn't hard -
macro recorder and surfing the internet told me everything I needed.
> G.
>
--
Eero "Aero" Ahonen
http://www.zbxt.net
aer### [at] removethiszbxtnetinvalid
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Invisible wrote:
>>> in VBA you'd have to write an explicit FOR loop
>>
>> Not in Excel. What are you smoking? :-)
>
> Really? Care to explain that one?
Yeah. I don't need a loop to call SUM(A1:A10) either. :-)
--
Darren New / San Diego, CA, USA (PST)
"That's pretty. Where's that?"
"It's the Age of Channelwood."
"We should go there on vacation some time."
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Invisible wrote:
> And this stuff isn't really documented anywhere.
Are you familiar with msdn.microsoft.com, the complete documentation for
everything you program on Windows that comes from Microsoft?
--
Darren New / San Diego, CA, USA (PST)
"That's pretty. Where's that?"
"It's the Age of Channelwood."
"We should go there on vacation some time."
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
>> And this stuff isn't really documented anywhere.
>
> Are you familiar with msdn.microsoft.com, the complete documentation for
> everything you program on Windows that comes from Microsoft?
No. I'm aware it documents the really low-level Win32 API stuff that
only C programmers understand. I wasn't aware it contains anything
useful to normal people...
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |