macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 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:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.11 secs.