Show File Path In Excel 2011 For Mac

Hi, I currently have an order form which uses a macro to store the xls and csv in dropbox. This form is used on several macs, and currently, I have to make a specific excel file for each mac with the specific paths for that particular mac in the macros. Pasted the file there, started Excel and tried to run the macro (Shortcut) but nothing happened. Deleted the file, restarted Excel, tried to record a macro and save it to Personal workbook. Did a test-run. The shortcut I assigned made the macro run. So far so good. Closed Excel, restarted excel, hit the shortcut-key again, but nothing happened.

OS 9.2.2 is bundled with Iomega drivers, & maybe Tiger has them too, meaning I wouldn't need this. Zip disk costs add up, & I wish I'd spent all that on an external HD, but Zip's are where my. Iomega usb zip 100 drivers for mac os x 10.

Learn how to create your own OS X service that lets you copy & paste the paths of files and folders in Finder. After just a few steps you will be able to select items in Finder, press a quick keyboard shortcut, and paste the path(s) anywhere you want.

Mac users have long complained that there’s no easy way to copy the location of a file or folder on their computer and paste it in a document, email, internet browser, etc. There are a bunch of third party utilities and convoluted workarounds to get this functionality, but let’s be honest – they’re all pretty terrible. Even MacYourself’s doesn’t work anymore in OS X 10.7 Lion. So what do we do? We take matters into our own hands, of course!

Let’s come up with our own solution – and let’s make it awesome. Before we get started, we should establish some goals. Obviously we want to copy a file path or folder path from Finder and paste it somewhere else for reference. Let’s take that a few steps further and say we want to: • Support the selection of multiple files and folders at a time • Require no third party software or plugins to accomplish our goal • Integrate with Finder so this feels like a real, native solution • Set up a keyboard shortcut for quick & easy access • Copy the path to OS X’s clipboard so it can be pasted in any application Sounds like a plan!

Here we go • Launch Automator from your Mac’s Applications folder. If you’ve never used Automator before, that’s not a problem.

This is going to be so simple anyone can do it. • Double-click the Service icon from Automator’s start menu.

• Go to File > Save in the menu bar and name your service Copy File Path. Our work with Automator is now done, so you can safely quit it once the service is saved. • Launch System Preferences and go to the Keyboard pane. Click on the Keyboard Shortcuts tab. • Select “Application Shortcuts” from the list on the left. Next, click on the + button at the bottom of the list.

• A small window will come up with a few options that need to be set. Select “Finder” from the Application menu, type Copy File Path as the Menu Title, and create your own Keyboard Shortcut. If you don’t know what to put here, you can just press Shift+Command+C on your keyboard. Click Add and we’re done! Now let’s test our fancy solution!

Here’s how it works • Select any file or folder (or a mixture of multiple files and folders at once) in Finder. • Press your keyboard shortcut – in our case, Shift+Command+C. This copies the path to OS X’s clipboard. • Open a text document, email message, or other place you’d like to use your location path. Press Command+V (or right-click and select Paste) to paste the file path(s). Hopefully you should see something like /Users/YourName/Documents/Work/Files/resume.doc From now on these 3 easy steps are all you have to do to copy and paste file paths from Finder to your clipboard and, ultimately, another application. A few things to mention If you’re not keen on keyboard shortcuts, the service you created is also accessible when you right-click on an item in Finder and select Services > Copy File Path from the contextual menu.

The actual file we created for this service is located in: ~/Library/Services in case you ever want to delete it or copy it to put on another Mac. Finally, this tutorial was written specifically for Mac OS X 10.7 Lion, so the steps involving Automator might be a little different if you’re running an older version. How does this solution work for you? Does it give your Mac the functionality you were looking for?

Works pretty nicely. I found that if you need the directory, select a file within the directory and use the shortcut you created, paste where you need it, and just delete the file works well (although, a little more inconvenient). I haven’t the time to figure out how to do it right.

It’s interesting that whatever file you last selected (and path copied to clipboard?) is what is pasted even if you select another directory (not a file) and use the keyboard shortcut. I haven’t tried the Services menu. This was the first time I felt capable as I got it to work in a plain word doc as I tested it! THEN I went to my project and tried and now –lost. Here is what I’m trying to get done: I have a document that I actually send to clients as a PDF when it’s completely ready. Inside that doc is a schedule of activities that I want to have people be able to click for the details and instructions of that activity, ie.