Team,
Can you please send me the steps for the below requirement. I use Oracle as Backend
I get zip codes in an Excel file (only one column)
I wanted to automate the code as below in a new Excel File
1) Create a Form with a Button "Lets Say Run macro'
2) I will copy the Zip codes in a sheet of the Excel file (Step 1)
3) Once the User Click on Run Macro Button the below things need to execute automatically
a) First it should to create a table Kiran_ZIP_CODES
b) Import the data in Sheet to Kiran_ZIP_CODES
c) Once the KIRAN_ZIP_CODES table is created, then this table need to join with some other table (For Example - Employee)
d) The New Table now is KIRAN_ZIP_CODES_Employee
e) Once the KIRAN_ZIP_CODES_EMPLOYEE is created, then this table need to join ADDRESS table
f) The Final results need to export to separate Excel File.
4) If the user Runs the Macro second time, first it should drop the tables and follow from Step 3.
Thanks!
Kiran
Bookmarks