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

macros excel

ResolvedVersion 2003

Richard has attended:
Excel Intermediate course

Macros in Excel

What is the process for writing a Macro to copy data from a particular website, and paste it into a spredsheet. Then to recalculate the spreadsheet with the new data and send that spreadsheet to various recipitants in an email?

RE: Macros in Excel

Hello Richard

Thank you for your question, and welcome to the forum.

In accordance with the fair use policy for the forum, we are able to answer questions that relate to the content of the course/s you have attended with us.

This question would be addressed by writing VBA code, which is outside the scope of the Excel Intermediate course.

We cover basic macros as part of the Excel Advanced course; and we also have a 2 day Excel VBA course which goes into writing code so Excel can perform more complex macros.

Kind regards
Best Training

Wed 10 Dec 2008: Automatically marked as resolved.

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

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