Access vba write to csv file

Asked by:. Archived Forums. Access for Developers. Sign in to vote. This is what I have so far. Wednesday, March 25, PM. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. In such cases use the VBA Type object data type. If you want to save your worksheet as CSV you can always resort to the Text file section.

However, this is an ineffective approach. SaveAs function like below. In case you want to instead copy your worksheet simply replace Move for Copy :. Writing files in VBA is not hard and usually takes just a couple of lines of code. It makes sense however to do it write and be aware of certain traps like not omitting the use of the FreeFile function or knowing the difference between Print and Write.

Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Excel IT Pro Discussions. This forum is for general questions and feedback related to Microsoft Excel all versions as they pertain to the IT Pro community. Sign in to vote.