Missing Sample file- "Invoice.txt"

wsider

New Member
Joined
Jan 23, 2005
Messages
1
Hi all,

I've just bought the book then downloaded the code file from the link on Page 7 of the VBA and Macro For Excel and installed it sucessfully. I could not find the file called "Invoice.txt" anywhere. Anyone can help? Thanks a bunch.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Joined
Feb 8, 2002
Messages
893
Office Version
365
Platform
Windows
In the course of Chapter 1, there are three different versions of invoice.txt. The key concept requires that you have three different versions of this file, each with more or less records than the first day. Newer versions of Invoice.txt are used in Chapter 2. In all, there are five needed versions of Invoice.txt.

I could not figure out how to include all five versions of invoice.txt, because each day, the program expects the file to be called "invoice.txt".

The important concept here is not the Import step. The important concept is what happens immediately after the import. So - the solution - I commented out the line of code that does the import. I already ran the import line on four different worksheets in the workbook.

Look at ProjectFilesChapter01.xls. The worksheet called InvoicesMonday contains the original Invoice.txt. Put the cellpointer in A1 and press the button in C16 to run the macro on the original version of invoices.txt. The macro will work fine, just like it will work on every day that there are 13 records in the file.

Next, look at the worksheet called InvoicesTuesday. I've already imported a longer version of invoices.txt into this worksheet. Put the cellpointer in A1. Run the macro by pressing the button in C21. You will see that the macro fails as described in the book.

The book takes a look to see if relative references would solve the problem. This version of the macro can be tested on Invoices Tuesday (2). Put the cellpointer in A1, run the macro by pressing the button in C21.

The final version of invoices.txt has been imported to the next worksheet, called InvoicesWednesday.

In ProjectFilesChapter02, I used a similar strategy on the worksheets called Page42 and Page58. The invoice.txt file has been imported to the worksheet and the import line is commented out.

Bill Jelen
 

dokimh37

New Member
Joined
Mar 7, 2011
Messages
1



I have decided to learn macros and I have bought book called "Microsoft Excel 2007, VBA & Macros" Bill Xelen


I want to ask which is the study of archives detailing your book
eg .invoice.txt
 
Joined
Jul 10, 2020
Messages
3
Office Version
2016, 2010
Good night, I bought the book “Excel 2016 VBA e MACROS” on sheet five and requests to download a set of files with, data examples, notes, authors' additions and 25 bonus macros available, says that a folder to download will be found at the address "www.altabooks.com.br" but the files do not exist on the site. Please, could anyone know how to get these files? I am very anxious to read the other pages but I am unable, thanks in advance for your attention.
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
954
Hi Cleudson,

I sent you a private message including the download link.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,565
Messages
5,487,592
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top