$$Excel-Macros$$ Re: about to remove "#VALUE!" error

Hi friends Why don't you use ISERROR formula with IF formula! Using this you can handle other errors like #REF! with #VALUE! error use =IF(ISERROR(),,) I think this formula is simple enough and should work very unless your formula is too heavy to calculate and you use it in many cells I am s

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

Hi Dhananjay Please find herewith excel file as per your requirement. U just set the currency 0="-" Dhartikumar On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > excel file. > > Can anyone prov

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

Hi Dhananjay Please find herewith excel file as per your requirement. U just set the currency 0="-" Dhartikumar On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > excel file. > > Can anyone pr

$$Excel-Macros$$ Excel to Oracle (urgent Please help)

Hi All, Can anyone help me in loading the excel information to Oracle Applications. I have a list of transactions which I manually enter in to Oracle AP transactions manually. can we record macro which automatically pic the transactions by step and post it to the Oracle Applications tab which I u

$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)

y can either use sendkey or go to a website cld. Www.dataload.net On 8/17/09, bala Subrahmanyam puligadda wrote: > Hi All, > > Can anyone help me in loading the excel information to Oracle Applications. > I have a list of transactions which I manually enter in to Oracle AP > transactions manuall

$$Excel-Macros$$ Re: I need help !!! Thank for all

Hello Friend, How to convert left side to right side? Iqbal On 8/14/09, A alsulaiman wrote: > > I need help > in the attach > > Conversion of data in the Sheet1 > Like in Sheet 2 > What is the Function that can be used > > Thank for all > > > > > -- Iqbal Shaikh --~--~--

$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)

I use Excel as a front-end to an Oracle database EXTENSIVELY. I have over 60,000 lines of code running applications which store ALL of the data to Oracle. I have a sub that connects to the Oracle database. then, I build the SQL command and execute it. if you'd like an example of this approach,

$$Excel-Macros$$ Re: Hiding rows that contain objects (active-X controls)

You can set the atctive-x Move and Size property to adjust when you change the cells. right click on the atctive-x and go to the last tab... 2009/8/14 KMG > > Hi, > > I am writing an application in Excel that will be used by lay people > and need to simplify the appearance of my application as m

$$Excel-Macros$$ Re: Help to break vbaproject password

Hi Roopesh, I am having a software installed in my PC and it's name is xlkey. I got it installed from my vendor at the time of assembling of my system. Let me know if you need any other help. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com di

$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)

Hi Roopesh... Thanks for that... On Mon, Aug 17, 2009 at 1:31 PM, Roopesh Kapur wrote: > > y can either use sendkey or go to a website cld. > Www.dataload.net > > On 8/17/09, bala Subrahmanyam puligadda wrote: > > Hi All, > > > > Can anyone help me in loading the exce

$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)

Hi Paul, I will describe you what exactly I do in Oracle Apps. By taking the information in Excel I will post them in AR Batches - Reciept Batches Reciept #, Amount, Customer# and Invoices # in the next screen. If your process help me. could you please send it to me. Thanks... On Mon, Aug

$$Excel-Macros$$ Re: Independance day

independence day? which country ? On Sat, Aug 15, 2009 at 10:19 AM, Dhananjay Pinjan wrote: > Wishing you all a very happy Independence Day. > > Thanks & Regards, > Dhananjay > > > > --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Please Help Me !!!!!!!!

Dear Freinds, please help me i have a workbook in word there are many pages in workbook but i want Separate workbook for every pages. Regards Amresh --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)

Hi I think you can use the WEB ADI functionaly to upload data in ORacle AP.. On 8/17/09, bala Subrahmanyam puligadda wrote: > > Hi All, > > Can anyone help me in loading the excel information to Oracle > Applications. I have a list of transactions which I manually enter in to > Oracle AP t

$$Excel-Macros$$ Re: Independance day

India celebrated 62th Independence day this year Thanks for asking :) On Aug 17, 5:06 pm, zheng yu wrote: > independence day?  which country ? > > On Sat, Aug 15, 2009 at 10:19 AM, Dhananjay Pinjan wrote: > > > Wishing you all a very happy Independence Day. > > > Thanks & Regards, > > Dhan

$$Excel-Macros$$ Re: I need help !!! Thank for all

right click on sheet1>View Source Code>Sheet1 properties>Diplay right to left>true or Date: Mon, 17 Aug 2009 13:34:14 +0530 Subject: $$Excel-Macros$$ Re: I need help !!! Thank for all From: iqbal.sw...@gmail.com To: excel-macros@googlegroups.com Hello Friend, How to convert left sid

$$Excel-Macros$$ Re: Please Help Me !!!!!!!!

Hi Amresh, Could you please clarify!! "Workbook in Word" Please send a sample file. Regards, Andy On Mon, Aug 17, 2009 at 7:15 PM, amresh kumar wrote: > Dear Freinds, > > please help me > > > i have a workbook in word there are many pages in workbook but i want > Separate > workbook

$$Excel-Macros$$ Re: I need help !!! Thank for all

Dear Shafiq Thanks a ton !! Iqbal S On 8/17/09, shafiq online wrote: > > right click on sheet1>View Source Code>Sheet1 properties>Diplay right to > left>true or > > > > -- > Date: Mon, 17 Aug 2009 13:34:14 +0530 > Subject: $$Excel-Macros$$ Re: I need help !!! Tha

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar)

Respected Master of Excel & friends I am having Excel 2007 version But i can not open the calender in excel sheet - i can not get the tollbar -- where it is ? or please elaborate the system or method to do this good & very inform-able function of calender. Is it-- customize quick access tool

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

Hi Dhananjay, Thanks for encouraging words. This is done using custom format. Whenever you type in zero, it will treat that as "-". Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Aug 17, 2009

$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)

I think I see. Here's the problem though. Oracle is a Database. There are sample tables, but for each APPLICATION, tables are DESIGNed to store data and connect the data to establish relationships between the data elements. It uses SQL to store and retrieve data from the tables. APPLICATIONS are d

$$Excel-Macros$$ Automating Recurring Report tracker

Hi, I have certain reports that recur every 9 days, 16 days, 22 days, 43 days and 76 days respectively. Some of these are workdays and some of them are calendar days. I have a weekly report tracker that lets me track which report is due on a certain week. I want to automate it further. I am trying

$$Excel-Macros$$ Re: Help Reuire for attached file.

Hello, there is lot of lost/forgot cells around table, and lot of formatted cells in column N . Just select cells in the table and copy/paste them to another sheet (by mouse). Best regards, Martin Gasparovic On Aug 17, 1:35 pm, Aligahk06 wrote: > Dear All, > > Attached file is for reference. >

$$Excel-Macros$$ Help with Macro

I am trying to populate cells with a certain addresss from a spreadsheet called Let1 to another spreadsheet called Let2. I have this code in Let1. My problem is that this code will not execute consistently, Even though I may have some value in cell H12 in Let1 the values are not written to Let2.

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar)

It is under Developer tab>Insert> Active X Control>Calendar control 12.0 If u dont see Developer tab, then go to excel options>Populer>Developer Tab to activate the same Regards, Prashant On Mon, Aug 17, 2009 at 6:21 PM, big smile wrote: > Respected Master of Excel & friends > > I am having