Remove File import using VBA
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
"Greg H." wrote:
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 dont want the excel file to try to update
that file on open when someone else opens the file.
|