Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copying from another application.

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Copying from another application.

Resolved · High Priority · Version 2003

Reply Thu 19 Mar 2009, 16:50Delegate Ahmad said...

Ahmad has attended:
Excel VBA Intro Intermediate course

Copying from another application.

Using Excel VBA how would I copy data form another application to paste in to an Excel spreadsheet?

For upcoming training course dates see: Pricing & availability

Reply Thu 30 Apr 2009, 16:07Trainer Jacob said...

RE: Copying from another application.

Hi Ahmad

Thanks for your post, if you can provide some more information on the following it will help us.

What application are looking to copy data from?
What format is the data in?
Do you have any example files we can see?

Please let us know and then we will get back to you.

Regards

Jacob

Reply Thu 30 Apr 2009, 17:06Delegate Ahmad said...

RE: Copying from another application.

Hi Jacob,

Thanks for your reply. However I have found a colleague at work who has achieved this and is willing to show me how.

This request can be closed.

regards,

Ahmad

Excel articles

· The Mysteries Of Excel Explained
· Jazzing Up Excel With Graphics
· Trust Excel To Protect Your Data
· How Sharing Your Excel Data Can Help Your Business Flourish
· Finding Your Way Around Excel 2007

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips