vba courses london - Exporting data

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

vba courses london - Exporting data

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Exporting data

Diego has attended:
Excel VBA course

by - delegate Diego [1 post] (2007 May 10 Thu, 16:32) Reply

I need to export a formula to different files located in a folder. All the files have different names. How can I do this?

RE: Exporting data

by - trainer Garry gold contributer [188 posts] (2007 May 18 Fri, 16:43) Reply

right click the module and export

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips

Training by application

Main information pages

vba courses london - Exporting data

Related articles

Vba tip:

Add A New Sheet at the end of the Workbook