Google Ads

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

By
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


Comments

Post a Comment

Thank you for visiting Almost a Technocrat. Due to many spam comments, your comment will be moderated.

Popular posts from this blog

A Better SKMEI 1418 / 1427 Instructions Manual

By
Image
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

A Better SKMEI 1358 Instructions Manual

By
Image
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

Jailbreak your Amazon Kindle Keyboard

By
Image
Jail breaking your Amazon Kindle device will enable you to customize fonts and your screensaver. Additional to fonts and screensaver customization, you can also try out some of the hacks for Amazon Kindles . This post will guide you through the steps of jail breaking your Amazon Kindle device. Don't panic! Just follow the steps below.
Keep reading

SKMEI 1358 Review

By
Image
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

How to export Tasker's Projects, Profiles, Tasks and Scenes

By
Image
In order to share your Tasker love (projects, profiles, tasks or scenes) to all Tasker users, you will need to export Tasker's projects, profiles, tasks or scenes to xml files. Anyone out there looking for a specific automation for their Android phone could just download and import the xml files into their Tasker Android application and tweak the automation to suite their own use. Somehow i felt that the export and import functions are not that intuitive. I did took a bit of time and Googling to find out how to export and import properly. This post will show you how to access the export function in Tasker.
Keep reading

How to import Tasker projects, profiles, tasks and scenes

By
Image
Tasker is a very powerful Android smartphone automation application. Although Tasker can practically do anything you want, you still have to learn how to create the automation. I know many of you out there are just plain lazy or no time to pick up the skill. Many had relied on Tasker users shared automation projects, profiles, tasks or scenes to quickly kick start your automation without hassle. I am sharing most of my Tasker automations in this blog for the benefit of the lazy Tasker people (no offence, i am one of them too). The Tasker automations that i am sharing in this blog are just the exported xml files. Most probably i will not be writing the "step through" like some other websites did but you can download and import the xml files using Tasker. It's easy enough. You can tweak my automation to suite your need. This post will show you how to import Tasker automation xml files into your Tasker application.
Keep reading