Hello,
I am working on creating a excel application. and I need some guide line/help with some stuff.
1) I would like to Import a spreadsheet from a closed workbook(The whole spread sheet) like when I click a button it should show the file dialog box and should import the first sheet of that file in to the application. In my search I found codes that would define a range , but my range is not constant.
2) If I have to skip the Part of Importing I would like to create a New toolbar that would be accesible to all the workbooks. I do understand and I was able to make it work. but my toolbar is seen in the quickacces toolbarwhich isn't what I want. If possible I would like to create a Tab like the home, data reviewtabs in excel 2007 or atleast show the custom toolbars in the Main Ribbon rather than in quck access toolbars. (I would rather prefer the first one).
I am done with my application and this is theonly thing that I need to know so that I can finally work on the design which way I need to go.
Any help or guide line would be of great help and appreciated.
Thanks