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

excel convertion word batches

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel convertion to word by batches

Excel convertion to word by batches

ResolvedVersion 2007

Adelaido has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Excel convertion to word by batches

Hello,

Could I save an excel document into a word document by batches? e.g. more than 10 in one go.


Thanks,
Adelaido

RE: excel convertion to word by batches

Hi Adelaido, thanks for your query. Can you give me a bit more information about what you're trying to achieve? Are you trying to insert 10 Excel worksheets into a Word document, or convert the spreadsheets?

Hope this helps,

Anthony

RE: excel convertion to word by batches

thanks for your reply.. trying to convert spreadsheets by batches saving me a few hundred clicks on my mouse, thanks again

RE: excel convertion to word by batches

Hi Adelaido. There's no built-in function to do this I'm afraid, it will almost certainly involve a macro of some kind. If you're happy recording a macro of the repetitive action, that will give you one-click conversion for one file. However, to batch convert you need to tinker with the macro code to loop through the files in a particular directory, converting them in bulk.

Hope this helps,

Anthony

Mon 31 Jan 2011: Automatically marked as resolved.

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

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.