The Transporter
Board Regular
- Joined
- Jan 18, 2009
- Messages
- 71
Hello,
I'm new to VB code and am hoping someone may be able to help me out.
Is it possible to have a macro that will (a) first prompt the user to select an excel file to import (the excel files to import are provided each month and data is always in "Sheet1"); then (b) select which worksheet to import the data (values only) from the selected file into?
I'd really appreciate any help with this...<!-- / message --><!-- attachments -->
I'm new to VB code and am hoping someone may be able to help me out.
Is it possible to have a macro that will (a) first prompt the user to select an excel file to import (the excel files to import are provided each month and data is always in "Sheet1"); then (b) select which worksheet to import the data (values only) from the selected file into?
I'd really appreciate any help with this...<!-- / message --><!-- attachments -->