• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. ThrottleWorks

    Not able to open CSV file with partial name

    Hi @Chihiro sir, it is working great. Thanks.
  2. ThrottleWorks

    Not able to open CSV file with partial name

    Hi @Chihiro sir, thanks a lot for the help. I am checking this and will revert with updates. Sure sir, I will learn this meathod. Have a nice day ahead. :)
  3. ThrottleWorks

    Not able to open CSV file with partial name

    Hi, I have a string, this string is partial file name. I am trying to open this file. But macro is giving bug when am trying. Folder is present, file name is correct, I checked it manually, do not know where my mistake is. Can anyone please help me in this. Am getting pop-up as file moved...
  4. ThrottleWorks

    Thanks a lot vltem sir for your 7100+ helps

    Congratulations @vletm sir for your 7100+ helps to the Forum. Bit late to wish, but yes, you are always very helpful. Have a nice day ahead. Take care. :)
  5. ThrottleWorks

    Congratulations Chihiro

    Thanks a lot @Chihiro sir for your 6,000+ helps to the Forum. Out of these 6000, few of them were for me too when I needed it very badly. Have a nice day ahead, take care. :)
  6. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi @BobBridges , thanks a lot for the help. It is working great. Have a nice day ahead. :)
  7. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi @BobBridges thanks a lot for the help. Am checking this and will revert with details. Have a nice weekend ! :)
  8. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi @BobBridges really sorry for confusing and taking your time. 1) Partial path is present in a cell, let us say cell A1, example MyFolder1/ 2) user types date in cell A2, for example 07102020 3) Select an Excel file name with a drop down, for example, MyFile.xls 4) Cell A3 is concat of A1,A2...
  9. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi @BobBridges , thanks for the help. My problem is 'With MyWorksheet.QueryTables.Add(Connection:="TEXT;" & MyFileFullPath, Destination:=MyWorksheet.Range("A1"))' If I check MyFileFullPath here, both the times it is correct. I mean, the path reflecting here is correctly. I checked in Immediate...
  10. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi, can anyone please help me this. Am trying but not able to resolve this issue despite getting help from @BobBridges .
  11. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi, Not able to find query names in watchlist. Trying. Will share updates. Thanks.
  12. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi @BobBridges , thanks a lot for the detailed reply. I am working on this and will revert with details. Have a nice day ahead. :)
  13. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi, Please see below part of code for your reference. Sub Dummy_Code() MyWorksheet.Select MyWorksheet.Range("a1:A50") = "1" MyWorksheet.Range("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote...
  14. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi @BobBridges , thanks a lot for the help. My apologies for not uploading code. Am trying to. You are correct, there must be two queries, that is why am getting bug. If you get time, could you please tell me how do I rectify this two queries issue. How do I discard one query and move on to...
  15. ThrottleWorks

    Facing issues with 'With WorksheetName.QueryTables.Add'

    Hi, Hope everyone is healthy and doing fine. I have one macro. This macro is throwing bug at 'With WorksheetName.QueryTables.Add' this particular activity. Code is something like below. My apologies, code is at another networks hence I can not copy it. With...
  16. ThrottleWorks

    Thanks a lot shrivallabha for 2,000 + helps to the Forum !

    Thanks a lot @shrivallabha for your 2,000 + helps to the Forum ! Stay safe, take care.
  17. ThrottleWorks

    Take care, stay safe

    Hi, Hope everyone on our forum is doing good. Take care, stay safe. :)
  18. ThrottleWorks

    Wishing a very happy birthday to Chirayu

    Wishing a very happy birthday to @chirayu ! Have a wonderful year ahead ! :) Your PDF books on Excel were really good.
  19. ThrottleWorks

    Wishing a very happy birthday to NARAYANK991 sir !

    Wishing a very happy birthday to @NARAYANK991 sir ! Have a wonderful year ahead. :)
  20. ThrottleWorks

    Congratulations Marc L sir for his 5,000 + helps

    Congratulations @Marc L sir for his 5,000 + helps to Forum ! Thanks you. :)
  21. ThrottleWorks

    Excel Insights (Coming soon)

    Hi @Hui sir, thanks for the link. Am sure book will help readers immensely. :)
  22. ThrottleWorks

    VBA Project ideas and dll ideas

    Hi @Shadow777 welcome to Forum !
  23. ThrottleWorks

    Learn Excel-VBA Step by Step (book)

    Hi @kachkah thanks for sharing ! :)
  24. ThrottleWorks

    Many many thanks to Khalid NGO for his 2,000+ helps to Forum !

    Many many thanks to @Khalid NGO for his 2,000+ helps to Forum ! :)
Top