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.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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
 



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
 
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.
 
Hi Cleudson,

I sent you a private message including the download link.
 

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top