Hi, everybody.
I know well how to map a variable from a folder datacard or file datacard to a cell in Excel. But when I try to do it with a date variable I can't achieve it. Maybe the problem is the date format (because is not a simple text data), I guess.
Do you know how to map this kind of variable?
I've had this problem when linking to Excel named cells for as long as I have worked with PDM. My guess is that the variable type for Inicio and Fin are date types. If this is the case, my workaround for that has been changing the PDM variable on the card to a text type.
Whatever the reason is, it does not like the date format.
Does appear to matter what format. Tried changing it between date and text, and neither one made a difference. As soon as a date is entered from the data card and then the file is opened, the link to the named cell is no longer in place.
I also have this issue. Driving me nuts, trying so many different things to solve, LOL. I think it has something to do with the version of MS Offfice - there being a bug for (what I am using) MS Office 2010. What version of MS Office are you using?