Page 1 of 2 1 2 LastLast
Results 1 to 10 of 44

Thread: Looking For Beta Testers

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,344
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider

    Looking For Beta Testers

    Hi everyone,

    I'm looking for Beta Testers for a new addin. It's a combination of my Favourites and Template addins, but rolled up together and updated for use with Excel 2007+. Full details of what the add-in does, and the latest download build can be retrieved from the XLG File Tools Add-in page.

    In order to test, you MUST be using Excel 2007 or higher.

    To install, go to your Office (2007) or File (2010) menu and go to Options-->Addins-->Go-->Browse and select the addin file (attached). It will add a new File Tools tab, and create a database in the same path that you store the addin. From there, you can use "Manage Favourites" to add favourite files and folders. (And yes, you can also add non-Excel files to your favourites menu).

    Beyond that, have a play through the different options and let me know what you think. (Feedback good or bad is appreciated.)
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Hi Ken

    Is there a 999 limit on files also?

    JanineC

  3. #3
    Hi keep getting cut off in reply time limit thing! Sorry.

    Does the menu refresh every time it loads the files?

    Needs a PDF icon. Like that it opens most apps.

    Did get a file exception. I have that fixed now in my addin. Snagit bailed so no screenshot next time it happens.

    Otherwise so far so good.

    File order dropdowns - filenames first then folders is that controlled by XML/vba as mine swapped to be Folders then File Names - just asking?


    Janine

  4. #4
    Hi Ken

    When is Template Editing Mode available - or is it just when building the template?

    JanineC

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,344
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Revised version attached. File Tools tab will now be activated when all workboks have been closed (but application is still alive.)

    Quote Originally Posted by JanineC
    Is there a 999 limit on files also?
    Honestly, I haven't checked. It will be limited by the amount of XML characters I can post to a string to enumerate the dynamic menus. I've had it up over 50 files, but honestly, I've never considered really going about that as it would be kind of a monster to find things after a while...

    Quote Originally Posted by JanineC
    Does the menu refresh every time it loads the files?
    Depends on the menu. The recent folders/recent files, yes. The favourite folders/files are rebuilt when the application is opened, and every time the "Manage" panels are closed.

    Quote Originally Posted by JanineC
    Needs a PDF icon.
    Yes, I need to get to that one.

    Quote Originally Posted by JanineC
    Did get a file exception. I have that fixed now in my addin. Snagit bailed so no screenshot next time it happens.
    Great, thanks. If you check the directory where the addin is installed, you'll also find a log file. It would be handy to see that with the picture.

    Quote Originally Posted by JanineC
    File order dropdowns - filenames first then folders is that controlled by XML/vba as mine swapped to be Folders then File Names - just asking?
    Not quite sure I follow what you're asking here...

    Quote Originally Posted by JanineC
    When is Template Editing Mode available - or is it just when building the template?
    You should be able to turn on Template Editing mode at any time. It will only affect things when you go to open a template file though. At that point it should open the template in editing mode instead of creating a copy off the template.

    I have uploaded a new build that you can download from the link above, or by clicking here.
    Last edited by Rebekah; 2019-08-14 at 10:11 PM.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6

    Beta Addin

    Click image for larger version. 

Name:	uploadAM.jpg 
Views:	47 
Size:	18.4 KB 
ID:	535Hi Ken
    attached apostrophe parse error in filename - no big deal.
    What's in the new build that I've downloaded.

    Janine

  7. #7
    Ken,

    Really love the Add-in I'm all about making my work time more efficient, and for me this toolbar will definitely help ( for me at least) . So far have not had any issues , but i will post any i run across . Thanks

  8. #8
    Ken,

    noticed some errors popping in the error log when i am working in Managing Favourites. Everyrthing works fine just thought you might want to know about the errors getting generated.


    06/28/12 09:15:30 [XLGFileTools.xlam]clsDBLink.dbOpen, Error 91: Object variable or With block variable not set
    06/28/12 09:24:57 [XLGFileTools.xlam]modGlobalProcedures.AddWorkbook, Error 94: Object variable or With block variable not set
    06/28/12 09:58:06 [XLGFileTools.xlam]clsDBLink.ReIndex, Error 9: Subscript out of range
    06/28/12 09:58:08 [XLGFileTools.xlam]clsDBLink.ReIndex, Error 9: Subscript out of range
    06/28/12 10:01:13 [XLGFileTools.xlam]clsDBLink.ReIndex, Error 9: Subscript out of range

  9. #9
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,344
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Thanks guys. I need to loop back on this, just have been insanely busy. Tommy, glad you're liking it so far.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  10. #10
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,344
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hey everyone,

    It's taken way too long, but I finally sat down and worked through some of the known bugs that you guys brought up and a bunch more that I found over the past few months.

    New version is 2.006 and can be downloaded here

    Tommy, you may want to delete the old error log before you give this a go.

    Aldus, not sure on the database question. I've tried to repro your issue here and I can't. So if you're still using it and encounter the issue again, please let me know.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Page 1 of 2 1 2 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •