Search : in
By :

Userform for importing sheet from one excel

Last answer on Jul 16, 2009 6:29:02 pm BST ujo, on Jul 16, 2009 11:43:39 am BST 
 Report this message to moderators

Hello,

I want to create a user form in MS excel that will prompt the user for the file name.
Once the user browses the file name it should copy the sheet 2 or any other into the sheet 1 of the target file (where the userform resides)
Please help me with this - if possible send me a sample workbook with the userform

Regards
Ujo

Best answers for « userform for importing sheet from one excel » in :
Copy required data from one excel to anther Show
Import contacts from Excel to Outlook Show Import contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Copying data from one Excel sheet to another. Show
Create an Attendance Report with Excel sheet ShowCreate an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Ask your question Reply

1

 epsiman, on Jul 16, 2009 6:29:02 pm BST

I didn't get you at all, what are you trying to do?

   
Reply to epsiman
Ask your question Reply
They need your help