Automatically Update Delimited/Comma Seperated File

  • Thread starter Thread starter bony_tony
  • Start date Start date
B

bony_tony

Hi,
I have an exported file saved which has all it's values in Column A,
with each value seperated by ". If I open the file manually, I can go
through the steps to seperated the values, which is fine. However, I
have a sub which is going to open my delimited file overnight, so I
would like to automatically amend the file, seperating the values.

I have Application.Dialogs(xlDialogTextToColumns).Show, but it
requires user input, which is a no-no.

Cheers
Tony
 
Try using Data - Import External Data - External Data.

You can use Tools -Macro - Learn new macro while importing the data. Use
the code from the Learn New Macro to create your own macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Update Delimited/Comma Seperated File . 1
Automatically Update Delimited/Comma Seperated File Options 2
Import a comma delimited file & match records 3
xlTextPrinter and Accounting format 6
comma seperated values using multiple vlookup 2
Best way to format a flat file that Excel will load properly? 8
Problems converted comma seperated CVS file! 1
How can I... 5

Back
Top