Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling Take Control ebooks.

 

 

Pick an apple! 
 
Record Online Meetings in Pear Note

While Pear Note is primarily geared toward recording notes in the physical world, it's possible to use it to record things in the virtual world as well. For instance, you can use it to record and take notes on Skype calls. To do this:

  1. Download Soundflower and install it (along with the Soundflowerbed app that comes with it).
  2. Download LineIn and install it.
  3. Start Soundflowerbed, and select Built-in Output (or whatever output you'd like to listen to the conversation on).
  4. Start LineIn, and select your microphone (e.g. Built-in Mic) as the input and Soundflower (2ch) as the output, then press Pass Thru.
  5. Open Pear Note Preferences, select Recording, and select Soundflower (2ch) as the audio device.
  6. Open Skype Preferences, select Audio, and select Soundflower (2ch) as the audio output and your microphone (e.g. Built-in Mic) as the audio input.
  7. Hit record in Pear Note and make your Skype call.

This will allow you to conduct your Skype call while Pear Note records both your audio and the other participant's.

Visit Useful Fruit Software

 
 

Excel 4.0 Comments

Send Article to a Friend

You would think that with three parts spread out over a month, we would have covered Excel 4.0 sufficiently. However, as a testament to the product's added complexity and flexibility, we've received two comments about it in the past few weeks, one good, one bad.

Object model -- First, the good news. Jon Pugh wrote to tell us to be sure to mention the fact that Excel 4.0 is perhaps the first major program to be fully Apple event and AppleScript aware. Excel 4.0 supports the object model, and for those of you using UserLand Frontier or pre-release versions of AppleScript, you can do essentially everything in the program via Apple events. This is, of course, wonderful news that also fits in the "so what?" category until enough other programs are similarly full-featured and AppleScript eventually ships. In the meantime, Frontier can do some pretty amazing things, and along with a hack from Steve Zellers of Berkeley Systems, you can even have a Scripts menu in your Finder that contains Frontier scripts. Frontier must be running as well, but with sufficient RAM to hold both apps at the same time you could control Excel (or any of the other Apple event-aware applications like PageMaker) from a Finder menu, which would be pretty neat.

Workbook bugs -- Now, the bad news. Andy J. Williams writes to tell us about a serious bug with workbooks in Excel 4.0:

I just had a disaster that taught me a valuable lesson about Excel 4.0's Workbook feature. File this under "Don't let this happen to you."

The scenario: I have five spreadsheets and one macro sheet bound together in a workbook. At the bottom of the screen for each page of the workbook is a "control panel" of five buttons each leading to the other sheets (referencing macros on the macro sheet).

I went to save the workbook. Just after saving the first of the six documents my machine crashed.

After restarting the workbook was trashed. Only the first sheet was visible or usable. Using the standard forward/backward page buttons I can go between the index page and that one sheet. No others are visible. Clicking on my control panel of buttons produces a system crash.

I spoke with someone at Microsoft Tech Support, and I surmise that Excel is completely rebuilding the workbook up from scratch rather than changing the existing workbook. Thus, any crash while saving will ensure that there is NO copy anywhere around except the one that was in memory, in the process of being written. This is a wonderfully unsafe way to do things.

So, my advice is: always backup workbooks BEFORE starting work.

[A clever macro programmer could probably whip something up to do this automatically, and it would be a piece of cake to do in Frontier. -Adam]

Information from:
Jon Pugh -- jpugh@apple.com
Andy J. Williams -- AndyJW@dartmouth.edu

 

Updated! PDFpen for iPad 1.7: Designed for iOS 7, faster, and
better-looking. Edit your PDFs anywhere. Sign contracts, make
changes, fill forms, and more. All while you’re on the move.
Syncs via iCloud and Dropbox. <http://smle.us/tbpdfpen-ipad>