Search results for query: *

Thanks for the help guys. I'm off to Fry's Electronics. : )

Here is the situation: I have client that has a boardroom with a Dell Projector that they want CEILING mounted. The problem is that the CONDUIT that feeds from the ceiling through the cement floor to the bottom of the table is too small to fit the VGA connector through. So, is there a way to...

I have a weird one. I am saving an Excel file as a CSV file and the first 15 rows of data have extra commas at the end of the record. The extra commas are due to two column headings at the end which have no data in the rows. I can delete a bunch of columns to the right of the data and even...

Ok, so the CEO wants to know how many Internet messages a specific user is sending out. Sounds simple enough I guess, but those damn execs always take relatively complex matters and trivialize them. So, we are running Exchange 5.5 and there are about 200 users. IMC has the enable message...

Okay, so my little survey proves that I AM in fact the only one on planet EARTH that still uses Excel 4 macro language and there is only one other person in the world that has even a memory to go back that far. Wow!!! I am pathetic. L8r

Great additional thought Glenn. You guys are awesome! Here I thought I knew some stuff about Excel. I am constantly surprised by my ignorance. "The more you know, the more you know you don't" - my own little quote I like. Cheers!!!!!!

Skip, thanks again!!! That works like a charm! No more fear of those damn fixed width formats with headers, detail rows and trailers. I used to grimace and sweat in pure fear having to tame those wild tigers...now I smile and cheer. Bring it on!!!!!!!! Ok, so I am a little dramatic. In any...

Am I the only one in the universe that still uses the Excel 4 macro language???????? I know vba is supposed to be better but if I'm just moving some data here or there isn't Excel 4 Macro Language as simple as it gets???? I love it and was just wondering if I was an extinct bird...

Wow!!! I am going to have to disect that a bit to understand it. Thanks so much for the help!!!!

I'm sorry Skip I must have mis-understood you. The records I posted are what the FINAL TEXT file should look like. The only records that I actually have in Excel would be the "D" records and those would be in columns like: SS# Amt Name 545-55-6677 33.55 Joe...

I guess the records below would be what they want. I wonder if Excel is the best program to use for this. Ideally, the end user should just click a button and the macro should format it all and save it as a text file. Thanks in advance!!!!!!! ::: SAMPLE ...

I have a flat table that needs to get converted into a fixed width text file for a bank. They want a header record with mostly static info, detail records and a trailing record with totals. Does anyone have any brilliant ideas on how to create such a beast?? Thanks in advance. Specifics...

Well that is very in depth and I'm sure a challenge to code. I really like the idea that you can just hover over the doc and the comments show the critical info. Nice touch!! ttl

Wow...this could definitely turn into a large project. :) 1. Well that would be awesome. For my purposes, it is more of a "executive approval" so once they "sign" it, it will be emailed to the next person who then enters the info into the AS400. I guess prints it out if necessary too. 2. I...

FUMEI - Email to you got returned...host unknown. Here was my original message.... Thanks so much for your assistance with this. I must tell you though I am strictly a novice at programming. I know enough to be dangerous but really am a total rookie. With that being said, really my only...

Any ideas guys??? Thank you in advance......

Are you using the SUBTOTALS menu option that creates an outline, a filter, the subtotals worksheet function or a combination of all of those??? Are the product line items/Customers unique?? In other words, is there only one row for each product for each customer?? If so, then you should be...

Wow, you guys are awesome but I think I need to clarify a bit. fumei - thank you for your comments and you are right I need to explain a bit better....so here we go! I have a Word Template that is also a password protected form. It is a "Credit Memo" form and has a bunch of fields that get...

Yes sir I have run the SelfCert. Now what? Sorry but I need to go back to gradeschool on this one. Thanks so much!!

I need help with digital signatures. I have searched the web and there are hundreds of solutions. All I need is the ability to digitally sign a WORD document which then prevents the contents from being changed. I would prefer little or no additional software for each client computer. Also, I...