Need VBA code to loop through columns, get ID's and add data to SmartSheet

[dillon6720]

I am trying to create a macro that will transfer data from site based excel to a web based SmartSheet. My organization apparently doesn't have Bridge so I can't use that to get column ID's. Does anyone have any VBA snippets to loop through and get column identifiers and send data?