macro recording

[rk_19]

hi,
my doubt is regarding macro recording. I have a .csv file and an excel file in same folder.. the name of the csv file is always same and I want the contents of this to be copied automatically (by clicking a button in the xls file. also, there is some sorting that need to be done after these are copied. these 2 files (.csv and .xls) will remain together always, but they can be in any folder/or a different computer. appreciate any assistance..

 

[SkipVought]

HI,

Using Microsoft Query, which is a feature in Excel, you can IMPORT your .csv into a sheet. This FAQ that I posted in

http://www.Tek-Tips.com,

explains the process:

http://www.tek-tips.com/faqs.cfm?fid=5829.

It is a ONE TIME process to add a QueryTable to a sheet. The QueryTable can be REFRESHED at any time thereafter to import a new set of data. This can be accomplished via a macro or by a setting that can refresh on opening the workbook.

Now to your particular instance. When you say that they "can be in any folder/or a different computer," I assume that there is a prototype workbook from which all others copies proceed. Can you explain how the workbook gets into different computers and folders?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}