D domoputro Registered User. Local time Today, 08:45 Joined Apr 2, 2003 Messages 11 Sep 10, 2003 #1 I want to create a function that opened an excel file from shared directory. Should I use macro or VBA? What's the code in VBA to link excel? Thank you.
I want to create a function that opened an excel file from shared directory. Should I use macro or VBA? What's the code in VBA to link excel? Thank you.
P Pat Hartman Super Moderator Staff member Local time Today, 03:45 Joined Feb 19, 2002 Messages 47,849 Sep 11, 2003 #2 The same as with a macro, TransferSpreadsheet.
N namliam The Mailman - AWF VIP Local time Today, 09:45 Joined Aug 11, 2003 Messages 11,695 Sep 11, 2003 #3 Whenever you can avoid using macros in the long run thats the way to go.... Regards