$$Excel-Macros$$ Re: Amazon - Compare Prices

2014-01-06 Thread Basole
Em segunda-feira, 6 de janeiro de 2014 20h44min15s UTC-2, Bill Q escreveu: > > Hi, > > Is there a relative easy way to extract prices from specific Amazon URL's > ? I live in Canada and use amazon.ca , but often see prices much less > expensive in the USA site (amazon.com). > > I wish to c

$$Excel-Macros$$ Amazon - Compare Prices

2014-01-06 Thread Bill Q
Hi, Is there a relative easy way to extract prices from specific Amazon URL's ? I live in Canada and use amazon.ca , but often see prices much less expensive in the USA site (amazon.com). I wish to compare various items where I could just easily refresh to see the prices from both sites for

$$Excel-Macros$$ VBA - how to account for weekends?

2014-01-06 Thread June Scanlon
Using Excel 2010 & 2013 (will be used in both versions), what is the best way to create a variable date that excludes weekends (and holidays, if possible)? My scenario, where PrevDate= 2014-Jan-02 and LastDate=2014-Jan-03: 1. Open an existing workbook with file name: FilePath & PrevDate &

Re: $$Excel-Macros$$ VBA Code for Hide specific column as per criteria

2014-01-06 Thread amar takale
Dear Ravi Sir, Great,very very thankful. Can we use this code for all sheet except some sheets,bcos there are maxi. 7 same format sheets so if I click this code then all 7 sheets do same activity process which do in first sheet.Can you give sheets name in code which sheets code only activate? Regar