Hi,
I am trying to import data from an excel spreadsheet.
Works fine mostly but I have a date that is formatted in excel "5-Feb" i.e no year, I like it this way.
The underlying value does include the year, i.e 05-2-2015
When I use DDE Request as below it imports exactly as formatted so no year.
Don't want to change the spreadsheet in any way.
Is there a way to import the value. Don't want a big programming change as only a small issue occassionally effecting me but just enough to annoy me.
Chan = DDEInitiate("Excel", ExcelWkend & ".xls") ' Establish link with new
XName = DDERequest(Chan, "R" & I & "C3")
XDate = DDERequest(Chan, "R" & I & "C4")
XCost = DDERequest(Chan, "R" & I & "C5")
Thanks I/A
I am trying to import data from an excel spreadsheet.
Works fine mostly but I have a date that is formatted in excel "5-Feb" i.e no year, I like it this way.
The underlying value does include the year, i.e 05-2-2015
When I use DDE Request as below it imports exactly as formatted so no year.
Don't want to change the spreadsheet in any way.
Is there a way to import the value. Don't want a big programming change as only a small issue occassionally effecting me but just enough to annoy me.
Chan = DDEInitiate("Excel", ExcelWkend & ".xls") ' Establish link with new
XName = DDERequest(Chan, "R" & I & "C3")
XDate = DDERequest(Chan, "R" & I & "C4")
XCost = DDERequest(Chan, "R" & I & "C5")
Thanks I/A
