Concatonating within commands???
Solved/Closed
BrianGreen
Posts
1005
Registration date
Saturday 17 January 2015
Status
Contributor
Last seen
30 September 2021
-
8 Aug 2015 à 21:37
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 21 Aug 2015 à 13:18
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 21 Aug 2015 à 13:18
Related:
- Concatonating within commands???
- Diskpart commands - Guide
- Cs 1.6 hack commands - Guide
- Ms dos commands - Guide
- Bios commands - Guide
- Hitman 3 console commands - Guide
3 responses
Hi Brian,
cant exactly emulate what you want but the string formation is wrong:
try this instead:
Sheets("my data").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\myFiles\" & theDate1 & "_final.txt", Destination:=Range("$A$1"))
.Name = "theDate" & "_final_1"
End With
cant exactly emulate what you want but the string formation is wrong:
try this instead:
Sheets("my data").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\myFiles\" & theDate1 & "_final.txt", Destination:=Range("$A$1"))
.Name = "theDate" & "_final_1"
End With
BrianGreen
Posts
1005
Registration date
Saturday 17 January 2015
Status
Contributor
Last seen
30 September 2021
149
19 Aug 2015 à 16:37
19 Aug 2015 à 16:37
Thank you Ray.
Appologies for not getting back sooner, but holidays got in the way of work and a myriad of other joyous things.
At first glance your script seems to work, but there are a few other problems. I think this is because I have forgotten to add a thing in another part of my script which copies cells from one sheet to another. This would tells me things are working as I want them to or not. However, your addition does seem to let me past the initial failings and faults I was experiencing.
I will hopefully be able to mark this as SOLVED later today (but more likely tomorrow) when I have trawled through the rest of the script to see that everything else does work :^)
Thanks again for your help - it is very much appreciated.
Appologies for not getting back sooner, but holidays got in the way of work and a myriad of other joyous things.
At first glance your script seems to work, but there are a few other problems. I think this is because I have forgotten to add a thing in another part of my script which copies cells from one sheet to another. This would tells me things are working as I want them to or not. However, your addition does seem to let me past the initial failings and faults I was experiencing.
I will hopefully be able to mark this as SOLVED later today (but more likely tomorrow) when I have trawled through the rest of the script to see that everything else does work :^)
Thanks again for your help - it is very much appreciated.
BrianGreen
Posts
1005
Registration date
Saturday 17 January 2015
Status
Contributor
Last seen
30 September 2021
149
21 Aug 2015 à 13:13
21 Aug 2015 à 13:13
Yipeeeeee
All the failings have been resolved. They were all to do with my part of the script (would you ever believe it?)
Thank you so much Ray - as ever you are a star.
All the failings have been resolved. They were all to do with my part of the script (would you ever believe it?)
Thank you so much Ray - as ever you are a star.
BrianGreen
Posts
1005
Registration date
Saturday 17 January 2015
Status
Contributor
Last seen
30 September 2021
149
21 Aug 2015 à 13:18
21 Aug 2015 à 13:18
oh - just one other report to make ... to get everything to work ok i had to modify your .name line to:
.Name = theDate & "_final_1"
But without your initial help I would nrever have got there!
.Name = theDate & "_final_1"
But without your initial help I would nrever have got there!