08-23-2011, 03:27 PM
So I was able to piece together a dialog using all of this that allow you to be able to choose sheets to merge from a directory.
I used an HTML form in the dialog because it was the easiest to format the way I wanted it to work.
The end file gets exported to the desktop with the date as the file name.
I didn't play much around with the dialog layout. I'd like to have a browse button/edit box that would build the form after the dialog was initialized.
It would probably be a good idea to have a place to specify the output file too...Perhaps the file should just save in $temp$. That way the user can save the output file however they want when Excel opens it at the end of the merge.
Overall, a lot of leg work is finished on this project. Thank you Gintaras for all of your hard work! I'm glad I can finally have this function working for future projects!
-Jim
I used an HTML form in the dialog because it was the easiest to format the way I wanted it to work.
The end file gets exported to the desktop with the date as the file name.
I didn't play much around with the dialog layout. I'd like to have a browse button/edit box that would build the form after the dialog was initialized.
It would probably be a good idea to have a place to specify the output file too...Perhaps the file should just save in $temp$. That way the user can save the output file however they want when Excel opens it at the end of the merge.
Overall, a lot of leg work is finished on this project. Thank you Gintaras for all of your hard work! I'm glad I can finally have this function working for future projects!
-Jim