H hfs Registered User. Local time Yesterday, 22:45 Joined Aug 7, 2013 Messages 47 Aug 9, 2013 #1 HI, need help with this importing just 1 column from excel file into vba ! plz help me
P Pat Hartman Super Moderator Staff member Local time Today, 01:45 Joined Feb 19, 2002 Messages 48,017 Aug 9, 2013 #2 You can use TransferSpreadsheet to link to Excel if you need to do it from VBA or just do it manually if you only need to do it once. Then create a query that selects what you need.
You can use TransferSpreadsheet to link to Excel if you need to do it from VBA or just do it manually if you only need to do it once. Then create a query that selects what you need.
