• 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.

Recent content by ThrottleWorks

  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...
Top