How to open files one by one in an order??

**justinferns** · 08-25-2011, 07:08 AM

Hi,

I've been trying to work on a macro to open files in a particular order. For eg :

RFC-1.xls
RFC-2.xls
RFC-3.xls
RFC-4.xls
RFC-5.xls

Also another condition is I need to open only those excel files that start with "RFC". Can anyone pls help? - Thanks

Justin

**justinferns** · 08-26-2011, 06:53 AM

Thanks guys I got my answer to this!!

**TANAJI** · 11-25-2011, 04:11 AM

what is the code for this ?

08-25-2011, 07:08 AM	#1
justinferns VBAX Regular Joined: Aug 2011 Posts: 6 Kb Entries: 0 Articles: 0	How to open files one by one in an order?? Hi, I've been trying to work on a macro to open files in a particular order. For eg : RFC-1.xls RFC-2.xls RFC-3.xls RFC-4.xls RFC-5.xls Also another condition is I need to open only those excel files that start with "RFC". Can anyone pls help? - Thanks Justin
Local Time: 05:27 PM Local Date: 05-25-2013 Location:

08-26-2011, 06:53 AM	#2
justinferns VBAX Regular Joined: Aug 2011 Posts: 6 Kb Entries: 0 Articles: 0	Thanks guys I got my answer to this!!
Local Time: 05:27 PM Local Date: 05-25-2013 Location:

11-25-2011, 04:11 AM	#3
TANAJI VBAX Newbie Joined: Nov 2011 Posts: 1 Kb Entries: 0 Articles: 0	what is the code for this ?
Local Time: 05:27 PM Local Date: 05-25-2013 Location: