Sorry to bother but this is my first encounter with excel macro.
I tried running the macro from main.xlsm but its not working, nor showing any error.
I think problem is with Path to database file. How do I Run if both of my files are on desktop i.e. C:\Users\rahulkumar.patel\Desktop.
From wchich document I should run macro.
I tried changing like this.
Code:
xlShtTgt = Workbooks("C:\Users\rahulkumar.patel\Desktop\Main.xlsm").Sheets(1)
Set xlShtSrc = Workbooks("C:\Users\rahulkumar.patel\Desktop\Database2.xlsx").Sheets(1)
Can I direcly run this excel macro from CMD by saving it as .vbs?