$$Excel-Macros$$ Re: Use of ADO Connection in Excel Macro

2014-12-22 Thread Zafar Iqbal
Dear Mandeep Baluja, I want this "file dialog method" to be added in below mentioned code. I tried it with hit & trial but could not succeed. Please add this command at suitable position with related parameters in below code. Thanks On Monday, December 22, 2014 12:32:54 PM UTC+3, Mandeep Baluja

$$Excel-Macros$$ Re: Use of ADO Connection in Excel Macro

2014-12-22 Thread Mandeep Baluja
Open sheet 1 by 1 with the help of macro use file dilaog method to get the names of the files and save it in xls Extension. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Monday, December 22, 20