Hope one of the experts has a solution for my problem.
I have made a macro to run on a databasesheet.
This sheet is made by opening a csv file, that has been created by an administrative system. Most users have no knowledge of excel other than seeing this as a list of data to work on. However this file has to many lines. The macro creates a new sheet with an extract for that particular user.
Klicking on a csv file will open a new Excel sheet. My problem is how do I get the macro to work on that new database? This of course via a simple action to be perfomed by the enduser.
Thanks for your help,
Paul
I have made a macro to run on a databasesheet.
This sheet is made by opening a csv file, that has been created by an administrative system. Most users have no knowledge of excel other than seeing this as a list of data to work on. However this file has to many lines. The macro creates a new sheet with an extract for that particular user.
Klicking on a csv file will open a new Excel sheet. My problem is how do I get the macro to work on that new database? This of course via a simple action to be perfomed by the enduser.
Thanks for your help,
Paul