Can anyone help me with how to create a macro that will prompt (with a dialogue or similar) for a filename / location and then create a new sheet in the current workbook with this data in it?
Cheers
Can anyone help me with how to create a macro that will prompt (with a dialogue or similar) for a filename / location and then create a new sheet in the current workbook with this data in it?
Cheers
Try this Import Worksheets Form
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks