its work
thank you sir,
nandkumar
On Mon, Apr 4, 2011 at 9:01 AM, STDEV(i) wrote:
> The 'real' deleting rows
>
> Sub RemoveBlankRows()
>' by STDEV(i) & siti Vi
>'--
>Dim r As Long, Rng As Range
>Set Rng = ActiveSheet.UsedRange
>Application.Calculation = x
Hi Friends,
I will usually get n number of .htm files in my day to day activities.
I have to track them all with page count as my part of job.
Is there any module or VBA code to find out the total number of pages
in a .htm file.
By RKM..
--
-
Hi:
I need an example of Excel and Sql Server, ger records, update,
delete, etc, in and from Excel.
Thanks very much.
Rgds,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
Hi Karan,
I will really very happy to help you.
Please send your requirement in details. and the website url, from where
your want to data crawled.
On Tue, Apr 5, 2011 at 9:33 AM, karan 1237 wrote:
> *
> *
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>
>
>
> -- Forwarded message
To be more clear I want to write the translation of same word "POP" in
Chinese language into text file or excel sheet but when I am writing that
Chinese word "西洋勁曲" inside code it is showing junk characters.
Any solution...
Thanks & Regards,
Vinay
--
--
try these links
http://support.microsoft.com/kb/321686
http://office.microsoft.com/en-us/excel-help/connect-to-import-sql-server-data-HA010217956.aspx
http://support.microsoft.com/kb/306125
http://www.mssqltips.com/tip.asp?tip=1202
On Tue, Apr 5, 2011 at 6:44 PM, Julio Cesar wrote:
> Hi:
>
i think my question tab is missing
do you want to show the blank records if the data of the employ is missing
in day
also how many total employees you have
On Tue, Apr 5, 2011 at 2:03 AM, John A. Smith wrote:
> I receive an Excel file download everyday (see 032911.xls>, and 040311.xls>. I n
Ashish,
There are 22 employees. I don't need any blanks if no data for an employee. If
their name isn't on the list they were off. If their name is on the list but no
orders pulled, they were assigned to a utility job and don't need to be on the
summary either.
As soon as I can get to my comp
Sub test1()
Shell "C:\Windows\system32\cmd.exe", vbNormalFocus 'opens CMD
Application.Wait (Now + TimeValue("0:00:5"))
SendKeys Sheets(1).Cells(1, 1).Value
Application.Wait (Now + TimeValue("0:00:5"))
SendKeys "{Enter}" 'enter code
End Sub
On Tue, Apr 5, 2011 at 4:40 AM, Squall wrote:
> Hi gu
Ashish,
I have attached the My Questions tab as a file by itself. Thank you for
your kind help.
John
On Tue, Apr 5, 2011 at 12:55 PM, wrote:
> Ashish,
>
> There are 22 employees. I don't need any blanks if no data for an employee.
> If their name isn't on the list they were off. If their name
Congrats Ashish.
--- On Mon, 4/4/11, mrinal saha wrote:
From: mrinal saha
Subject: Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011
To: excel-macros@googlegroups.com
Date: Monday, April 4, 2011, 10:25 AM
Ashish, You are doing such a tremendous job...Keep going Bro.
rega
Provide URL
On Tue, Apr 5, 2011 at 9:33 AM, karan 1237 wrote:
> *
> *
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>
>
>
> -- Forwarded message --
> From: karan 1237
> Date: Mon, Apr 4, 2011 at 3:12 PM
> Subject: $$Excel-Macros$$ Kind Attention : urgent help
> To: excel-macros@goo
-- Forwarded message --
From: Akshay Korgaonkar
Date: Wed, Apr 6, 2011 at 12:23 AM
Subject: Available consultant's for your requirement.
To: recruiter.aks...@gmail.com
HI,
Mentioned below are the list of candidates available for your requirement.
Kindly let me know if you hav
Hi Group,
Need a code to clear the values of all the text boxes ,comboboxes in one
click in a excel sheet with the name "calculator"
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
--
Some important links for
Hi, can someone please tell what i did wrong, this is my first macro all by
myself, but it gives me a error, i made a macro where i what to copy sheet
"teste" to sheet "destino" but without range, so that when i introduce new
values to column A,B,C and execute the macro it copys all values to desti
Hi All,
Still waiting for your help...
- Original Message -
From: Jaideep Panchal
To: excel-macros@googlegroups.com
Sent: Sunday, April 03, 2011 8:33 PM
Subject: $$Excel-Macros$$ Help required in merging two attendance sheets
Hi Group,
I joined this group few months ag
Hi Ashish/guys,
Can you help and also give me examples to get the text in a spesific
coordinate from the apps ?
Btw, the send keys and the delay code works perfectly;)
~Aduh~
On Wed, Apr 6, 2011 at 7:20 AM, ashish koul wrote:
>
>
> Sub test1()
>
> Shell "C:\Windows\system32\cmd.exe", vbNorm
Hi Jorge,
Your workbook didn't contain any macros.
Regards - Dave
Date: Tue, 5 Apr 2011 23:40:56 +0100
Subject: $$Excel-Macros$$ copy macro error
From: leote.w...@gmail.com
To: excel-macros@googlegroups.com
Hi, can someone please tell what i did wrong, this is my first macro all by
myself, b
try this
Sub Datacopy()
Sheets("teste").Range(Sheets("teste").Cells(1, 1),
Sheets("teste").Cells(Sheets("teste").Range("a65356").End(xlUp).Row,
3)).Copy
With Sheets("destino")
.Cells(Sheets("destino").Range("a65356").End(xlUp).Row,
1).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xl
19 matches
Mail list logo