Greetings,

I use Excel to create reports. I use Excel names,
references, VBA and controls extensively to generate the
reports. I have an Excel workbook which contains the
basic report. Additional forms are contained in separate
Excel workbooks. When I create a report, I copy the
needed forms from other Excel workbooks into my basic
report workbook. I am running Excel 2003, MS XP Pro.

The process works, but I would like to make it more user
friendly and automated. I would appreciate any utilities
and/or code that does the following. Any suggestions are
also welcome.

The following utilities are needed, I anticipate they
will be invoked from my base report workbook:

- File selector. From Excel, select a "File Selector"
control button which invokes a File Selector dialog box.
The user selects which form(s) (ie workbooks) will be
copied to the base report.

- Worksheet copy. Copy the worksheets from the selected
workbook and insert them into the base report workbook,
preferably after a specified worksheet.

- Remove local Name references. After I import the
worksheet, I currently use the NameManager to remove the
local name references contained in the imported worksheet
(s). When the local names are removed, the workbook
global names are used, which is what I want. I've tried
to remove the local names when I create the form
worksheet, but have not been able to do so.

Any and all suggestions appreciated.

muchas gracias.

for number one

fName = Application.GetOpenFileName()

See help on GetOpenfileName in Excel VBA help.

--
Regards,
Tom Ogilvy

Alan wrote in message
...
Greetings,

I use Excel to create reports. I use Excel names,
references, VBA and controls extensively to generate the
reports. I have an Excel workbook which contains the
basic report. Additional forms are contained in separate
Excel workbooks. When I create a report, I copy the
needed forms from other Excel workbooks into my basic
report workbook. I am running Excel 2003, MS XP Pro.

The process works, but I would like to make it more user
friendly and automated. I would appreciate any utilities
and/or code that does the following. Any suggestions are
also welcome.

The following utilities are needed, I anticipate they
will be invoked from my base report workbook:

- File selector. From Excel, select a "File Selector"
control button which invokes a File Selector dialog box.
The user selects which form(s) (ie workbooks) will be
copied to the base report.

- Worksheet copy. Copy the worksheets from the selected
workbook and insert them into the base report workbook,
preferably after a specified worksheet.

- Remove local Name references. After I import the
worksheet, I currently use the NameManager to remove the
local name references contained in the imported worksheet
(s). When the local names are removed, the workbook
global names are used, which is what I want. I've tried
to remove the local names when I create the form
worksheet, but have not been able to do so.

Any and all suggestions appreciated.

muchas gracias.