Concatonating within commands???
Solved/Closed
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
-
Aug 8, 2015 at 09:37 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Aug 21, 2015 at 01:18 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Aug 21, 2015 at 01:18 PM
Related:
- Concatonating within commands???
- Windows network commands - Guide
- Hitman 3 console commands - Guide
- Diskpart commands - Guide
- Cs 1.6 commands - Guide
- Cod4 console commands multiplayer - 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 January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Aug 19, 2015 at 04:37 PM
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
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Aug 21, 2015 at 01:13 PM
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
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Aug 21, 2015 at 01:18 PM
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!