View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Find Replace Visual Basic

I am new to VBA/macros, but have create one that prints a series of documents
that are needed each month out of the folders for each month (i.e. Nov, Dec,
Jan). I would like to add to the beginning of the code, a find and replace
function so that I don't have to go into the code prior to running the macro,
find and replace Feb with Mar, Mar with Apr, etc.

I imagine it would have something to do with having an input box where I
would enter Mar or Apr and it would run the find and replace, but I don't
know what the code would look like.