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...
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...
Please see below part of code for your reference.
MyWorksheet.Range("a1:A50") = "1"
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
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...