Hi
New to the forum, but in dire need for some expertise help.
I retrieve data from a website (json format) on a daily/hourly basis and need to reference a time input in Excel for the macro to run. How Do I reference a cell when the "recorded" macro returns the website as a range?
Recorded macro:
Range( _
"v3_created_after_2018_12_11_09_33_16_campaign_id_153_api_token_XXXXXXXXXXXXXXXXX[[#Headers],[Column1.id]]" _
).Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
Amended macro where cell AB1 contains the input by the user in format YYYY_DD_MM_HH_MM_SS , not working.
Range( _
"v3_created_after_&"AB1"&_campaign_id_153_api_token_XXXXXXXXXXXXXXXXX[[#Headers],[Column1.id]]" _
).Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
New to the forum, but in dire need for some expertise help.
I retrieve data from a website (json format) on a daily/hourly basis and need to reference a time input in Excel for the macro to run. How Do I reference a cell when the "recorded" macro returns the website as a range?
Recorded macro:
Range( _
"v3_created_after_2018_12_11_09_33_16_campaign_id_153_api_token_XXXXXXXXXXXXXXXXX[[#Headers],[Column1.id]]" _
).Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
Amended macro where cell AB1 contains the input by the user in format YYYY_DD_MM_HH_MM_SS , not working.
Range( _
"v3_created_after_&"AB1"&_campaign_id_153_api_token_XXXXXXXXXXXXXXXXX[[#Headers],[Column1.id]]" _
).Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False