I am inporting a text file into Excel using a macro. Once the file is imported I am then delimiting it (it is necessary to import the file first).When I do so, it asks me if I want to replace the contents of the existing cells.The answer is "yes", but is there a way of getting it to do this automatically without the prompt box comming up please?Any assistance would be appreciated,ThanksRob
Try usingApplication.DisplayAlerts = FalseDon't forget to turn it back on again!
You do make me smile VoG. Nearly missed that response before it disappeared off the bottom of the page.Thank you very much for your help again.Rob
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.