Txt import

Hi,

I guess i didnt google enough, but can you guys help to build a simple code, which would import txt file into excel..? iIl fix the separator later, all i need in excel is, to get the browser open
(or event hard coded address),and to choose the file to import. Somehow i cant figure it out. Thank you.

IB

Hi admssm,

I use the following code to import files:

Please Login or Register  to view this content.

All the real work is rolled into the Application.FindFile command.

Hi,

How about

Please Login or Register  to view this content.

Rgds

Look at:
http://www.cpearson.com/Excel/ImpText.aspx

I don't know if there is an easier way.

Hi,

If you use the macro recorder to open your text file, delimiting it as necessary during this process, you'll find that you end up with code like the following.

Please Login or Register  to view this content.

Just include this array variable syntax after the code I gave you earlier in the workbooks.open ....coding.

Rgds



Regards

Im attaching excel, which im using to import the macros. Each sheet contains different macro-button. Once i set the separators manually, the file opens in a new excel. How do i "tell" the file to open in the same window im running the macro form..?
Thx

Hi admssm,

When you run your "Get Data" macro it opens a whole new workbook, not just another sheet. You will need to flip back and forth between the two workbooks to copy and paste data. The code goes like this

You need the name of the new, just opened workbook and your current old workbook so I do this first.

Please Login or Register  to view this content.

If you need more data from the newly opened worksheet you get back to it using with code of

Please Login or Register  to view this content.

When you are done with the newly opened workbook you can close it with the code

Please Login or Register  to view this content.

Writing code to automate the whole process is a little hard, as you are discovering. The data that is coming in needs to be arranged in a consistant place. If it is longer or shorter you may need to write code that varies and deals that too.

I hope this helps you get through your import problem.

Hi Marvin,

thank you for your help.. i figured it out eventually.. :

How can i set the separators.. for example "," ":"

I saw the some example on the net, but since im not very skilled *(blessed) with macro, i couldnt understand the syntax.. if you will be kind enough to put small example of the marco separator.
thx

Hi,

The macro sample above is in your opened Excel Workbook. I think you want to import data from a text file into this opened workbook. That is the name of the thread and I thought was your need.

Macro code is not copied from the opened text file into the current workbook.

It is hard for us to guage your experience with programming and ability to read and understand VBA. We also have a term problem between Data and Macro.

After looking at your example file, it looks like you have a Linux Server that is sending you text files and you want to add some of this data to your Excel spreadsheet. I am concerned that I find you have code that is trying to send out email, automatically. (I hate spam). I'm not sure I understand your problem well enough to help.