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 Excel
Open excel
data=>import External Data = >select datasource=>select the appropriate
option=>ok
On Tue, Jul 12, 2011 at 8:22 AM, Susan 1 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 into appropria
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 wrote:
> Hi Daniel
>
> Thanks for code. Have done as you suggest and installed in the Shipments
> wb. When I run the code it goies t
Dear Vasant,
Thanks friend. It's good.
Regards,
Dilan
On Thu, Jul 7, 2011 at 8:14 PM, Vasant 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) <> "" Then
>
Range("a65356").End(xlUp).Offset(1, 0).Value = Range("a65356").End(xlUp).Row
On Mon, Jul 11, 2011 at 10:50 PM, SAJID MEMON wrote:
> 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 thi
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 @ http://www.linkedin.com/groups?gid=1871
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 with
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,
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 =
CreateObject("Excel
Is there any way to remove file open password in excel
Regards
Santosh Bahuguna
On Mon, Jul 4, 2011 at 10:56 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Thanks a lot its working fine. :)
>
>
> On Mon, Jul 4, 2011 at 4:46 PM, Venkatesan c wrote:
>
>> Hi
>>
>> just install the so
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 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 cod
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 wrote:
> Thanks Vasant Its w
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. Join
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 @ http://www.linkedin.com/g
*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~~
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 t
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
I
try this
VLOOKUP(A1&"*",Sheet1!$A:$A,1,0)
On Mon, Jul 11, 2011 at 3:42 PM, Anish Shrivastava wrote:
> 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 match i
ActiveSheet.Name = Day(Now) & "-" & Application.WorksheetFunction.Text(Now,
"")
On Mon, Jul 11, 2011 at 5:22 PM, Prabhu wrote:
> Hi,
>
> Is it possible to rename the active sheet with current date&month.Current
> date must be the date when i run the macro.
>
> Example if i run the macro on
Hi,
Is it possible to rename the active sheet with current date&month.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 wrote:
> Thanks Vasant Its working fine, Please can you also advise coding for
> only converting HTML file into Excel...
>
> On Jul 6, 8:57 pm, Vasant wrote:
>
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.
Hop
*
*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
Date: Mon, Jul 11, 2011 at 4:38 PM
Subject: Re: $$Excel-Macros$$ vlookup query
To: PRADEEP KUMAR KOKNE
*hi pradeep
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 Genentech&Lifetech Open data same in closed tab i want to pu
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 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 Sat, Jul 9,
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 repl
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:
P
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 work
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 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 wrote:
> *Which is the Column of Client Name.?
31 matches
Mail list logo
