Please help to respond to the below using the VBA Excel and the screenshot with information attached to create the excel. The file purchase 1.xlsx contains a small dataset on computer purchases. Write a program that creates a user-defined type called CustomerPurchase with an item (of the appropriate type) corresponding to each data column: Customer, Email, Cell, Date, Amount. The type definition should be defined at the beginning of the module. Write a sub called test to create an array purchase where each element of array is of type CustomerPurchase and fill this array with the data in the file. Finally, display the information about Sam Lafferty in a message box. AutoSave Off H-CFileHomeVisual MacrosBasicE15APurchasesInsert123 Customer4 Joe Jones5 Barbara Smith6 Tom Cummings7 Dave Wilson8 Sam Lafferty9 Mary Harrigan10 Bill Thomas111213DrawRecord MacroUse Relative ReferencesA Macro SecurityCodeBPage LayoutFormulas DataAdd-Excel COMins Add-ins Add-insAdd-insсDPurchases 1 ExcelInsert DesignModeCell phone502-123-3456Email addressDatejjones@fiction.com1/24/2015bsmith@fiction.com 602-124-3462 1/24/2015tcumming@fiction.com 715-432-6541 1/24/2015dvwilson@fiction.com 543-234-7765 1/25/2015slafferty@fiction.com 122-438-9832 1/25/2015mharriga@fiction.com 315-265-9933 1/26/2015bthomas@fiction.com 432-446-3316 1/27/2015Review ViewPropertiesEQ View CodeRun DialogControlsEAmount paid$115$85$69$200$85$98$192FDeveloperSourceHelpMap PropertiesExpansion PackKO: Refresh DataGXMLH

Using, user defined data type CustomerPurchase, which is made using structures in C++, we can store…

Answered: Please help to respond to the below…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Please help to respond to the below using the VBA Excel and the screenshot with information attached to create the excel.

The file purchase 1.xlsx contains a small dataset on computer purchases. Write a program that creates a user-defined type called CustomerPurchase with an item (of the appropriate type) corresponding to each data column: Customer, Email, Cell, Date, Amount. The type definition should be defined at the beginning of the module. Write a sub called test to create an array purchase where each element of array is of type CustomerPurchase and fill this array with the data in the file. Finally, display the information about Sam Lafferty in a message box.

AutoSave Off H-C
File
Home
Visual Macros
Basic
E15
A
Purchases
Insert
1
2
3 Customer
4 Joe Jones
5 Barbara Smith
6 Tom Cummings
7 Dave Wilson
8 Sam Lafferty
9 Mary Harrigan
10 Bill Thomas
11
12
13
Draw
Record Macro
Use Relative References
A Macro Security
Code
B
Page Layout
Formulas Data
Add-
Excel COM
ins Add-ins Add-ins
Add-ins
с
D
Purchases 1 Excel
Insert Design
Mode
Cell phone
502-123-3456
Email address
Date
jjones@fiction.com
1/24/2015
bsmith@fiction.com 602-124-3462 1/24/2015
tcumming@fiction.com 715-432-6541 1/24/2015
dvwilson@fiction.com 543-234-7765 1/25/2015
slafferty@fiction.com 122-438-9832 1/25/2015
mharriga@fiction.com 315-265-9933 1/26/2015
bthomas@fiction.com 432-446-3316 1/27/2015
Review View
Properties
EQ View Code
Run Dialog
Controls
E
Amount paid
$115
$85
$69
$200
$85
$98
$192
F
Developer
Source
Help
Map Properties
Expansion Pack
KO: Refresh Data
G
XML
H

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions