VBA - Help - replace contents of existing cells

  Newuser3443 12:59 21 Oct 05

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,



  VoG II 15:07 21 Oct 05

Try using

Application.DisplayAlerts = False

Don't forget to turn it back on again!

  Newuser3443 16:01 21 Oct 05

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.


This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…