Using option buttons to import data from Notepad

[TallOne]

Dear All

I am new to VBA. I need to import data from Notebad using option buttons. Every time the user chose one of the option button the related data should be uploaded to the same range of cells in the worksheet.

I really looking for help
Thanks in advance

[jetted]

Hi

Can you provide a sample of the text to be upload, is it always the same format...

[TallOne]

Thanks for your reply jetted.

Yes It always the same format. I have tried to attach my files, but I always get an error msg. I will try again to upload them.
Thanks again.

[TallOne]

Hey all
Here are my files that need to be imported to Excel


Cdeastm.txtCdeastf.txtCdnorthf.txtCdnorthm.txt

[TallOne]

I really looking for your help, plz

[TallOne]

Plz. help me, really looking for your help..

[abousetta]

Hi,

What is the delimiter? just a space? And do you want to pick the files or all the files in a folder?

abousetta

[TallOne]

Hi Abousetta

What I need is that, when the I click on one of the option button, the file attached to the button should be imported to Excel, and if I clicked on other option button, data should be replaced by the new file that I have chosen.

I really thank you for your help.

[abousetta]

Hi,

So in other words, you want a button that when clicked, will prompt the user for a text file. That text file will be imported into the same place in Excel overwriting whatever was there before. Is this correct so far?

[TallOne]

Hi Abousetta,

Sorry for this delay. Yes that is exactly what I need. Thank you for your help.

[abousetta]

I had to amend the normal way I would import the files because your data sometimes has several spaces between entries.

Have a look at the attachment and let me know if it suits your needs.

abousetta

[TallOne]

Hi Abousetta

I really appreciate your help. Let me look at it, and understand the code and I will let you know. Many thanks for your reply and help.

[abousetta]

It simply opens the text file, using space as the delimiter (details can be found here), copies the data over to the original worksheet (with the button) starting at cell "A2" and then closes the text file.

[abousetta]

Wrong thread.. need sleep..

[TallOne]

Hi Abousetta

Is it possible to modify it so that when the button clicked (Sheet 1, for example), will prompt the user for a text file. That text file will be imported into the same place in Excel (in Sheet2, for example), overwriting whatever was there before.

Many thanks for your help.

[TallOne]

Hi Abousetta

I think I have managed to modify your code, so that I can import my data to another sheet. But I still have question: Is it possible to show the file name that have been chosen, just near the button?

Thanks a lot for helping

[abousetta]

Possible, just changed ActiveSheet to Sheets(2)... in other words instead of the activesheet where the button is, we are directing the paste into the second sheet of the workbook. If sheet is a worksheet then there should be no problems. Do you need a new copy of the workbook or can you manage from here.

[TallOne]

Sorry for this.

[abousetta]

No problem. I am going to upload a new copy (and then head to bed). If you have any further tweaks you need, just let me know and I will get to them as soon as I can.

Good luck.

abousetta

[TallOne]

I really appreciate your help Abousetta. My next question is that: Is it possible to use a combo box (with file names) instead of button, so that each time I chose a file, I knew its name.
OR
Is it possible to show the file name that have been chosen, just near the button, if I am gonna use button instead of combo box.

Your help are highly appreciated.

[TallOne]

Hi all
I'm still struggling with the following question:

"Is it possible to use a combo box (with file names) instead of button, so that each time I chose a file, I knew its name.
OR
Is it possible to show the file name that have been chosen, just near the button, if I am gonna use button instead of combo box.

Your help are highly appreciated.

[TallOne]

Hi All

I have managed to deal with a combo box. Thanks for your help.
But I have another question:

Is it possible to load two files at the same time to different sheets (in other words, if I chose the file "filename.f" I need the other file with the same name and different extension "filename.m" to be imported to a different sheets).

Looking for your help

[TallOne]

Any help, plzz

[abousetta]

Hi,

Put this code before the end of the macro:

Please Login or Register  to view this content.

That will put the full path of the file you just imported into cell P1

[TallOne]

Hi Abousetta

Thanks a lot, your help is always appreciated.
I used a combo box instead of button. So now my question is:
Is it possible to load two files at the same time to different sheets (in other words, if I chose the file "filename.f" I need the other file with the same name and different extension "filename.m" to be imported to a different sheets).

Thanks in advance

[abousetta]

Could you upload the workbook (or a dummy with similar structure) so we see what you are after. I haven't worked much programming combo boxes before but it shouldn't be too difficult (I hope).

[TallOne]

Hi Abousetta

I have attached a dummy workbook. What I need is that, to be able to import two file with the same name but different extension to different sheets in my workbook, for example, If I click on a, it should import two files (a.f and a.m) to different sheets in my workbook.

[TallOne]

Any idea..

[abousetta]

I can't seem to get the syntax right so I will pass this off to anyone else who is familiar with the properties of a Combo Box

[TallOne]

Hi Aboustte, I really appreciate your help, thanks a lot.

I tried to sort it out, but no succeed

You really helped me.

[Mordred]

Perhaps using an ActiveX combobox is in order for this problem. See attached.

[TallOne]

Hi Mordred

Thanks for your help. I really appreciate it.

But the macro doesn't work !!

[Mordred]

Hi TallOne, can you be more specific? It works for me so if you can say where the error is perhaps I can help.

[TallOne]

Hi Mordred

Sorry for that, it was my mistake. It works now. Thanks a lot for helping me. If I may ask you again!

Is it possible to do modify your code, so that I can import my data from workbook (with the data represented in different sheets) instead using text file. And again when I import, say, (cdeastm) the other sheet (cdeastf) should both be imported to different sheets in another workbook.

Thanks in advance.

[TallOne]

Hi All

I really been trying hardly to sort out the above question, but no succeed. The question is as follow:

I have different data files in notepad (and I made a copy of it in workbook, in different sheets), I want to import these data to my workbook using a combo box. The problem is when I import, say (cdeastm) to sheet2, I need the file named (cdeastf) to be imported to the same workbook, but in sheet3.

Please I really need help on this.
Thanks in advance..

[protonLeah]

I have modified Mordred's effort:

Please Login or Register  to view this content.

[TallOne]

Hi ProtonLeah,

Thanks a lot, I really appreciate your help. It works perfectly. Thanks again. Is it possible for the sheets to be updated each time, instead of copying to new sheets.

Thanks a lot again...

[TallOne]

Hi all.. Any help please...

[TallOne]

Hi All

I have been trying to do sort this task, but I really couldn't. Plzzzz any help...

[protonLeah]

Is it possible for the sheets to be updated each time, instead of copying to new sheets

The macro does not create any new sheets.

[TallOne]

Hi protonLeah,

Thanks for your reply. Sorry (your macro does not create a new sheets, but a new sheets have to be created for the other files, for example, I have other 8 files, 4 ending with "m" and the other 4 ending "f"). What I need is to be able to use the combo box to update the two different sheets each time I import these files (sheet for the files ending with "m" and sheets for the files ending with "f"). So I need to have 2 sheets in my workbook for the imported data.

Thanks for your reply and help, I really appreciate it.


Many thanks

[TallOne]

Any ideas, help, please....

[protonLeah]

1. You must add a sheet for each of the additional files (8), naming them as on the last attachment.
2. Add the four names (without the m & f) to sheet1
3. Modify the combobox properties per the new attachment.

[TallOne]

Hi protonLeah,

Thanks for your reply and help, I really appreciate it, and your attached workbook helped me a lot,so thanks again.

Exactly that what I did (referring to your last post) I did add new sheets for each region and *** (m & f). But, what I hoping is that, instead of adding these new sheets, I want to have only two sheets on my workbook, and when I chose one the files in the combo box, goes directly to these two sheets (the one ending with "m", and the other "f").

Thanks in advance,

[protonLeah]

In the previous macro, the line:

Set MLT = thisWb.Sheets(FileToGet)

selected a sheet tab based on the name of the imported file.

Replace it with:

Set MLT = thisWb.Sheets(Region)

then the sheet tab will be selected by the m or f suffix.

[TallOne]

Hi ProtonLeah,
I really appreciate your very helpful assistance. Thanks a lot. Its works fine now.