Solved

MACRO - Import Text File - continue even if import file is empty

Posted on 2006-06-12
2
279 Views
Last Modified: 2012-06-27
When building a macro with several steps, all using the Transfer text function, if one of the steps finds the import file empty I would like the macro to either continue automatically or warn the user and allow continue - is that possible?
0
Comment
Question by:COBOLforever
  • 2
2 Comments
 
LVL 34

Accepted Solution

by:
jefftwilley earned 125 total points
ID: 16887729
Place a condition inside your macro

FileLen("FileName") > 0   run Macro
J
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 16887758
If coding, it's easier

'    If FileLen("FilePathAndName") > 0 Then
'        Run your macro
'    End If
J
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question