VBA CODE IS FOUND HERE
http://newyorkinteractivemedia.com/training_class_blog/index.php/2011/12/vba-macro-process-google-keywords-csv-file-usable-clickable-excel-file-code/
Google
found many keywords in our site from blogs and homework files that were
hurting our SEO and making our site less relevant to our specific
Keywords such as Excel Training in NYC or VBA Training. By checking
where each keyword was getting picked up, we could block that page from
being index or delete old files.
This macro separates all the
links (up to 7) per line and allows you to click them to check if you
should block that page by a robots.txt file.
Friday, December 9, 2011
Thursday, December 1, 2011
Excel 2010 VBA to assign a shortcut key
Application.OnKey "^j", "subroutineToRun"
This runs the subroutine named subroutineToRun when CTRL+j is pressed.
The macros must be run once before the shortcut will work.
This runs the subroutine named subroutineToRun when CTRL+j is pressed.
The macros must be run once before the shortcut will work.
Subscribe to:
Comments (Atom)