$$Excel-Macros$$ Re: Complex Macros

2011-12-22 Thread HarryP Knuckles
 pm, HarryP Knuckles wrote: > Good afternoon Folks, >                                      I have two directories of excel > files (Part 1 and Part 2) that contain the same information except the > second directory (part 2’s) contains newer information than the first > directory (p

$$Excel-Macros$$ Complex Macros

2011-12-22 Thread HarryP Knuckles
Good afternoon Folks, I have two directories of excel files (Part 1 and Part 2) that contain the same information except the second directory (part 2’s) contains newer information than the first directory (part 1’s). I have a list embedded into a worksheet of m

Re: $$Excel-Macros$$ Number Formats in French

2011-10-28 Thread HarryP Knuckles
. On Oct 28, 2:10 pm, Sam Mathai Chacko wrote: > Instead of putting a custom format, why don't you change the comma separator > and decimal separator to space and comma respectively? > > Regards, > > Sam > > On Fri, Oct 28, 2011 at 9:57 PM, HarryP Knuckles &

$$Excel-Macros$$ Number Formats in French

2011-10-28 Thread HarryP Knuckles
Hi guys! I have a quick question regarding formats. I have to convert english accounting procedures into French accounting procedures. In English one thousand dollars is equal to $1,000.00. In French one thousand dollars is equal to 1 000,00. the difference is that the comma before a

$$Excel-Macros$$ Hidden Columns and Save Location

2011-09-28 Thread HarryP Knuckles
Good morning guys, You guys have been super helpful! I have a macro that is working well but would like to do two things with it. 1) I would like to have all the columns and rows automatically unhidden for each worksheet. 2) I would like the save location changed to: ‘

$$Excel-Macros$$ Hidden Columns and Save Location

2011-09-28 Thread HarryP Knuckles
Good morning guys, You guys have been super helpful! I have a macro that is working well but would like to do two things with it. 1) I would like to have all the columns and rows automatically unhidden for each worksheet. 2) I would like the save location changed to: ‘

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread HarryP Knuckles
kbook > > On Tue, Sep 20, 2011 at 1:28 AM, HarryP Knuckles > > > > > > wrote: > > Good afternoon, > > > I have 20,000 workbooks that are going to be returned to me shortly > > and i need a template from which i can open the workbooks > > (indi

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread HarryP Knuckles
>   > Paul > - > “Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley >

$$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread HarryP Knuckles
Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can open the workbooks (individually) and have a marco to perform three necessary functions on all of these workbooks (each workbook will have a unique name). My objective is to:

$$Excel-Macros$$ Template to modify workbooks

2011-09-16 Thread HarryP Knuckles
Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can open the workbooks (individually) and have a marco to perform three necessary functions on all of these workbooks (each workbook will have a unique name). My objective is to:

$$Excel-Macros$$ Template to modify workbooks

2011-09-16 Thread HarryP Knuckles
Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can open the workbooks (individually) and have a marco to perform three necessary functions on all of these workbooks (each workbook will have a unique name). My objective is to: