PC Review


Reply
Thread Tools Rate Thread

Block save file prompt in imported txt file?

 
 
mike
Guest
Posts: n/a
 
      28th Nov 2006
I have a macro that imports a txt file into Excel (it's a log file
another macro appends to) for the user to view upon clicking the "View
Log" button I made.

Problem is I need to remove the Save dialog box that comes up if the
user accidentally makes a change to the workbook. In the past users
have made changes to the log, went to close then clicked on Yes and
when that happens, formatting is lost and the log file goofed up.

I've tried workbook.saved = true, enableevents = false, displayalerts =
false and none work on this workbook that's created from importing the
text file.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
in vb.net how to open a file from file download prompt without askinguser to save it or run it....just open it in internet explorer Kaustubh Budukh Microsoft Dot NET 4 23rd Jun 2008 10:10 PM
prompt user to save file as {desired_name} and save it to a variab =?Utf-8?B?R2VuZVdhbg==?= Microsoft Excel Programming 1 5th Jan 2007 06:46 AM
Save File Prompt The Old Ranger Microsoft Word Document Management 2 31st Oct 2006 03:56 AM
How to block file Save (^S)? G Lykos Microsoft Excel Programming 11 24th Oct 2005 04:52 AM
Prompt to save file Deb Microsoft Frontpage 10 5th Nov 2003 04:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:15 AM.