Hi All,
I'm pretty new to VBA and I am trying to do the following:
- Downloading search topics from Google Trends for specific categories across multiple geographies;
- For example, I am looking at USA airline demand by searching the following terms: flight, delta air lines, united airlines, american airlines and southwest airlines
- I do this across several travel categories such as airlines, tour operators, online travel agencies (OTAs) and cruises, and across the USA, UK, FRANCE, ITALY AND GERMANY
- Once I have manually downloaded the csv files into a folder I am looking to extract data from each csv file into one file called RDI raw data
- Each sheet would be labeled according to the category and geography (eg. USAairlines)
- In each sheet would be the data for the four/five search terms according to the category and geography
Does anyone know how to do this?
I'm pretty new to VBA and I am trying to do the following:
- Downloading search topics from Google Trends for specific categories across multiple geographies;
- For example, I am looking at USA airline demand by searching the following terms: flight, delta air lines, united airlines, american airlines and southwest airlines
- I do this across several travel categories such as airlines, tour operators, online travel agencies (OTAs) and cruises, and across the USA, UK, FRANCE, ITALY AND GERMANY
- Once I have manually downloaded the csv files into a folder I am looking to extract data from each csv file into one file called RDI raw data
- Each sheet would be labeled according to the category and geography (eg. USAairlines)
- In each sheet would be the data for the four/five search terms according to the category and geography
Does anyone know how to do this?