Concatonating within commands???
Solved/Closed
BrianGreen
BrianGreen
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
BrianGreen
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
Related:
- Concatonating within commands???
- Www.xvideoservicethief ubuntu 18.command download whatsapp - Download
- All networking commands pdf - Guide
- Operating system commands - Articles
- Attrib command - Guide
- Csgo friendly fire command - Guide
3 replies
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
Aug 19, 2015 at 04:37 PM
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
Aug 19, 2015 at 04:37 PM
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
Aug 21, 2015 at 01:13 PM
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
Aug 21, 2015 at 01:13 PM
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
Aug 21, 2015 at 01:18 PM
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
Aug 21, 2015 at 01:18 PM
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!