Recent content by rcrecelius

Thank you gentlemen, stars for all of you! XWB, to answer your question, there was a single instance of Excel open in task mgr after running the script. After exploring the options/suggestions, this is what I ended up with, which seems to do what I need. Set ExcelObject =...

Forgive me, I dont know vbs, I searched and searched for what I have so far and feel like I am very close to a solution on this. All files are in the same folder, currently on my laptop. The task at hand is... 1.Take 3 xls files and convert them to txt 2.Combine the txt files into a single...

I'm on 2010. I saved this to the hidden Personal workbook like I do all my other macros so I can use it with any workbook...I see now, I would have to type in "=PERSONAL.XLSB!Strip_Dashes(A1)" What should I have done differently to just type in "=strip_dashes(A1)"? Its not a big deal really...

A star to both of you for helping me with this...I saved both versions and so far they both work well. It did take me a bit to figure out how to actually run the function as I was still thinking in terms of a macro with an assigned keyboard shortcut. Once I zoned in on the fact that this was a...

Andy, See the last part Of the original post for an example...yes there can be multiple dashes.

Andy, Definitely yes that sounds appealing. You might have to walk me through it...I use macro's but havent looked at the actual VBA code in a long time.

thread68-907911 Back in 2004 I asked this question and KenWright gave me a formula that has saved me countless hours of frustration...so let me starrt by saying thanks again Ken! Now today, I am realizing that this formula does have a shortfall. Here is my original question from 2004 I have...

Text files - 2...1 with Pricing data, the other w/inventory. Hehe...yes, still looking for an answer...I'll be in meetings most all day today and tomorrow and I'd told the customer that I'd have him something by the end of the week so the deadline was somewhat self-imposed. Actually I think...

Im sorry for the lack of detail in my questions...I was overwhelmed and really needed this finished yesterday and was scrambling to find an answer. Funny but now that the deadline is past I feel better about it. Database is a Unix platform running Activant Prism software...I can create reports...

Sorry, struggle is exactly what I'm doing as I have a deadline of right now on this project...I know vlookups well, other things not so well so I'm sure there is a better way to achieve the desired outcome. I am trying to create a price file by extracting data out of the database and marrying...

I have this formula working as is but it needs 1 more "IF" added to it...Ive never created a formula this lengthy but I thought I could do 7 "IF's" without a problem. here is the formula... =IF(VLOOKUP(H2,A:E,5,TRUE)="M",IF(VLOOKUP(H2,A:G,7,TRUE)="A",(VLOOKUP(H2,A:F,6,TRUE)/100)*O2)...

I have several remote sites that are connected to our database via Frame Relay...they also have local Internet access. I used the solution found in this article to connect the PC's to both networks. http://www.tek-tips.com/viewthread.cfm?qid=1006195 Now I have a SOnicwall at 3 of these...

I created a shortcut to Microsoft Word(several different ways) and every time it is not visible on the desktop but I can see all the shortcuts when I explore the desktop folder. I checked the shortcuts properties and they are not hidden. Theres probably a good/easy explanation for this but this...

Thanks Chip, I didnt know you could use the Win2k Recovery Console in NT 4.0 either but it sure is good info to have. I appreciate all your suggestions...I didnt have access to ERD Commander or I would have tried it too.

I finally got this machine back up and running. It didnt have a cd drive (floppy and 2 sided dvd) so I temporarily installed one and tried several things...UBCD wouldnt boot up, Bart PE wouldnt boot, my Win NT disc would work and I got into the repair section but didnt change anything because...