Search results

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. :)

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. :)

Yes. With VBA.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi @Shadow777 welcome to Forum !

Hi @kachkah thanks for sharing ! :)

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

Many many thanks to @vletm sir for his 6,000+ helps to Forum ! :)

Hi @Hui sir, thanks for the help. Have a nice day ahead. :)

Hi, I have no idea about PtrSafe keyword. Just did Google about this a while ago. I am trying to know if use of PtrSafe has advantage or disadvantage in the coding. Also, is PtrSafe required for 64 but machine. Or are there any constraints or mandates to use or not to use PtrSafe while using...