Forum

Hi David, If the macro works with test data but not with real data then your test data is not an accurate reflection of your real data. You need...

Hi David, there's no attachment. Phil

Hi Maurizio, You need to change this line RigaF = Split(Replace(lineafile, Chr(34), ""), ",") Your text file has each line wrapped in double ...

Hi Khaled, I don't know any way to do this from VBA. You'll find some stand alone utilities though if you do a search. Regards Phil

Hi Alison, You can follow the steps here but I would start with a blank document, rather than any template available in Word. Basically if ...

Hi Alison, The fields in the Word doc are mapped 1-1 from the source data (columns) for each record. So if you want to have multiple issues per Ow...

Hi Maurizio, I have to ask, why are you playing music in Excel? Why not just use a media player? Anyway, you can use ActiveX controls to do wha...

Hi Lea, So you mean encrypted as in you encrypted it in Windows using BitLocker or EFS? Or is it just that the file is password protected? Rega...

Try unchecking the box beside this avvisa sempre prima di aprire questo tipo di file

So I think what you want is to show all the items with the same Inv number on the Master Sheet, on the same Invoice template?

Hi Shila, The data in the Date(x) and Time(x) columns are text. Your date format in the regional settings doesn't mean you can use text as dates. ...

Hi Dinesh, Welcome to the forum. Just a few rules to follow so that it makes it easier for us to help you. Please don't post the same question ...

hi Nalaka, there's no image attached to your post. Regards Phil

Hi Amy, I've replied to you by email. Regards Phil

Your dates and times are still text. If you actually make them dates/times you'll be able to do your calculations. Regards Phil