Re: microsoft /mac compatib

[Robert Howells]

On 19/04/2009, at 11:56 AM, Martin Sulkowski wrote:


Hi Phillip

What are VBA and Macros  and what do they do? And is Office X before  
office Office 2004?




Martin ,

I believe that Office X was the first version of office made for OSX
and comes before Office 2001
and also Office 2004

If you have any of those versions
Start Excel and then go to it's help,  excel help
look for and click on the a-Z
select M
and find all the info on Macro's .


Similarly find V for VBA description


Macros
If you perform a task repeatedly, you can automate the task by using a  
macro. A macro is a series of commands and instructions that you group  
together as a single command to accomplish a task automatically.  
Instead of manually performing a series of time-consuming, repetitive  
actions, you can create and run a single macro — in effect, a custom  
command — that accomplishes the task for you.



Bob




I use Excel v.11.5.4 2004 for Mac

Thanks Martin
On 19/04/2009, at 9:30 AM, Philippe Chaperon wrote:


Hi Martin,

For many years I have been designing Excel spreadsheets on my
Macintosh for use on the work PCs, and never had any problems. Mind
you I had been using mainly Office X and on rare occasions Office
2004, but I understand that the latest version of Excel does not
support VBA and Macros. Hence my suggestion would be to use an older
version of Office for Mac which support VBA and Macros, if you use
them extensively in your spreadsheets. If not I cannot see any
problem.

I am sure others on the forum will help with more up to date  
information.


Have a nice Sunday,

--
J Philippe Chaperon
Perth, Australie Occidentale


2009/4/19 Martin Sulkowski :

Hi everyone

This is properbly  a trivial question , however :

At the moment I 'm travelling quite frequently to Perth and would  
like to

continue some officework up there.

The main software I would be working on is officetime ( a  
timetracking

software)  and excel.

Unfortunately I can't  justify a nice macbook ( maybe it is  
justifiable
because they last longer )..however is it possible to move  
files in

excel between mac and windows without

a problem?

If I would buy a windows notebook any recommendations on which  
brand and how

much to pay for it or has anyone a 2nd hand macbook for sale?

grateful for any suggestions

-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Re: Apple Remote Desktop alternative ?

[Stuart Evans]

Hi Steven,

Microsoft Remote Desktop Client for Mac will remotely connect to any windows
computer with remote control services enabled. Windows servers run Terminal
Server services that enable you to connect remotely. All you need to know is
the remote clients IP Address (eg 202.43.45.72), or if it has a DNS host
name then via it's hostname (myserver.mydomain.com.au). You don't need SSH
unless the remote site has set this up for security reasons. The other issue
you might have is if the site redirects RDP traffic. RDP traffic uses TCP
Port 3389 and because it is an easy way to get onto a server, we always use
a different port and redirect it to 3389. These are details you should be
able to get from your host company. (ie IP address, port number, and user
details to login)

Also go to the RDP preferences before you connect. There are a number of
useful items such as the login (username/password/domain), screen resolution
(set to lower if your link is slow), sound (turn off!), printers and even if
your drives are accessible when you connect (useful for copying files). Some
of these may be blocked by security on the server. Once you have your
settings you can save this for future use. Do Save As...

If you do need SSH client - try this one
http://www.grepsoft.net/jellyfissh.html


Regards,
Stuart

On 18/04/09 5:00 AM, "WAMUG Mailing List"  wrote:

> Subject: Re: Apple Remote Desktop alternative ?
> Date: Fri, 17 Apr 2009 10:46:59 +0400
> References:  
> X-Mailer: Apple Mail (2.930.3)
> 
> Thanks Rob.
> 
> I installed RDC, and the first thing that comes up when I launch the
> application is a request for the name of a computer (giving examples
> MyPC, name.microsoft.com, IP number).
> 
> Upon asking the question of a windows user what I might put in here,
> the answer was "You can't connect until you succesfully make an SSH
> tunnel connection".
> 
> What bit of software or what procedure do I need follow on a Mac to
> "make an SSH tunnel connection" ?
> 
> Cheers, Steven
> 




-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Re: microsoft /mac compatib

[Martin Sulkowski]

Hi Phillip

What are VBA and Macros  and what do they do? And is Office X before  
office Office 2004?


I use Excel v.11.5.4 2004 for Mac

Thanks Martin
On 19/04/2009, at 9:30 AM, Philippe Chaperon wrote:


Hi Martin,

For many years I have been designing Excel spreadsheets on my
Macintosh for use on the work PCs, and never had any problems. Mind
you I had been using mainly Office X and on rare occasions Office
2004, but I understand that the latest version of Excel does not
support VBA and Macros. Hence my suggestion would be to use an older
version of Office for Mac which support VBA and Macros, if you use
them extensively in your spreadsheets. If not I cannot see any
problem.

I am sure others on the forum will help with more up to date  
information.


Have a nice Sunday,

--
J Philippe Chaperon
Perth, Australie Occidentale


2009/4/19 Martin Sulkowski :

Hi everyone

This is properbly  a trivial question , however :

At the moment I 'm travelling quite frequently to Perth and would  
like to

continue some officework up there.

The main software I would be working on is officetime ( a  
timetracking

software)  and excel.

Unfortunately I can't  justify a nice macbook ( maybe it is  
justifiable
because they last longer )..however is it possible to move  
files in

excel between mac and windows without

a problem?

If I would buy a windows notebook any recommendations on which  
brand and how

much to pay for it or has anyone a 2nd hand macbook for sale?

grateful for any suggestions

-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Re: iiNet Belkin VOIP Router

[Lloyd White]

Slightly off topic but still on filters. My fax machine started playing up
and the problem was found to be the filters. According to Brother these
filters do deteriorate with time.

Lloyd 




> Hi David --
> 
> -- We had many problems with the white Belkin VOIP router, which
> persisted until we changed all phone filters to Jackson C10s. Details
> at end. This may not be your problem, might be worth a look, though.
> 
> Cheers -
> 
> David Noel
> 2009 Apr 18
> 
> 
> ==
> 
> From: David MoyleTo: 
> 'WAMUG Mailing List' 
> iiNet Belkin VOIP Router
> Date:Fri Apr 17 18:51
> 
> Hey
> 
> 
> Since we are talking about this hoping someone can help me! My house
> mate has an iiNet Belkin VOIP Router (white) and the wireless drops
> out constantly. We've updated the firmware which was meant to resolve
> the issue but it hasn't.
> 
> 
> Does anyone experience similar issues and maybe found a resolution?
> 
> 
> Thanks,
> ==
> 
> -- Users of iiNet ADSL2+ services be interested in a recently-solved
> problem with recurring dropouts of the service.
> 
> -- I use an iiNet-supplied white Belkin wireless router with the
> ADSL2+ sharing a line with two phones. One phone is equipped with a
> Belkin ADSL2+ filter, and following some noise problems a year or so
> ago I got a second Belkin filter to replace a Tandy ADSL2+ filter on
> the second phone.
> 
> -- Starting a couple of months or so ago, we noticed many temporary
> dropouts occurring in accessing the Internet. Symptoms were that, in
> accessing a web page or downloading a web file, access by any of our
> computers slowed right down or timed out. After five minutes or so,
> normal access would be restored without any action on our part.
> 
> -- I contacted iiNet for advice, they suggested the problem could be
> in the phone line, the router, or the phone filters. On the Belkin
> router you can check the line status by entering
> http://10.1.1.1/status.stm, and checks showed that during these
> dropouts the line was physically connected but not active, also our
> VoiP phone connection came up as 'not succeeded'.
> 
> -- On periodically refreshing the Belkin status page, after so many
> minutes it would come up with 'Connected', and service was back to
> normal. Then my son noticed that dropouts seemed to occur when either
> of the two standard phones had been active, incoming or outgoing.
> 
> -- I contacted iiNet Support again with this information, they
> suggested replacing the phone filters with Jackson  C10 ADSL in-line
> filter/splitters, obtainable from Dick Smith. I contacted various Dick
> Smith branches, also the local Tandy store, all appeared to offer only
> their own in-house brands and not Jackson equipment.
> 
> -- Googling the problem for Australia gave responses suggesting that
> Jackson C10 filters could be got from Officeworks. I phoned their
> Subiaco store, who did not carry the filters, then their Osborne Park
> store, where they said they did have them. However when I drove to
> Osborne Park a sales  assistant said they were out of stock. The
> assistant was able to look up stocks of these Jackson C10 filters at
> the 8 or 10 Perth branches of Officeworks, and found 3 stores which
> had stock, with 13 listed for Morley and 3 or 4 at two other branches.
> 
> -- Drove to Morley and bought 2 of the 3 they had on available at
> $27.95 each. Installing these appears to have solved the dropout
> problem. This saga does highlight the point that one ADSL2+ filter may
> not be as good as another, and possibly, in view of the experience
> that the problem appeared to have started and grown over recent
> months, that these filters might deteriorate or not cope with unseen
> changes in line conditions. Maybe this information may help others
> with similar problems.
> 
> David Noel
> 2008 May 23



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Re: microsoft /mac compatib

[Philippe Chaperon]

Hi Martin,

For many years I have been designing Excel spreadsheets on my
Macintosh for use on the work PCs, and never had any problems. Mind
you I had been using mainly Office X and on rare occasions Office
2004, but I understand that the latest version of Excel does not
support VBA and Macros. Hence my suggestion would be to use an older
version of Office for Mac which support VBA and Macros, if you use
them extensively in your spreadsheets. If not I cannot see any
problem.

I am sure others on the forum will help with more up to date information.

Have a nice Sunday,

-- 
J Philippe Chaperon
Perth, Australie Occidentale


2009/4/19 Martin Sulkowski :
> Hi everyone
>
> This is properbly  a trivial question , however :
>
> At the moment I 'm travelling quite frequently to Perth and would like to
> continue some officework up there.
>
> The main software I would be working on is officetime ( a timetracking
> software)  and excel.
>
> Unfortunately I can't  justify a nice macbook ( maybe it is justifiable
> because they last longer )..however is it possible to move files in
> excel between mac and windows without
>
> a problem?
>
> If I would buy a windows notebook any recommendations on which brand and how
> much to pay for it or has anyone a 2nd hand macbook for sale?
>
> grateful for any suggestions
>
> -- The WA Macintosh User Group Mailing List --
> Archives - 
> Guidelines - 
> Unsubscribe - 
>

-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

microsoft /mac compatib

[Martin Sulkowski]

Hi everyone

This is properbly  a trivial question , however :

At the moment I 'm travelling quite frequently to Perth and would  
like to continue some officework up there.


The main software I would be working on is officetime ( a  
timetracking software)  and excel.


Unfortunately I can't  justify a nice macbook ( maybe it is  
justifiable because they last longer )..however is it possible to  
move files in excel between mac and windows without


a problem?

If I would buy a windows notebook any recommendations on which brand  
and how much to pay for it or has anyone a 2nd hand macbook for sale?


grateful for any suggestions

-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Re: MS Word 2004 question - anchoring reference to numbered list

[Steven Knowles]

Terrific Adrian - precisely what I was looking for! Not perfect  
because the references don't update themselves in real time, but a  
manual update isn't hard.


Many thanks, Steven

On 18/04/2009, at 5:13 AM, Adrian Skehan wrote:


Hi Steven,

Its a long time since I did this so you may need to do some  
experimenting.  What you do is insert a Cross-Reference in the  
paragraph where  the reference to a paragraph number is used, to do  
this, have the cursor at the reference point, in the main menu go to  
"Insert" > "Cross-Reference" listed there you will see the numbered  
paragraphs, select the desired reference.


As required go to the main menu go to "Edit" > "Links" and select  
the link and "Update Now"


Assuming you are using the Bullets & Numbering/Styles Format it  
should work.  Good luck with it, it use to drive me mad.



Regards,

Adrian
adrianske...@me.com



On 17/04/2009, at 11:41 PM, Steven Knowles wrote:

I've created a Word (2004) document which has numerous clauses, and  
sub-clauses within those clauses, using a numbered list.


Example ...

1.

2.
2.1
2.2.
  2.1.1
  2.1.2

3.


If I insert a clause immediately after clause 1, then of course  
clause 2 is going to automatically change to clause 3.


If however, elsewhere in the document, I have made reference to,  
say, clause 2.1.2 (which subsequently changes to clause 3.1.2),  
then that reference to clause 2.1.2 is going to be wrong.


Is there a way I can somehow anchor a reference to a particular  
clause to the clause number itself? So that if the clause number  
changes, then any reference to that clause throughout the document  
automatically updates? There's probably a term for it but I have no  
idea what it might be.


If Word 2004 doesn't do it, does Word 2008 do it?

Cheers, Steven


-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Re: Nagging Excel & Word

[Neil Houghton]

Hi Ronni,

Hehe... I'm not really a fan of MS in general either!

Unfortunately I do a lot of work in Excel and have quite some time invested
in various spreadsheets with macros etc (which is why I won't be upgrading
to Office 2008). Also I guess I have years of experience with Excel and
actually quite like the program.

When it gets to the stage that Office 2004 won't play with the latest OSX I
guess I'll have to rethink - but by then Numbers might be sufficiently
advanced or MS might have gone back to supporting macros...

The problem isn't with outward connections anyway... MS seems to make OSX
keep prompting me to allow incoming connections - even when I've already
told it to block Excel & Word.

No worries really, everything still works just fine - I just find it
annoying when it keeps asking me and I've already told it once!!


It would still be good to know (from anybody who uses Excel a lot) whether
this is standard behaviour or if it is some setting I've missed.


Cheers



Neil
-- 
Neil R. Houghton
Albany, Western Australia
Tel: +61 8 9841 6063
Email: n...@possumology.com



on 17/4/09 8:29 PM, Ronda Brown at ro...@wn.com.au wrote:

> Hi Neil,
> 
> I don't know what to suggest, I don't use Microsoft Office, I try not
> to use anything Microsoft ;-)
> 
> Do you have "Enable Stealth Mode" activated in "Advanced"?
> 
> The Leopard application firewall also only blocks inbound connections;
> it won¹t prevent programs
> from making outbound connections.
> 
> Cheers,
> Ronni
> 
> On 17/04/2009, at 8:13 PM, Neil Houghton wrote:
> 
>> Hi Ronni,
>> 
>> No, there is a little application called Microsoft AutoUpdate which
>> takes
>> care of all the applications in the Office package - but I have it
>> set to
>> check manually to avoid this sort of thing :(
>> 
>> Cheers
>> 
>> 
>> Neil
>> -- 
>> Neil R. Houghton
>> Albany, Western Australia
>> Tel: +61 8 9841 6063
>> Email: n...@possumology.com
>> 
>> 
>> on 17/4/09 7:41 PM, Ronda Brown at ro...@wn.com.au wrote:
>> 
>>> Hello Neil,
>>> 
>>> On 17/04/2009, at 2:39 PM, Neil Houghton wrote:
 
 So, a couple of queries:
 
 1) Is this just normal behaviour (ie normal MS annoying feature) -
 do other
 users find this happens for them (assuming you have the firewall set
 to
 block incoming connections for Excel & Word).
>>> 
>>> Perhaps all Microsoft Products (Entourage, Excel, Word, etc) check
>>> for
>>> updates when you launch the application.
>>> Therefore they need access to the Internet.
>>> 
 
 2) Is there anything else to set (preferences anywhere?) so that
 once the
 firewall is set to block it just accepts that and doesn't keep
 trying to
 change my mind!!
>>> 
>>> Have you checked the Preferences of both Excel & Word to see if you
>>> have "check for Updates" enabled?
>>> 
>>> Cheers,
>>> Ronni
>> 



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Images in Power Point

[Severin Crisp]

I find that images imported into PowerPoint Office 2008) undergo  
significant colour shifts and require retweaking within PowerPoint.  I  
presume that this is a built in Microsoft distorting profile but can  
not track down information.

Can anyone help.
Severin Crisp

   Assoc Professor R Severin Crisp, FIP, CPhys, FAIP
   15 Thomas St, Mount Clarence, Albany, 6330, Western Australia.
Phone  (08) 9842 1950   (Int'l +61 8 9842 1950)
email  mailto:sevcr...@westnet.com.au




-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe - 

Re: iiNet Belkin VOIP Router

[David Noel]

Hi David --

-- We had many problems with the white Belkin VOIP router, which
persisted until we changed all phone filters to Jackson C10s. Details
at end. This may not be your problem, might be worth a look, though.

Cheers -

David Noel
2009 Apr 18


==

From:   David MoyleTo: 
'WAMUG Mailing List' 
iiNet Belkin VOIP Router
Date:   Fri Apr 17 18:51

Hey


Since we are talking about this hoping someone can help me! My house
mate has an iiNet Belkin VOIP Router (white) and the wireless drops
out constantly. We've updated the firmware which was meant to resolve
the issue but it hasn't.


Does anyone experience similar issues and maybe found a resolution?


Thanks,
==

-- Users of iiNet ADSL2+ services be interested in a recently-solved
problem with recurring dropouts of the service.

-- I use an iiNet-supplied white Belkin wireless router with the
ADSL2+ sharing a line with two phones. One phone is equipped with a
Belkin ADSL2+ filter, and following some noise problems a year or so
ago I got a second Belkin filter to replace a Tandy ADSL2+ filter on
the second phone.

-- Starting a couple of months or so ago, we noticed many temporary
dropouts occurring in accessing the Internet. Symptoms were that, in
accessing a web page or downloading a web file, access by any of our
computers slowed right down or timed out. After five minutes or so,
normal access would be restored without any action on our part.

-- I contacted iiNet for advice, they suggested the problem could be
in the phone line, the router, or the phone filters. On the Belkin
router you can check the line status by entering
http://10.1.1.1/status.stm, and checks showed that during these
dropouts the line was physically connected but not active, also our
VoiP phone connection came up as 'not succeeded'.

-- On periodically refreshing the Belkin status page, after so many
minutes it would come up with 'Connected', and service was back to
normal. Then my son noticed that dropouts seemed to occur when either
of the two standard phones had been active, incoming or outgoing.

-- I contacted iiNet Support again with this information, they
suggested replacing the phone filters with Jackson  C10 ADSL in-line
filter/splitters, obtainable from Dick Smith. I contacted various Dick
Smith branches, also the local Tandy store, all appeared to offer only
their own in-house brands and not Jackson equipment.

-- Googling the problem for Australia gave responses suggesting that
Jackson C10 filters could be got from Officeworks. I phoned their
Subiaco store, who did not carry the filters, then their Osborne Park
store, where they said they did have them. However when I drove to
Osborne Park a sales  assistant said they were out of stock. The
assistant was able to look up stocks of these Jackson C10 filters at
the 8 or 10 Perth branches of Officeworks, and found 3 stores which
had stock, with 13 listed for Morley and 3 or 4 at two other branches.

-- Drove to Morley and bought 2 of the 3 they had on available at
$27.95 each. Installing these appears to have solved the dropout
problem. This saga does highlight the point that one ADSL2+ filter may
not be as good as another, and possibly, in view of the experience
that the problem appeared to have started and grown over recent
months, that these filters might deteriorate or not cope with unseen
changes in line conditions. Maybe this information may help others
with similar problems.

David Noel
2008 May 23

-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe -