Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2007

Nick has attended:
Excel Advanced course

Macros

Can you do Macro's across different software programs such as Sage?

RE: Macros

Hi Nick, thanks for your query. Sadly, the macro recorder won't translate actions carried out in other applications into Excel code. To tie Sage and Excel together you'll need to venture into the world of VBA and API calls!

Hope this helps,

Anthony

Fri 21 Oct 2011: Automatically marked as resolved.

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.24 secs.