New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

excel macro + file vault = access problems


Post Reply New Thread Subscribe

 
Thread Tools
southside
Guest
 
Posts: n/a

I had my Excel macro that massages quicken report data working just jim_dandy... then I decided to lock down my home directory with file vault... hadn't run that Excel macro til tonight when I found that it can't find an Excel spreadsheet that it needs to open - and that spreadsheet is there and I can manually open it with no problems... I am guessing it is a permission problem, but I am not sure which user the macro runs as to give that user access to the file vault protected file... if that really is the problem... appreciate any help you can provide...

thanks!,
SouthSide
QUOTE Thanks
witeshark

 
witeshark's Avatar
 
Member Since: Mar 09, 2004
Location: Miami FL
Posts: 2,860
witeshark will become famous soon enough
Mac Specs: G4 1Ghz OS X 10.4.7

witeshark is offline
If you cannot get permissions to the file from the Admin user (first user) you should be able to as off - line only as root which has absolute authority on the system (be careful) in Finder > Applications > Utilities and drom there either netinfo manager or keychain access should allow you the necessary changes
QUOTE Thanks
southside
Guest
 
Posts: n/a

Quote:
Originally Posted by witeshark
If you cannot get permissions to the file from the Admin user (first user) you should be able to as off - line only as root which has absolute authority on the system (be careful) in Finder > Applications > Utilities and drom there either netinfo manager or keychain access should allow you the necessary changes

WhiteShark - many thanks for the reply... when I am running as the first user I am able to open the spreadsheet manually... it is when I run the Excel macro that tries to open the spreadsheet that it is unable to do it... I am thinking that even though I ran Excel, the macro that it runs is not running as the same privilege level as my account - or something to that affect... otherwise can't quite figure out why the change - and I am assuming that file vault has something to do with it...

SouthSide
QUOTE Thanks
witeshark

 
witeshark's Avatar
 
Member Since: Mar 09, 2004
Location: Miami FL
Posts: 2,860
witeshark will become famous soon enough
Mac Specs: G4 1Ghz OS X 10.4.7

witeshark is offline
Ok, I'm not familiar with Excel, so I may have to make guesses firstly that Excel macro is running from a directory that is not allowed permissions. But maybe you can turn file vault off for a bit and see if it works then
QUOTE Thanks
southside
Guest
 
Posts: n/a

whiteshark - yeah, ended up throwing in the towel due to lack of time to really figure out the problem.... turned off file vault and the macro once again worked OK... read about too many problems that folks were having with file vault and permissions, etc - after they had responded YES to a dialog box when logging off (as I had done) asking if they wanted to reclaim space used by file vault... still think it is all about Excel running as a built-in system user versus me when it is running and a macro is trying to open a file... when I have more time maybe I will set up a test account that I don't mind losing, and will move the file to another folder and see if it works...

later and many thanks!,
SouthSide

PS for the record, Bruce Springsteen ROCKS!!!!
QUOTE Thanks

Post Reply New Thread Subscribe


« I like OS X!!! | Doubts about external hardware before switching »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
file sharing & remote access gkiely72 Other Hardware and Peripherals 3 01-27-2005 01:15 AM
File Vault Dalton29 OS X - Operating System 1 02-05-2004 05:36 AM

All times are GMT -4. The time now is 01:39 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?