$$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!! URGENT!!!!!

2009-01-06 Thread girishkr...@gmail.com
HI Shay, U hav to add outlook reference to do so. In your macro screen go to Tools->References here search for "Microsoft outlook object library " select the checkbox corresponding to it n the click ok. Now run the macro this has to work.. REgards Girish K Rao On Jan 5, 6:37 pm, "shay shay" w

$$Excel-Macros$$ Re: Obtaining_VBA_MACRO_PASSWORD

2009-01-06 Thread Tariq Kamal
Hi Madhur, Freewares are also available which can open the file and then you can reset the password. Regards, Tariq On Tue, Jan 6, 2009 at 6:59 PM, Tanzeem Ahmad wrote: > Hi Madhur, > > The passwords cud be changed . Like i Changed the password of this VBA to > 1234 > try and check it :) > >

$$Excel-Macros$$ Linking b/w 2 or more systems in Macro.

2009-01-06 Thread KARTHIKEYAN B
Hi, Can anybody extend ur knowledge for me. How to connect 2 or more systems using macro. Example connecting Excel and Mainframe, or Excel and Oracle, Excel and Peoplesoft etc... Also explain how to write a Macro command. Thanks Rgds/Karthik. -- Help the needy with SIMPLE and SAFE(LY)TY LIFE Ka

$$Excel-Macros$$ Re: Excel to PPT

2009-01-06 Thread VIRAL PANDYA
Dear Tom, Many thanks for reply. Just one query we have special slide format. i.e. back ground. once if i define that in my PPT can it be possibel to change just value of the slide? reason for this is we have standared format. that's maroon background and white font and size is say 14 & 12.

$$Excel-Macros$$ Re: Links between Excel and Powerpoint

2009-01-06 Thread Tom Jeffries
The best way to convert your "nasty" file is to create a macro to scan the file and transfer the desired data to a new spreadsheet in the format you want . Without knowing the format of the file I can't be more specific. To create a link from PowerPoint to your Excel file. 1. If you're wor

$$Excel-Macros$$ Re: Excel to PPT

2009-01-06 Thread Tom Jeffries
This may help To create a link from PowerPoint to the info in your Excel file. 1. If you're working with content on a worksheet rather than on a chartsheet and don't want grid lines in your PowerPoint presentation, choose Tools, Options, View and remove the checkmark next to Gridlines; then

$$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!! URGENT!!!!!

2009-01-06 Thread OfficeVba Trainer
Hi Shay, What i suggested is in place of " smtp..com" put your company's smpt or exchhange server name. Thanks Mugundan Office VBA Trainer http://officevbatrainer.blog.co.in/ From: OfficeVba Trainer To: excel-macros@googlegroups.com Sent: Monday, Jan

$$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!! URGENT!!!!!

2009-01-06 Thread shay shay
Hello Ken, After replacing microsoft with my company name then also i am facing an error which is "the sendusing configuration value is invalid" Regards, Shay On Tue, Jan 6, 2009 at 5:48 PM, shay shay wrote: > Hello Ken, > > I am still facing the broblem. It says as Transport fai

$$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!! URGENT!!!!!

2009-01-06 Thread shay shay
Hello Ken, I am still facing the broblem. It says as Transport failed to connect to the server. I am attaching the excel also. Regards, Shay On Mon, Jan 5, 2009 at 8:15 PM, OfficeVba Trainer < officevbatrai...@yahoo.com> wrote: > Hi Shay, > > Here is the solution. just change t

$$Excel-Macros$$ programming

2009-01-06 Thread tegi
how can I add column and row in the middle of my worksheet using C# programming language. so can any one tell me about it. I would like to Thank you in advance --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com

$$Excel-Macros$$ Re: Excel Macro

2009-01-06 Thread Kamal Gulati
Dear Mr. Tom, Even I also required some more examples on Excel, VB and Access for Macro. If you any material for the same kindly send to me. Thanks and regards, Kamal Gulati On Tue, Jan 6, 2009 at 2:14 PM, vijender kumar wrote: > Hi Tom, > > Thanks this book is very useful. but do you have any

$$Excel-Macros$$ Re: Obtaining_VBA_MACRO_PASSWORD

2009-01-06 Thread madhur baharani
Dear All, Please resolve the VBA_PASSWORD_FINDER issue if someone know's it's solution as soon as possible. It's very urgent. On 1/5/09, madhur baharani wrote: > > > Please find the attachment & provide the solution of recovering a VBA > password. > Since i have too many macro sheet

$$Excel-Macros$$ Excel to PPT

2009-01-06 Thread VIRAL PANDYA
Dear All, I am Viral. Working in as MIS Executive. Every month I need to creat a detailed presentation for our monthly perfromance meeting. Can you help me with code that convert my date from Excel to current open powerpoint file in defined slide? Briefing you more abt what i want is... we ha

$$Excel-Macros$$ Re: Retrieving domain name using VBA

2009-01-06 Thread Alokeshwar Tiwary
Wow.. i didn't know that it will be so easy.. thanx a ton..   _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know w

$$Excel-Macros$$ Re: Excel Macro

2009-01-06 Thread vijender kumar
Hi Tom, Thanks this book is very useful. but do you have any such book which has more examples of macro .I am very keen to learn macros to automate most of my process. Thanks. On 1/4/09, Kamal Gulati wrote: > > Thanks a lot Mr. Tom, for the nice file for the Macro. > > Could you al

$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-06 Thread Keyur Shah
thanks for response But did not want to hide entire column i want to hide only data enter in the column. Coulm should be visible but data entered in that column should not be visible to everyone. On Tue, Jan 6, 2009 at 12:33 PM, vijender kumar wrote: > Hi ... > > you can hide the column in very

$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-06 Thread vijender kumar
Hi ... you can hide the column in very simple way Select the column > Right Click with your Mouse > click on Hide On 1/5/09, Keyur Shah wrote: > > hi, > > Can anybody guide me how to hide data in column sothat no one can visible > and i want to lock sheet that mouse pointer move only selected

$$Excel-Macros$$ Re: Retrieving domain name using VBA

2009-01-06 Thread lohith
Hi Alok, Try this command : Environ("UserDomain") Cheers, Lohith On Jan 6, 10:16 am, Alokeshwar Tiwary wrote: > Is there a way to retrieve domain name using vba...? I need this to make sure > that my vba tool will run only within the network of my compay. > > Thanks and Regards, > Alokeshwa