Recent content by joeKen

thanks, I'll have to think of a plan B

Hi, I have a spreadsheet with cells containing lots of text (500 to 1500 characters long). The cells are formatted as Text with Word text switched on. When Excel displays the text it wraps the text successfully of about the first half of the cell then then rest of the text disappears off in a...

Hi, Thanks for everybodies help on this forum. I managed to create my app which wouldn't have been possible without your help. Here's what I ended up doing for the date conversions. To convert the number field into a date field I created this routine: Sub ConvertRangeToDateFormat(chkRange As...

Doesn't sound hopeful :( This will be used in many countries so I would like to avoid going down the version by country route if I possibly can. Cheers, Joe

Hi, I'm trying to convert a cell's date format to match that of the user. I have no idea what the user of the spreadsheet will wish to see, so I'm hoping to pick up the date format from there pc settings instead of hard coding "DD/MM/YYYY" or forcing them to select a date format from a combo...

Thanks for all the advice. I'm checking some stuff out now. FYI, the information is download from a web site. To make things more fun for me, the date format is in US MDY and being British I need DMY.- call me fussy ;) Some of the stuff I've tried gives some bizarre results so I'll let you...

Hi, I have some data generated by another app. I'm writing a macro to convert my table data into a pivot table. However I've found the date information has come across as a text format. I tried changing the format to be a date format, but I think I need to clear out the data change the cell...

Hi, I have heard of z-file being used but I no experience of them. An alternative is to populate the system 47 files and use them to create the data in JDE. It all depends on what information you want to load, but there is a good range of unload programs available. This route is often simpler...

Hi, Does anyone have experience of EDI systems interfacing into JDE world software, system 47 files? I would be interested to know peoples thoughts of what works and what is currently being used. We currently use a third party package which, well let's just say, we wouldn't shed a tear if we...