Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove File import using VBA
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove MSN MoneyCentral .iqy files w/o losing data import | Excel Worksheet Functions | |||
Coding to remove and import Module | Excel Programming | |||
Annoying automatic date-formatting on import... how to remove it? | Excel Discussion (Misc queries) | |||
Remove and Import Module | Excel Programming | |||
How do I import text file, analyze data, export results, open next file | Excel Programming |