Remove File import using VBA

[Greg H.]

How can I use VBA to remove the automatic file import? I have a process
where a .txt file is automatically imported on file open but when I'm ready
to send this file out to others, I don’t want the excel file to try to update
that file on open when someone else opens the file.

 

[Joel]

It is easy to create a new workbook without macros. If you right click on
the tab name like sheet1 and select copy or move. then select copy and in
the pulldown slelect new wrokbook.

From VBA all you have to do is copy the worksheet without an after/before

Sheets("Sheet1").Copy