Dear Paul,
How can we create a list of the 15 report files in a sheet?
Kindly explain the same with example that will help a lot.
Thanks & Regards,
Sagar
On Wed, Sep 12, 2012 at 5:46 PM, dguillett1 wrote:
> As Paul said, there is a better way. Provide a file.
>
> Don Guillett
> Microsoft Exce
whr is the attachment??
On Fri, Sep 14, 2012 at 10:26 AM, Amit Desai (MERU) wrote:
> Please help me understand, how this works?
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* Prince Dubey [mailto:prince141...@gmail.com]
> *Sent:* 13 September 2012 23:16
> *To:* excel
Can u please explain it more ?Not understood
On Fri, Sep 14, 2012 at 11:16 AM, Jaideep Panchal wrote:
> Hi group,
>
> ** **
>
> ** **
>
> I need some help in putting sum formula and hope u all will provide a good
> help as always…..
>
> ** **
>
> ** **
>
> I am attaching a sheet in which
Hi,
Pls you provide sample files.
Regards,
Swapnil.
On Thu, Sep 13, 2012 at 11:03 PM, wirelesscellularguy <
wirelesscellular...@gmail.com> wrote:
> Hi All,
>
> I am trying to query my Access Database(Database1.accdb) through vba.
> I am getting run-time error 3170 at the highlighted line.
>
>
Hi,
If you want to populate combo boxes using minimum code then create saperate
function to populate combobox and then call that function for each
combobox. Following is the sample code:
1. Create function to populate combobox
Function populateCombo(rst as ADODB.Recordset, cmb as ComboBox)
Thanks to all of you.
On Fri, Sep 14, 2012 at 9:43 AM, Shrinivas Shevde wrote:
> Heartist congrates Noorani sir.
>
>
>
> On Thu, Sep 13, 2012 at 9:26 PM, Excel Vba wrote:
>
>> Congrats Sir Ji
>>
>>
>>
>> On Thu, Sep 13, 2012 at 12:57 AM, Dhananjay Pinjan wrote:
>>
>>> Hertiest Congrat
Please help me understand, how this works?
Best Regards,
Amit
From: Prince Dubey [mailto:prince141...@gmail.com]
Sent: 13 September 2012 23:16
To: excel-macros@googlegroups.com
Cc: Amit Desai (MERU); Amit Desai (MERU)
Subject: Re: Sorting all the sheets together
Hi Amit,
Pls see the attachment
Hi Amit,
1st Select Your Data & Press Shortcut Key: - Alt+H+S+S. Expand the
selection & Click Short button.
[image: Inline image 1]
Regards,
Kuldeep Singh
On Thu, Sep 13, 2012 at 9:16 PM, >>Excel Beginner<< wrote:
> Hi Amit,
>
> First Select Your Data and Using this shortcut
Heartist congrates Noorani sir.
On Thu, Sep 13, 2012 at 9:26 PM, Excel Vba wrote:
> Congrats Sir Ji
>
>
>
> On Thu, Sep 13, 2012 at 12:57 AM, Dhananjay Pinjan wrote:
>
>> Hertiest Congrats Noorain Ansari. Do continue. Best Luck
>>
>> On 9/12/12, SAGAR KASANGOTTUWAR wrote:
>
Dear Rajan
Very very thanks for reply.
Can u make me understand meaning of (*#,##;-#,##;;@ )*
*this will be helpful for me i future*
**
Regards
Shrinivas
On Thu, Sep 13, 2012 at 7:36 PM, Rajan_Verma wrote:
> *Why Don’t try Custom format *
>
> *#,##;-#,##;;@*
>
> * *
>
> * *
>
> *Regards*
>
>
Hi Shrini,
You need not to do anything just follow below mentioned steps
1: right click on the cell having Zero in it.
2: Choose format cell
3:Select Custome In Category Section
4:Type *;;; (Three semicolons)* under Type Hading
5:Click Ok Thats It
Ragards
Prince .
On Thursday, September 13, 201
Hi Shrini.
Please follow steps mentioned.
1: right click on the cell having zero in it.
2:Select format cells
3:Select Custom In category section
4:Type (*;;;*) three semicolons under type hading.
Thats it.
Regards
Prince
On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
>
>
Hi Shrini,
Do the following
1 : Right click on the cell
2: Select format cells
3: Select *Custom *under Category section
4: Type (*;;;*) Three Semi Colons under type heading and Click OK
thats it.
regards
Prince
On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
>
> Dear Al
Hi Amit,
First Select Your Data and Using this shortcut Key
>> Alt+A+A
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Sep 13, 2012 at 5:37 PM, Amit Desai (MERU)
wrote:
> Please let me know if we have an easier way for sorting data all
> together in all sheet having common column
Hi Amit,
Pls see the attachment
regards
prince
On Thursday, September 13, 2012 5:37:34 PM UTC+5:30, Amit Desai (MERU)
wrote:
>
> Please let me know if we have an easier way for sorting data all
> together in all sheet having common column heads.
>
>
>
> Best Regards,
>
> Amit
>
>
>
> --
Hi All,
I am trying to query my Access Database(Database1.accdb) through vba.
I am getting run-time error 3170 at the highlighted line.
Sub GetData()
Dim MyDatabase As DAO.Database
Dim MyQueryDef As DAO.QueryDef
Dim MyRecordset As DAO.Recordset
Dim i As Integer
Set MyDatabase = DBEngine.OpenD
Hi Amar,
In excel you can insert any image file and by using VBA you can make their
visibility false and true so the same thing happening in this file.
regards
prince
On Thursday, September 13, 2012 1:20:43 PM UTC+5:30, amar takale wrote:
>
> Hi All,
> I found above file on web. But I cant und
What ???
Have you TRIED to look at the Help for the function?
Simply go to the function Wizard, select BIN2DEC
and hit the "Help on this Function" link.
It tells us that BIN2DEC :
Converts a binary number to decimal.
If you don't encounter binary numbers, then you'll have no need of this
funct
it coverts binary to decimal
http://www.techonthenet.com/excel/formulas/bin2dec.php
http://office.microsoft.com/en-us/excel-help/bin2dec-HP005209002.aspx
On Thu, Sep 13, 2012 at 9:59 PM, Kuldeep Singh wrote:
>
> Hi Experts,
>
> What is use BIN2DEC function. Kindly tell me something with exampl
Means ??
regards
prince
On Thursday, September 13, 2012 7:40:41 PM UTC+5:30, Hemant wrote:
>
> Hi Group,
>
>
> I want to know how Circle Invalid function works in excel and vba.
>
>
> Regards,
> Hemant.
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
Hi Experts,
What is use BIN2DEC function. Kindly tell me something with example.
Regards,
Kuldeep Singh
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor t
There is a Data Validation option to Circle Invalid DAta -- data that does
not match the data validation rule for its cell.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Excel Vba
Sent: Thursday, September 13, 2012 8:46 AM
To: excel-macros@googl
Congrats Sir Ji
On Thu, Sep 13, 2012 at 12:57 AM, Dhananjay Pinjan wrote:
> Hertiest Congrats Noorain Ansari. Do continue. Best Luck
>
> On 9/12/12, SAGAR KASANGOTTUWAR wrote:
> > Congratulations Noorain...
> >
> > Best Regards,
> >
> > sagar
> >
> > On Tue, Sep 11, 2012 at
I think it is excel 2010 version. When you goto Data tab, then select Data
validation drop down.
You will find second option. It automatically select the invalid data.
On Thu, Sep 13, 2012 at 8:13 PM, Paul Schreiner wrote:
> Circle Invalid?
>
> Are you refering to a "Circular Reference"?
>
> I
Circle Invalid?
Are you refering to a "Circular Reference"?
I've never heard of a "Circle Invalid function".
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all th
Not getting your problem???
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Excel Vba
Sent: 13 September 2012 7:40
To: excelvbacli...@googlegroups.com
Subject: $$Excel-Macros$$ Query - Circle Invalid
Insert - Pictures
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 13 September 2012 5:42
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: How to create this file?
If you will Execute this line
Sheet1.pictures.visible=1
You will get all the pictures visible..
Range F1 has a formula to vookup the picture name , and on Calculate event
only that picture is being visible
Nothing more than it
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
Hi Group,
I want to know how Circle Invalid function works in excel and vba.
Regards,
Hemant.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread ti
Why Don't try Custom format
#,##;-#,##;;@
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 13 September 2012 2:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Dear Rajender
Thanks for reply
You say bcos of VBA the visibility all images not show but if I create same
file like this then how to create file.How to photo upload or import
On Thu, Sep 13, 2012 at 4:03 PM, Soni.Rajender wrote:
> Dear Amar
>
> 1. The images are there on Sheet1, You can check t
Please let me know if we have an easier way for sorting data all together in
all sheet having common column heads.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged informati
Dear Saran,
Thanks for Reply but I used excel 2003 So there are no any option for me
like you tell me solution excel 2007
So pls tell me about 2003 excel solution
Thanks Amar
On Thu, Sep 13, 2012 at 4:26 PM, Saran wrote:
> We can create interactive images, by using Vlookup, Indirect formula and
Dear Kuldeep/Noorani/David
Very very thanks for kind help
Regards
Shrinivas
On Thu, Sep 13, 2012 at 4:24 PM, David Grugeon wrote:
> File/Options/Advanced/Display options for this worksheet
> untick "Show a zero in cells that have a zero value"
>
> This will only work on the active sheet. If y
You could use this custom format
#,###.00;-#,###.00;;@
The first section, before the first semicolon, is the format for
positive numbers; the second is negative numbers; the third is for not
displaying zeros; and the fourth displays text as text.
Regards
David Grugeon
On 13 September 2012 20:3
We can create interactive images, by using Vlookup, Indirect formula and
camera tool
How to create interactive images.
http://lostinexcel.blogspot.sg/2012/08/How-to-make-interactive-images-in-ms-excel-camera-option-vlookup-indirect-formula-data-validation-define-name.html
Hope, the above link
File/Options/Advanced/Display options for this worksheet
untick "Show a zero in cells that have a zero value"
This will only work on the active sheet. If you want it to apply to
the whole workbook select all sheets first.
If you want it to apply to new workbooks you create you will need to
modify
Dear Amar
1. The images are there on Sheet1, You can check the same by pressing *F5
- Special - Objects*, this will work on sheet1 but will show error on
sheet2 - "No objects found".
2. By using VBA the visibility of all images in sheet1 are set to False
*(Me.Pictures.Visible
= False) *ex
Oh Yes, Pravin thanks allot for notifying me about my error.
On Thursday, 13 September 2012 15:36:59 UTC+5:30, Pravin Gunjal wrote:
>
> *Dear Prince : *If we enter any other value also instead of zero it show
> blank.
>
> *Dear Shrini : **You may use this one : *Go to Excel Options (Alt+T+O)
> -
That's what Noorain did.
On Thu, Sep 13, 2012 at 3:50 PM, Soni.Rajender wrote:
> Hi
>
> The same can also be done using conditional formatting.
>
> Regards
> Rajender Soni
>
> On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
>
>> Dear All
>>
>> If i enter 0(zero) in any cell.it
Hi Swapnil,
I could populate the 2ns combo-box by repeating the code used to populate
ComboBox1. But in this way, if i need to populate other ActiveX Controls,
the code size will become unnecessarily large. Can it be done with few code
lines? I am pasting the code used by me to populate the two
Hi
The same can also be done using conditional formatting.
Regards
Rajender Soni
On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
> Dear All
>
> If i enter 0(zero) in any cell.it should show blank cell.
> It should not show the zero.
> lease let me know how to do it
> Tha
Hi Swapnil,
Please go thru the procedureand suggest to modify the code for the 2nd
combo-box
With com
.ActiveConnection = con
.CommandText = "Select DISTINCT [Date] from DR ORDER BY [Date]"
.CommandType = adCmdText
End With
Set rst = New ADODB.Recordset
Hi Swapnil,
I have done that. And I got the unique values in the drop down. But in the
second combo-box, i am trying to retrieve other category with same
procedure. But in vain. Can you please suggest?
On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>
> Hi All,
>
> I
*Dear Prince : *If we enter any other value also instead of zero it show
blank.
*Dear Shrini : **You may use this one : *Go to Excel Options (Alt+T+O) -->
Click on Advanced --> Display options for this worksheets --> remove the
tick mark from : Show a zero in cells that have zero value.
Regards
Hi Shrini,
Do the following
1 : Right click on the cell
2: Select format cells
3: Select Custom under Category section
4: Type (;;;) Three Semi Colons under type heading and Click OK
thats it.
On Thursday, 13 September 2012 12:40:13 UTC+5:30, shrini wrote:
>
> Dear All
>
> If i enter 0(zero
Hi,
You can populate the combo-box with unique items using "Select distinct "
query
Do following steps:
1. Store "Select distinct" query data in Record Set
2. Loop through record set and add values to the Combo Box
Regards,
Swapnil.
On Thu, Sep 13, 2012 at 11:21 AM, wirelesscellularguy <
wire
In this example (Lookup photo) used VBA Also.Pls see VBA code .I attached
link where from I download Example file. See below
*http://www.mcgimpsey.com/excel/lookuppics.html*
On Thu, Sep 13, 2012 at 1:20 PM, amar takale wrote:
> Hi All,
> I found above file on web. But I cant understand this fi
Dear Kuldeep
Thanks for reply but where do I use this formula .
can u attached file and show it to me.
If I enter "0" in A1 then it should not take it should show cell blank
Thanks
Regards
Shrinivas
On Thu, Sep 13, 2012 at 12:43 PM, Kuldeep Singh wrote:
>
> Hi,
>
> Try This.
>
> =IFERROR(IF(A1
Hi,
Try This.
=IFERROR(IF(A1,"0",""),"")
Regards,
Kuldeep Singh
On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde
wrote:
> Dear All
>
> If i enter 0(zero) in any cell.it should show blank cell.
> It should not show the zero.
> lease let me know how to do it
> Thanks in advance
>
> --
> Shrini
Dear All
If i enter 0(zero) in any cell.it should show blank cell.
It should not show the zero.
lease let me know how to do it
Thanks in advance
--
Shrini
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violat
51 matches
Mail list logo