Copying excel files containing VB scripts.

The UK's most regular instructor-led training courses.
Training information: excel-courses-london · Excel training courses · VBA training in London

Resolved · Low Priority · Version Standard

Bernard has attended:
Excel VBA course

by - delegate Bernard [1 post] (2008 Mar 13 Thu, 16:34) Reply

You copy one excel file to another. How do you stop the new copy of the Excel file/VB from leaving it's data range in the first copy of the file?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Copying excel files containing VB scripts.

by - trainer Jacob silver contributer [83 posts] (2008 Apr 28 Mon, 17:33) Reply

Hi Bernard

Your post has been brought to my attention and sorry for not getting back to you earlier.

It would help if you could provide some more detail on your requirement, and if you can email us a sample file.

We can then ascertain whether we can provide an answer quickly or if this looks to be more consultancy.

You can email info@microsofttraining.net subject "forum post question - Re Jacob"

Regards

Jacob

· Microsoft Office and the Small Business: Part 1 Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Microsoft Excel Training: Essential for Today's Employees
· Compare Different MS Excel Training Methods

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

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips