How to save file and automatically overwrite an existing file without prompt in VBA macro

Google Ads

How to save file and automatically overwrite an existing file without prompt in VBA macro

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

April 30, 2014 By Boon Seong

This is how to run the FileSaveAs command in VBA macro which is commonly used in Ms Excel or Ms Project without having the application prompt for overwriting and existing file.

The idea is to temporarily setting the object "Application.DisplaysAlerts" to false and then set it back to true after the file save.

Example:

Application.DisplayAlerts = False
FileSaveAs command
Application.DisplayAlerts = True

VBA macro

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

AndrewOctober 21, 2017 at 1:31 AM
This doesn't work.
ReplyDelete
Replies

Add comment

City Code Table for Casio SGW300HD-1AV Watch

October 15, 2012 By Boon Seong

This city codes are provided in the watch user manual but for the ease of references in the web, I put this table in this blog in case i wanted to refer to it using my smartphone. Hope you find this useful.

Keep reading

Auto create folder based on filename and move the file into it's folder

April 17, 2018 By Boon Seong

This is a Windows batch script that creates folders for each file in the current folder that the script is running. The folders are created with folder names that follow the filenames. After creating the folder, it will move the file into it's own folder. This batch script is particularly useful in organizing files into it's own folder.

Keep reading

How to force only 4G or LTE network connection for Samsung Galaxy Note 4

December 05, 2014 By Boon Seong

This is how to enable Samsung Galaxy Note 4 to force use only 4G (LTE) network connection for high speed internet data. There is a built-in switch in the smartphone that will enable the smartphone to force use only either 3G (WCDMA) or 2G (GSM) network connection but, there is no switch at all to enable the smartphone to force use only 4G (LTE) network connection.

Keep reading

A Better SKMEI 1358 Instructions Manual

September 04, 2018 By Boon Seong

This SKMEI 1358 digital watch is a great watch for a really cheap price. However, the instructions manual is far from good. It took me some time to explore some of the functions and at the same time trying to understand the instructions manual provided by SKMEI. I decided to write an alternative instructions manual for this watch so that other owners of this watch might benefit from it. But never the less, I am not a good English language writer myself. But I do think it is still better than the instructions manual provided. Feel free to correct me using the comment section.

Keep reading

A Better SKMEI 1418 / 1427 Instructions Manual

November 17, 2018 By Boon Seong

This SKMEI 1418 / 1427 digital watch is a great outdoor watch for a really cheap price. However, the instructions manual is far from good. It took me some time to explore some of the functions and at the same time trying to understand the instructions manual provided by SKMEI. I decided to write an alternative instructions manual for this watch so that other owners of this watch might benefit from it. But never the less, I am not a good English language writer myself. But I do think it is still better than the instructions manual provided. Feel free to correct me using the comment section.

Keep reading

City Code Table for Casio AE-1200WHD (Casio Royale) Watch

March 02, 2018 By Boon Seong

This city codes are provided in the watch user manual but for the ease of references from the web, I put this table into this blog post for future reference using my smartphone. This is a world time watch, I will definitely need it in future. Hope you find this useful too.

Keep reading

How to force stop or cancel Android download manager downloading process

March 21, 2018 By Boon Seong

When downloading a large file with CartoonHD, it would take a very long time to complete. I have found that there is no way I could stop or cancel the downloading process if I decided to. Even if I reboot my Note 4, the downloading will restart again after the device rebooted. The only way the downloading can be stop is by uninstalling CartoonHD. I found a way to force stop or cancel the downloading process and here is what I did.

Keep reading

How To Start VNC Session With Gnome Desktop

June 22, 2010 By Boon Seong

Ever wonder how to start an individual desktop session with VNC? Below are the steps on how to modify the VNC startup script to start the GNOME desktop prior to the login user who started the VCN server command.

Keep reading

How to fix a pair of old running shoes with contact adhesive

January 07, 2015 By Boon Seong

This is an attempt to give my 3 years old pair of ASIC running shoes a new life by re-gluing the sole and also fixing the worn off heels section of the sole. I could throw away this old pair of running shoes but it would be interesting to see if I could fix them and re-purpose them for other uses.

Keep reading

SKMEI 1358 Review

November 11, 2018 By Boon Seong

I bought this watch four months ago and I have been wearing it every week during my weekend hiking. Overall this watch is impressive considering the number of features per the price that I have paid for it. All the features worked flawlessly considering that this is a relatively cheap watch comparing it to Casio ProTrek range of watch. SKMEI 1358 is basically an equivalent of Casio's triple sensors watches. You might know them as Pro Trek or Pathfinder in North America. It has a barometer, a thermometer, and a digital compass. It also has an extra sensor that the Pro Trek watches might not have as far as I know of. It has a pedometer. Yes, it counts steps and estimates the calories burnt and distance traveled. With the combination of these sensors, this is an ideal outdoor watch you can have for a fraction of a Casio Pro Trek price. SKMEI 1358

Keep reading

Search This Blog

almost a technocrat

Google Ads