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
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

starl

Administrator
Joined
Aug 16, 2002
Messages
6,005
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
6,005
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
6,005
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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~
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,119
Messages
5,857,487
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

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
Top