macro recording
macro recording
(OP)
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..
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..





RE: macro recording
Using Microsoft Query, which is a feature in Excel, you can IMPORT your .csv into a sheet. This FAQ that I posted in 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!