Calling a File in VBA

I don't really have the answer apart from reminding you that OSX is case sensitive?

Sorry, that's the best I can come up with.

Cheers.

 

Try to keep in mind: you're asking for Windows programming help on a Mac forum.

I don't know VB, but I will take a stab. Try putting a slash before "Macintosh HD" like so:

Open("/Macintosh HD/<etc>")

By the way, how are you running this on Leopard? Mono?

 

Good job on figuring it out.

It's always helpful to bounce stuff off others when you're stuck.

Cheers.

 

Word VBA problem

I have another little problem...

Macintosh HD:Users:elkefocuments:GG_Test1.docx

This works perfectly... But if I change my harddisk's name, it no longer works...
Anyone knows of a / or ~ alternative?

 

It's been a very long time since I've messed with this kind of thing so I may be completely mistaken, but I seem to remember "startup disk" (or something like that) being used to represent your primary hard drive. Worth a shot, maybe.

EDIT: After some curious googling, I found a page that mentions what I was thinking of. http://www.realgeek.com/forums/vba-file-path-hitch-447214.html. The post is from 2006, so it may be outdated, but it's worth a try I would think.

 

Thanks!

This still works!

This is how I get the users shortname and homedir location

ze_path = ze_path + MacScript("(do shell script ""cd ~; pwd | tr '/' ':' "")") + "Documents:"


where tr changes / into :

Together with your hint it works now...

 

The AppleScript to get the current user's home folder is this:

Code:

get path to home folder

If you copy and paste that into AppleScript Editor and run it, you'll see the current complete path beginning with the startup disk.

The path of the startup disk is this:

Code:

get path to startup disk

If you want a Posix path for any of those:

Code:

get Posix path of (path to home folder)
get Posix path of (path to startup disk)

 

Thank you very much, that works... Only now I have an ALIAS in front of the path... Is there a way to eradicate that in Applescript or do I need to do that with a little VBA substring?

 

Code:

get path to startup disk as string

get path to home folder as string

get path to documents folder as string

More "path to xyzzy" folder identifiers:
http://face.centosprime.com/macosxw/applescript-path-to/

 

Thank y'all!