Kevlarhead
Board Regular
- Joined
- May 23, 2006
- Messages
- 176
I have a series of spreadsheets used by workers to record what they've done on a particular day. Each one uses a form to validate their entries.
Every so often though, I need to update the form, and as the number of worker's spreadsheets is steadily increasing this gets more tedious and lengthy every time.
I'd like to create a macro that, given a list of filenames and locations will go through the list, open each file, insert a new userform, save and then close.
I can manage most of this but getting Excel to insert a fresh form is causing problems. I found a MS KB article (219905) telling you how to do this from VB, but unsure how to acheive it from VBA. Any thoughts?
Every so often though, I need to update the form, and as the number of worker's spreadsheets is steadily increasing this gets more tedious and lengthy every time.
I'd like to create a macro that, given a list of filenames and locations will go through the list, open each file, insert a new userform, save and then close.
I can manage most of this but getting Excel to insert a fresh form is causing problems. I found a MS KB article (219905) telling you how to do this from VB, but unsure how to acheive it from VBA. Any thoughts?