Wrox Programmer Forums
BOOK: Excel VBA 24-Hour Trainer
This is the forum to discuss the Wrox book Excel VBA 24-Hour Trainer by Tom Urtis; ISBN: 978-0-470-89069-1
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel VBA 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 9th, 2011, 06:13 AM
Registered User
Join Date: Sep 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel VBA - Many Questions!

First off I'm a complete VBA novice and working my way through Tom's book which is great so far but could do with advice on something I need to do now!

I extract several reports from an HR IT System every month for a variety of data to compile an offline staff directory - all Excel format. I currently put this together manually using several vlookups, sorts etc. the data range changes every month as staff join and leave so the master file is a moving target.

Is it possible using Excel VBA to compile the master file with data from four or five different Excel Workbooks, held within folders on a server, all with different amounts of data. If I can give an example - the base data file containing the list of employees for that month contains 2 fileds for telephone prefix and VPN - I concatenate these into a single field and then VLOOKUP the telephone extension into the next column - some staff do not have telephone extensions input yet (eg a new joiner). There are four of five similar actions in the process. I have recorded separate macros in different workbooks for the concatenate and VLOOKUPS but when the amount of data in the master sheet changes the data selection is fixed to the range when the original macro was recorded.

Apologies if this is covered in a section of Tom's book I have not go to yet, or if this ramble makes no sense at all! Any advice would as to whether my scenarios can be achieved using VBA be greatly appreciated.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code works in Excel VBA but not Access VBA fossx Access VBA 2 May 21st, 2007 08:00 AM
Can VBA questions be entertain here? muki Beginning VB 6 4 April 13th, 2007 02:12 AM
Excel VBA Interview Questions vinod.vkumar Pro Visual Basic 2005 1 December 20th, 2005 12:09 PM
VBA Acces Newbie questions mbeirn Access VBA 2 October 13th, 2005 06:56 AM
Excel VBA to SQL & back to VBA edesousa Excel VBA 1 June 1st, 2004 02:39 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.