Page 4 of 5 FirstFirst ... 2 3 4 5 LastLast
Results 31 to 40 of 44

Thread: Looking For Beta Testers

  1. #31

    error updating the database



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Ken,

    I installed 'XLGFileTools.xlam', basically it works. A problem occures, when I try to enter a break in 'Manage Favourites Folder".
    Info: "There was an error updating the database"
    Excel 2007, no DB Access installed - is this causing the problem?

  2. #32
    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

  3. #33
    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

  4. #34
    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.

  5. #35
    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.

  6. #36
    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
    Oh... and I took off the Beta status.
    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.

  7. #37
    Hi Ken,

    after installing your new version 2.006:
    The error-message is still there, when I try to enter a break in 'Manage Favourites Folder".
    Click image for larger version. 

Name:	error1.jpg 
Views:	25 
Size:	21.7 KB 
ID:	915

  8. #38
    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
    Hi Aldus,

    Thanks, I'll take a look and see what I can find.
    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.

  9. #39
    Neophyte berapard's Avatar
    Join Date
    Dec 2012
    Location
    Lyon, France
    Posts
    2
    Articles
    0
    Excel Version
    2016
    Hi Ken,

    As my first post is not online I repost it !
    In fact after using with happiness for few years your XLG Favourite add'in, I downloaded last week your Files Tools add'in and I faced some issues.
    Indeed as I can add a file from the menu "Manage Favourite File", I am not able to open this file from the menu "Favourite Files" : Although the file is present in the list, its selection does not work.
    In the same way, "Add active file to favourites menu" seems not to work.
    I don't know if I am the only user to experience this bug perhaps due to my French version of XL ?
    Best regards

    Philippe

  10. #40
    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
    Hi Philippe,

    Not sure. Can you email me the error log that will be in the same directory as the add-in? Ken at ExcelGuru dot ca

    Thanks,
    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 4 of 5 FirstFirst ... 2 3 4 5 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
  •