$$Excel-Macros$$ VBA Error Handling Video

Hi All, I recently had to give some guidance to some other developers regarding error handling in VBA. I have put this guidance into a short video which I thought might be helpful to developers on this group. http://technicana.com/vbaSection/Videos/ErrorHandling.html Regards, Chris Spicer

$$Excel-Macros$$ Re: how to extract text from a cell? urgent need !!!

Dear Ankur, Solved workbook is attached with this reply. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sat, Jun 13, 2009 at 3:42 PM, ankur ankurpande...@gmail.com wrote: Dear Friends there

$$Excel-Macros$$ Print to pdf using sendkeys

Hi, I wonder if someone can help me. I am trying to print a Excel document to Acrobat using the Adobe PDF printer driver. I can get the initial print dialog box up fine (where you can select the driver, etc.), and can send an {ENTER} to progress to the next dialog where you must input the

$$Excel-Macros$$ Text in excel

When designing a form in excel where there will be merged cells that contain alot of text what is the best way to display that text when the text is more than the merged cells visibly show. Will also need to print all test in that area. Can I make the merged cell grow automatically as more text

$$Excel-Macros$$ BEST EXCEL TIP WEEK # 25 Submit your TIP here only

Dear Members, Thanks for your great response in the Week 24 competition. It was great learning for the members of the group. I was delighted with the response of members on this initiative. The winner of week # 24 will be declared soon. Keep watching this Space.. Let us begin week # 25 quiz

$$Excel-Macros$$ getting the value from a cell that has a forumla in it

I'm sorry if this is a really simple question or if the answer could be found in the archives, I could not find it. I have a workseet with a simple that has a simple forumula =D21*D20 in VBA, I need to get the value of that cell. Thanks for your help, I hope it is something very simple, sorry

$$Excel-Macros$$ Matching up two columns with different data

Okay, so here's my dilemma. I have 2 different systems that I am trying to match up. System A has about 1600 lines, system B has about 1000. A is the older system and has a lot of lines that don't matter much anymore. B has some things that aren't in A, but doesn't need a lot of the stuff in

$$Excel-Macros$$ Re: importing multiple data files (csv)

Sorry for the delay. I've never worked with microsofts programming languages, so I've been experimenting when I have time. Here is what I've learned from monkeying around with the macro recorder. The file selected when using the Data - input external data function has a name property. And I

$$Excel-Macros$$ Re: getting the value from a cell that has a forumla in it

Hi, Include this line in the code: A = Range(D21).Value * Range(D20).Value The variable 'A' will store the number you're looking for. Regards - Dave. Date: Mon, 15 Jun 2009 14:35:29 -0700 Subject: $$Excel-Macros$$ getting the value from a cell that has a forumla in it From:

$$Excel-Macros$$ Re: Help required

Dear Sir/Madam, We are an active users of excel. We are using Excel 2007 in our office. I would like to know is to how to protect all the sheets in the workbook without using the macro. Regards Bhairav --~--~-~--~~~---~--~~