vba saving excel document on desktop for any user

M

maccer

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

how can I save a document on the desktop regardless the user.
So if the vba runs on another users Mac, it will be on his dektop.
I'm new to vba, sorry..
Thanks in advance!
 
C

Carl Witthoft

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

how can I save a document on the desktop regardless the user.
So if the vba runs on another users Mac, it will be on his dektop.
I'm new to vba, sorry..
Thanks in advance!

Rule Number One: NEVER EVER Use the desktop! For anything!

Further, unlike (argh, barf) Windows, there is no "all users"
Administrative-controlled Desktop "layer." Why not save the documents
to the /Users/Shared directory?
 
J

JE McGimpsey

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

how can I save a document on the desktop regardless the user.
So if the vba runs on another users Mac, it will be on his dektop.
I'm new to vba, sorry..
Thanks in advance!

One way:

Dim sPath As String

sPath = MacScript("(path to desktop folder as string)")

ThisWorkbook.SaveAs FileName:= sPath & "MyFileName.xls"
 
C

Carl Witthoft

JE McGimpsey said:
Oh for goodness sake - not everyone has to be anal retentive...

I'm not sure what being A-R
(wait, should there be a hyphen there? :) )
has to do with this. The desktop is a mess. You can't display files
in lists or any of a dozen other methods that a folder allows. There's
no functional reason to put files on the desktop -- it never is faster
to find them there than in a permanently open folder window. Leaving a
hundred icons on the desktop does slow down some operations.

Yes, I'll grant you that at least MacOS has the Desktop folder under
the User directory, unlike that disaster of a pseudo-OS (Windows). But
in these days of virtual folders and FinderPop Favorites :), the
desktop is just plain dead dead dead.
 
J

JE McGimpsey

Carl Witthoft said:
I'm not sure what being A-R
(wait, should there be a hyphen there? :) )
has to do with this. The desktop is a mess. You can't display files
in lists or any of a dozen other methods that a folder allows. There's
no functional reason to put files on the desktop -- it never is faster
to find them there than in a permanently open folder window. Leaving a
hundred icons on the desktop does slow down some operations.

Who said anything about a hundred icons on the desktop?

I'd *never* have a "permanently open folder window" - even with a 17"
MBP, I don't want to waste FAR more screen real estate than a tiny icon.
Maybe if Office and Spaces played well together I'd consider it, but not
now.

I typically have my project folder aliases on the DT so I can open them
in a heartbeat when I get a client's call. I occasionally put scratch
files there - it's easy to group them to delete them. And every once in
a while I leave a file on the DT so that I can be reminded about it when
I next sign in...

The machine's just a tool for doing work. If putting files on the DT
works for someone, I don't see a reason for the OS to drive them to
change...
 
C

Carl Witthoft

I'd *never* have a "permanently open folder window" - even with a 17"
MBP, I don't want to waste FAR more screen real estate than a tiny icon.
Maybe if Office and Spaces played well together I'd consider it, but not
now.
I must be missing something here, unless you're a neatnick :).

Who cares whether a couple folder windows are open when you're working
in Office? They're behind all your document windows, after all.

Besides, having a few open folders makes it easy to mouse over them when
selecting a Save folder via Default Folder. :)
 
J

JE McGimpsey

Carl Witthoft said:
I must be missing something here, unless you're a neatnick :).

I'm not anything like a neatnik, but you *are* missing something -
people work *differently*...
Who cares whether a couple folder windows are open when you're working
in Office? They're behind all your document windows, after all.

I don't *want* to have to figure out which Finder window I'm in or hide
Office to get to my projects - that's too many steps and I'd have to
*look*. I just want to CMD-Tab to Finder, type the first two or three
letters of my project or file and CMD-o. Takes less than a second.

Other ways to do that? sure, but none are inherently *better*.

Besides, having a few open folders makes it easy to mouse over them when
selecting a Save folder via Default Folder. :)

I have no doubt your system works well for you. But I've found that
being dogmatic about how one arranges one's workflow doesn't really work
well, and making blanket pronouncements about how one *should* arrange
one's workspace is silly. I know people who've been using Office for 20
years who still don't use keyboard shortcuts. It's ludicrous to me, but
it's efficient enough for them and trying to change now would *reduce*
their productivity.

Might some other way be more efficient? Of course. I *could* use Default
Folder, but then I'd have had to put up with the bugs and glitches it's
had over the versions that caused me to trash it in the first place.

YMMV.
 
C

Carl Witthoft

Well,
we will have to agree to disagree :)

I fully agree that most people never learn even the simplest techniques
to smooth their workflow. Look at all the folks who still do things
like clicking into windows login boxes, click-dragging to hilite the
existing name, hitting Delete, then typing their name in.

Yeah, the choice of Finder windows depends on just how many different
files (and folders) you may want quick access to. My case seems to be a
lot more than yours, and so it goes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top