nhatto Posted October 26, 2009 Report Share Posted October 26, 2009 Hello I'm Trying to create a macro to replace certain predefined text with entries in an excel file for example: I have 10 predefined symbols located in various places in a text file: 1. #^3 2. %f2 3. @4 4. %8 ...etc I would like to add those as fixed variables in the macro but i dont know how? the macro will simply locate the symbol in a text file, and replace it with an entry that I copied from excel macro will be : - go to excel and copy the first entry - go to text file - locate predefined symbol "#^3" in text file - paste the excel entry in the place of the predefined text - go back to excel and move to second row - repeat process with second predefined symbol never used variables before and i read the tutorials but wasnt able to figure out how to work with them, i would appreciate any advice thanks Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.