Command Button to put 2 .CSVs in different tabs in same excel workbook

  • Thread starter Thread starter Astello
  • Start date Start date
A

Astello

I want to put a command button onto a form that will take two different
..CSV files and put them into different tabs in the same excel workbook.
Is this possible, and if so, does anyone know how to do this? Thanks!
 
You are in a bit of a pickle on this one. To create a csv file, you would
normally use the TransferText method, but it has no range argument. If you
use the TransferSpreadsheet method, you can specify a specific worksheet
using the Range argument (you have to be careful because its use is limited
in an export), but it will be an xls rather than a csv.
 
It's actually better for them to go in as .xls files, but they come out
of another program as .csv files, I wasn't thinking about that. So if
I do a TransferSpreadsheet method and the range argument, and put in
the path names of .csv files, will it still consider them .xls files?
I guess I can just try it out and see... Thanks!!
 
Back
Top