Sample data file for the VBA and Macro for Excel

kan83

New Member
Joined
Nov 21, 2005
Messages
3
I purchased the book, "VBA and Macro for Microsoft Excel" and I am on chapter 1.

In the case, I found out that the code from the website didn't contain the "Invoice.txt".

My question is that "Does Mr. Excel offer those sample data files online?"
If do so, please let me know where to download them.

Thank you
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,888
Office Version
365, 2019
Platform
Windows
Kan83 - there should be a link on page 7 for downloading files. If it's not there, email me at the address on the last page before the index and I'll send you the link.
 

kan83

New Member
Joined
Nov 21, 2005
Messages
3
The download link site on my book is...

My book says *removed by Admin*
Isn't it right? I downloaded the file from that link but when I tried to run the macro functions written for the chapter 1, the error message said that it couldn't find the "invoice.txt".

Thank you.
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,888
Office Version
365, 2019
Platform
Windows
Yes, that's the correct link - I removed it because we don't want it advertised (lots of goodies in there).

Which macro specifically? I'll see if I can figure out what's going on.
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,888
Office Version
365, 2019
Platform
Windows
ok - I just read the xls. You'll note that there are instructions on the Discussion sheet.

The macros in Module1 and 2 are examples for review, not testing.
Module 1 contains a *recorded* macro and the cleaned up version.
Module 2 contains extractions from some macros so you can compare macros with and without relative referencing.

This aren't meant to be run - just viewed.
 

kan83

New Member
Joined
Nov 21, 2005
Messages
3
oic

Thank you for such a quick response.

I kinda thought it may not meant to be run...

Now I can proceed to next chapter.

Thanks again~
 

Forum statistics

Threads
1,081,909
Messages
5,362,016
Members
400,667
Latest member
cryptomike

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top