View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KrisN KrisN is offline
external usenet poster
 
Posts: 3
Default parameter to open file name in macro

I am trying to write a macro to print many worksheets from many workbook.
However, each month some of the worksheet have different naming based on the
month. For example: "NOV_PJ" and the next month "DEC_PJ". is there a way to
have a parameter in the macro to ask for the file name before having the
macro print out the worksheet?