var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Copy Paste & Include other Data
I bring back data from a SQL Server database, and want to find out how I can include a word after the data I import is pasted into a cell.
This is my Code I have to paste the data record.
What I want to do is in Cell C12 once it pastes the Number add Weeks after, so would look like 7 Weeks
Set rsDW = New ADODB.Recordset
sQRY = "SELECT MAX([Weeks Waiting]) AS MAX " & _
"FROM jez.CYPPhyPaediatric "
rsDW.CursorLocation = adUseClient
rsDW.Open sQRY, cnnDW, adOpenDynamic, adLockOptimistic, adCmdText
Application.ScreenUpdating = False
Set rsDW = Nothing
How is that possible?
This would work...
Other options include concatenating the word within Excel ala
SELECT Convert(varchar, Max([Weeks Waiting])) + ' weeks' As [max]
Sheet3.Range("C12").Value = Sheet3.Range("C12").Value & " weeks"