Receive data from SharePoint 2013 Excel-workbook using VBA Excel -

i have 2 questions.

1) sp access/rights need able make work?

i have looked @ https://sharepoint.stackexchange.com/questions/29021/import-sharepoint-list-into-excel-using-vba-only still unable find guids (listname/viewname). guess might missing sp rights?

2) possible first run if-statements match data sp excel workbook data in desktop excel workbook? sort of security check, make sure data transfered if these statements answered correct.

any truely appreciated have no experience vba links sp.

i can give partial answer. guids come 'modify view' url in sharepoint. go given list , view like, select menu modify view. once on page, take entire url , deobfuscate either manually or using web based solution. should leave guid next list , view sections.

picture of menu - walkthrough

as permissions, suspect need contribute permissions list guids. i'm not sure if there way find url list , view guids visible without going page. (i suspect, not certain, need read permissions pull report in excel.)

to create personal view, must have contribute permission level list or library, such being member of default site name member group. create public view, must have design permission level list or library, such being member of default designer sharepoint group site.

-from office support site "create, modify, or delete view"