Re: $$Excel-Macros$$ Is this possible?

2015-11-17 Thread Paul Schreiner
This is ABSOLUTELY possible.(and actually fun, if you're like me, a sick and twisted geek/nerdy type :) I've done the interface with the Word document before.(it's MUCH easier if you design a FORM with named fields in Word so that you can change the field instead of trying to find words in a

$$Excel-Macros$$ Is this possible?

2015-11-17 Thread Michael K Taylor
I have a potential buyer of a program that she wants to create Reserve Fund Study Reports. It would mean an interface where she could enter data that would complete an Excel spreadsheet or sheets. Subsequently that would populate the corresponding sections of a Word doc. The software must

$$Excel-Macros$$ Re: Type Mismatch error

2015-11-17 Thread Mandeep Baluja
> > Hi Shrini, > Generally this error occurs in case of Type mismatch, There are various possible reasons,lets try to figure this out I can consider you are doing an operation after this if condition you check with that cell and suddenly it encounter a Text entry where it cannot do the

$$Excel-Macros$$ Type Mismatch error

2015-11-17 Thread Shrinivas Shevde
Dear All I Have macro which was running fine for last 2 to 3 years .All of sudden I am facing problem of" "Run Time Error 13 " I tried to find out but I could not. While debugging following line gets highlighted * If (Sheets("Production").Cells(Data.Row, "Z").Value <> "") Then* In declaration