Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IQYFile = "C:UsersYPR9WVGDownloadsTEST.iqy"
- With ActiveSheet.QueryTables.Add(Connection:= _
- "FINDER;" & IQYFile, Destination:=Range("A1"))
- End with
- WEB
- 1
- https://dwh.inside.ups.com/analytics/saw.dll?Download
- Format=excel&Extension=.xls&BypassCache=true&PathEncode=IQYEncode&Path=2f7368617265642f526567696f6e2031362050656e64696e672f5f526567696f6e2050726963696e672f50726963696e6720566f6c20616e64205265762051756572792032303138&NQUser=["Username"]&NQPassword=["Password"]&SyncOperation=1
Add Comment
Please, Sign In to add comment