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

macros

ResolvedVersion 2003

Kassandra has attended:
Excel Advanced course

Macros

My company use an internal web database for reporting, could i set up a macro to select information

RE: Macros

Hi Kassandra,

Thank you for your question.

I would imagine this would be possible. As I don't know what type of database it is, it is hard to be 100% sure.

1. Start recording a macro.
2. Data - Import Data and try the import from web and import database commands.

I hope this helps.

Regards

Simon

Mon 2 Nov 2009: Automatically marked as resolved.

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

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.1 secs.