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
 
Hi tony,
before you open it - you may go Tools->Macros->Record New Macro then
open the file and through the steps to seperated the values...
then see the code in the Visual Basic Editor...

HTH

João Rodrigues
 

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