*where is query?
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas
venkateshs@gmail.com wrote:
please shoot your query
On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP
*can u explain ur requirement with a sample file?, i m not getting it
properly
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sun, Jul 10, 2011 at 10:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Which is the
Hi Try This
Sub MakeCobmination()
Application.ScreenUpdating = False
Dim t As Double
Dim Digit As Double
Dim SS As Double
Dim j As Double
Combination = InputBox(Enter Digit )
SS = 2 ^ Combination
If Val(Combination) 20 Then
MsgBox you Can give till 20 ,
Can you mail the sheet password back ?
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bob
Envoyé : dimanche 10 juillet 2011 20:57
À : excel-macros@googlegroups.com
Objet : Re: RE: $$Excel-Macros$$ Help with formula
Here is the file. On the Quote
Dear Friend,
Would you please send a formula of MS Access regarding FIFO
Thanking you
Sanjib
On Sat, Jul 9, 2011 at 12:46 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Friend,
Can you please send a formula how to use a FIFO method in MS ACCESS?
Waiting for your reply
Hi
Can some one write a macro as per the attach files.
i need a loop fo
On Mon, Jul 11, 2011 at 11:37 AM, ankur ankurpande...@gmail.com wrote:
*where is query?
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On
It's not the methode to save the created workbook but it's about the trick
to create a workbook* with a specific name* *without* saving it.
You'd like to see the code, it has nothing to do with this isue because this
routine creates the export before creating the workbook it self.
But anyway:
Hi,Thanks for taking initiative ,
See there are two Clients:-
1 Genentech
2 Lifetech
Both have three tabs Open,closed,Rejection that means total 6 tabs but i
want only three tabs named Open,close,Rejection,in Open tab i want to put
all GenentechLifetech Open data same in closed tab i want to put
*
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
-- Forwarded message --
From: ankur ankurpande...@gmail.com
Date: Mon, Jul 11, 2011 at 4:38 PM
Subject: Re: $$Excel-Macros$$ vlookup query
To: PRADEEP
Hi,
Is it possible to rename the active sheet with current datemonth.Current
date must be the date when i run the macro.
Example if i run the macro on 11th of July, Sheet name has to be 11-July
Thanks,
Prabhu.
--
Thanks Vasant Its working fine, Please can you also advise coding for
only converting HTML file into Excel...
On Jul 8, 2:16 pm, SHREE chidurala.sh...@gmail.com wrote:
Thanks Vasant Its working fine, Please can you also advise coding for
only converting HTML file into Excel...
On Jul 6, 8:57
Dear experts
I have attached my file, for renaming sheet with adding one sheet (1001) only
at once click
when we press once command button only one sheet should be created as name 1001
again when i press second time press that button second sheet should be created
as name 1002 and so on.
ActiveSheet.Name = Day(Now) - Application.WorksheetFunction.Text(Now,
)
On Mon, Jul 11, 2011 at 5:22 PM, Prabhu prabhugate...@gmail.com wrote:
Hi,
Is it possible to rename the active sheet with current datemonth.Current
date must be the date when i run the macro.
Example if i run
try this
VLOOKUP(A1*,Sheet1!$A:$A,1,0)
On Mon, Jul 11, 2011 at 3:42 PM, Anish Shrivastava anish@gmail.comwrote:
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column A.
I want to find the best possible
try this
Option Compare Text
Sub test()
Dim i As Long
Dim swa As Boolean
Dim ws As Worksheet
Sheets(1).Select
For i = 2 To Sheets(1).Range(a2).End(xlDown).Row
swa = False
For Each ws In ThisWorkbook.Sheets
If Sheets(1).Range(a i).Value = ws.Name Then
swa = True
Exit For
End If
Next ws
If
Hi Ashish,
This one looks great but it will only help if few of the characters at the
end of the text is missing.
For Example - Guitar Center, . (row # 1650) in the 2nd sheet is not able
to find the value because it's Guitar Center, Inc. in sheet one.
*I wanted something like which matches the
*hi shree
see below link to convert html to excel
may this help u
http://www.mrkent.com/tools/converter/
http://www.designdetector.com/archives/05/07/HTMLToExcelTheEasyWay.php
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
Thanks Ashish,
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hi Shree,
Apologies for the delay ..
Pls let me know what kind of HTML file would you like to convert ?
Could you pls send me those html files ?
btw
You can also use third party tools what Ankur has mentioned in his mail.
On Mon, Jul 11, 2011 at 5:11 PM, SHREE chidurala.sh...@gmail.com
Hi,
I need to SaveAs workbook without VBA code in it.
Thanks,
Chandra Shekar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
Hi Chandra Shekar,
I assume your query is incomplete. However I will try to answer..
If you want to save a macro free (no vba code in it) workbook, you should
save it as .xlsx. Remember there will be no macros in this file.
I hope you know the shortcut key for Save As (F12).
If you want a code
Dear Ashish sir Thanks to co-operate me in my project
Now i want when in click in a command button auto serial number should fill in
A1, then A2 ... like this
In 50 times i click on that command button then 1 to 50 should fillup in A1 to
A50
Hope you will give me better tips or example
Hi,
I think following code will answer your question. This is in VB Script.
Set objFileSystemObject = CreateObject(Scripting.FileSystemObject)
strResultFilePath='Enter the File Path Here.
If Not objFileSystemObject.FileExists(strResultFilePath) Then
Set objResultExcel =
You can also save your file in xlsx format if you dont want to save your
Code in Workbook..
On Mon, Jul 11, 2011 at 7:30 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
I need to SaveAs workbook without VBA code in it.
Thanks,
Chandra Shekar
--
Hi All,
i could resolve the issue. the answer is as below (if anybody wants to know)
initially the scope for all the nameranges was WORKBOOK but wen i was
increasing
the range of namerange scope for few nameranges was becoming SHEET and
therefore
there were 2 nameranges with same name. 1
oops sorry, 291log
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Range(a65356).End(xlUp).Offset(1, 0).Value = Range(a65356).End(xlUp).Row
On Mon, Jul 11, 2011 at 10:50 PM, SAJID MEMON sajidwi...@hotmail.comwrote:
Dear Ashish sir Thanks to co-operate me in my project
Now i want when in click in a command button auto serial number should fill
in A1, then
Dear Vasant,
Thanks friend. It's good.
Regards,
Dilan
On Thu, Jul 7, 2011 at 8:14 PM, Vasant vasant...@gmail.com wrote:
Try this...
Sub test()
Dim Wksht As Worksheet
Set Wksht = ThisWorkbook.Worksheets(1)
Lrow = Wksht.Range(C65536).End(xlUp).Row
For x = 10 To Lrow
If Wksht.Cells(x, 5)
Hi
Is someone able to comment on my problem as below. Tried to contact Daniel
with no luck.
Thankyou
Charlie Harris
On Fri, Jul 8, 2011 at 1:13 PM, Cab Boose swch...@gmail.com wrote:
Hi Daniel
Thanks for code. Have done as you suggest and installed in the Shipments
wb. When I run the
Open excel
data=import External Data = select datasource=select the appropriate
option=ok
On Tue, Jul 12, 2011 at 8:22 AM, Susan 1 sunni...@gmail.com wrote:
Hi,
Need your help. How can I do this project faster than manually CTRL+ X ,
then CTRL+ V , to delete and paste contact information
Hi,
Thanks all. I have created a macro which does calculation steps and create
some pivots upto this its working fine. I am looking for a code where I need
to Saveas the file where I need to remove all the modules in the new
workbook. Hope this is clear than previous mail.
*Note: I am using
31 matches
Mail list logo