Input and Output Keyword Summary

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Action

Keywords

Access or create a file.

Open

Close files.

Close, Reset

Control output appearance.

Format, Print, Print #, Spc, Tab, Width #

Copy a file.

FileCopy

Get information about a file.

EOF, FileAttr, FileDateTime, FileLen, FreeFile, GetAttr, Loc, LOF, Seek

Manage files.

Dir, Kill, Lock, Unlock, Name

Read from a file.

Get, Input, Input #, Line Input #

Return length of a file.

FileLen

Set or get file attributes.

FileAttr, GetAttr, SetAttr

Set read-write position in a file.

Seek

Write to a file.

Print #, Put, Write #

Show: