excel output to TXT macro to be available

1. Set the macro security level to the lowest, and open any file to automatically "enable macros". Here's how to set it up:

File – Options – Trust Center – Trust Center Settings – Macro Settings – Enable All Macros – OK – OK.

Once set, reopening the file is "macros enabled".

2. Save as txt file

File - Save As - Select the text file in "Save Type (t)" - Save.

with"Forest'r" says the way to enable macros.

1. The difference is that the macro sets some formats and specifications in the background, which can be regarded as a small program.

Different macros can accomplish different functions, and the general macro like you should control where you can fill in the data, and may also list some options to help you fill in, you will not mess up the format when you fill in, so that the data users can process the data filled in by others in batches.

If you don't have macros turned on, these features won't work. It is even possible that you will not be able to enter data into **.

2.This" is saved to txt"The button should be defined by a macro and used to encrypt the data you fill in into a txt file.

In addition, the survival txt file is not for you to open, just send it directly to the person's mailbox, and they will decrypt and deal with it.

First of all, enabling macros means that there is a macro command (a kind of applet) in this **, as for the dialog box that does not appear to enable macros, it means that the level of macros on your computer is set very low, and it has been automatically enabled.

As for "Save to txt file" will automatically generate a txt file, it means click on this"Save to a txt file"This button will automatically generate a file with the extension txt (e.g. resume). txt), and then you send the file to a dedicated mailbox.

In excel, the security is set to medium, and there is a macro written in the file, then a dialog box will appear when you open the file, asking whether to enable macros, if the point is, you can run the macro command, if the point is no, the macro can not run normally.

Note: Macros are programs written in Excel.

Which version of Office are you using?

If it's a simplified version, you generally can't run macros.