Importing from Excel (programming part)

[dsaxena15]

Hey guys!

I know importing tables from Excel requires a bit of programming on my part but I don't have the slightest clue how to do that. Could some please explain to me how is it done? Thanks a lot!

[JoeM]

It depends. It may not require any programming on you part at all. Look at the TransferSpreadsheet action in the "Macros" section. If you fill out all the required arguments, you might be able to easily import your file with the Macro.

If you need to make it more dynamic, create a basic example using the TransferSpreadsheet action in a "Macro", and the select the "Convert Macros to Visual Basic" option from the Macros Menu/Ribbon. This will convert your Macro to VBA. You can use that as the building blocks of the VBA code you need.