I have created a Macro which will generate a CSV export of data in my XLS Spreadsheet. However I am having trouble generating a file name. At the moment when I edit the Macro I can see the file name, what I would like to do is change the file name to be the current date in the format...
I am trying to strip the day month and year as sepereate fields in XSLT, using the following function:
<CreationDateTimeDay><month-from-date(xs:date("2005-04-23"))/></CreationDateTimeDay>
However this is not working.
Any ideas..... PLEASE !!!!
I have received a file in excel format which contains hard copy returns within the cells, these 'squares' are in different places throughout the different cells. Does anyone know how i can replace this square with a " - ". Naturally I have tried the Find Replace Option but am unable to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.