N/APosted on - 11/01/2011
Hello, good day!
Please help me with my problem.
With numerous worksheets I have a file. When ever I add new, imported-data to the file, I must have to search and replace few columns in one or more work-sheets; my data is not "cleaned."
I want to automate this in case I forget it! Surely there is a Close event in which all cells of worksheets could be selected, a search and replace operation run that strips off some unnecessary text strings, after which the file is saved, or even as part of the save process.
I have experimented with macros, would you prefer any code idea?
Thank you for your time.
Having problem with Lotus Notes
To automate the replacement of columns in worksheets when using lotus notes, you will need to do the following:
The first thing you will need to do is run Lotus Notes in the Multiuser mode.
And then you will have to create a Domino account which will have access to the user attributes that you will need to query for. The important attributes that you might want to use for client setup are: mailserver and mailfile
You will then need to ensure that every user's ID file will get to be put out on a network share somewhere that you can trace so that you can copy it from there. You may need to set some permission on the folders so as to ensure that everyone who might run the setup script will have access to be able to get to the files.
You can refer to the following link for more details on the same: