Is it possible?

[artanis50]

I'm sure it is but of course I've come to ask the experts ...

I have a table that is currently exported to a specific folder as an Excel document. Once that's done, I have to manually open the document, sort by patient account number (the account # tells me what facility they are from) and create 2 files (one for each facility), delete the header row and save each as a .csv

Is it possible to do all of this in VBA code so I don't have to do it manually?

 

[MSAccessRookie]

I'm sure it is but of course I've come to ask the experts ...

I have a table that is currently exported to a specific folder as an Excel document. Once that's done, I have to manually open the document, sort by patient account number (the account # tells me what facility they are from) and create 2 files (one for each facility), delete the header row and save each as a .csv

Is it possible to do all of this in VBA code so I don't have to do it manually?

If I understand you correctly, you want to take an existing set of data and:

1. Sort it based on the contents of a particular Field
   • This can be done
2. Separate the sorted results into groups
   • This can be done as long as rules for grouping can be defined
3. Write each of the groups to a separate File
   • This can be done in Excel to be converted to CSV
   • This might be able to be done directly to CSV

 

[artanis50]

Yes! Yes! Yes!
That's exactly what I want! Now, How do I do that?

 

[vbaInet]

The following link should be a good start for you:

http://www.btabdevelopment.com/ts/default.aspx?PageId=10