Hi Hiren,
You can get the demo version free from Internet.
Rgds,
Mahesh
On Fri, Sep 18, 2009 at 3:59 PM, Hiren Sheth wrote:
> Hi Mahesh,
>
>
>
> From where I can get the below mention software?
>
>
>
> Regards
>
> Hiren
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@goo
Through trial and error, I believe I have cobbled together a VBA
routine that will examine my sheet, and if it is a *single* character
(A thru Z, 0 zero thru nine), then it assigns it a background color
depending on the character. This part worked initially.
Now that I have saved the file, and
I have a table that has this structure:
ThingID ThingGrouping ThingStatus
1 A Done
2 A Started
3 B Started
4 B NotStarted
It is easy to make a pivot Table that shows a count of things in
groups at a statu
need real help
On Sep 17, 1:06 pm, Algo Trading wrote:
> All,
>
> I have a 'Master.xls' and multiple workbooks ( Posrep 1-2 to Posrep 9-16 ).
> Those multiple workbooks have data in one sheet ("Main").
>
> In each workbooks and sheet ("Main")
> If any cell in Column B contains " Project Meal Tot
Hello.
Add the following line at the beginning of your macro :
Application.ScreenUpdating = False
Optionally, restore at the end of the macro :
Application.ScreenUpdating = False
HTH
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroup
Not sure why it doesn't work for you.
I did this:
In a module I called "Declarations", I added:
Public Variable_Public
Global Variable_Global
Then, in the ThisWorkbook module,
I created:
Private Sub Workbook_Open()
Variable_Public = "TestString_" & Format(Now(), "m-d-yy")
Variable_Glo
Each day my workbook creates a new worksheet and names it with the
following format:
"Init " + Format(Now(), "m-d-yy") --ex. "Init 9-18-09"
I've declared a public variable IDOSheet as String (in one of the
modules) to use throughout the workbook. It works but it seems that I
keep having to as
Hi Ankur,
Follow below steps:-
1. point out the mouse in between the data.
2. Ctrl + *
3. F5
4. Alt + S
5. k
6. Enter Zero
7. Ctrl + Enter
done
best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
Yes you can.
(Note: Excel 2007 allows over 1,000,000 rows)
You can use something like:
Option Explicit
Public Const ForReading = 1, ForWriting = 2, ForAppending = 3
Sub Readfile()
Dim fso, f, DataFileName, SheetName, Str, Srow
Dim cnt, ShtNo, CurrentSheet, RowsPerSheet
CurrentShee
Dear Santosh:
The pivot table is driven by the underlying database. So you need to change
the database, use Replace and find function. Once the database is chnage the
pivot will change automatically.
Thanks.
Rajesh
On Fri, Sep 18, 2009 at 1:58 PM, Santhosh Kumar M K wrote:
> Dear Friends,
>
>
Hi All,
I am importing a text file into excel where there is more data than 65536
rows. Can I have any macro, xla file or any addin to spilt the text file
into different sheets.
Regards,
Saurabh Patel
+91982814
"The earth is enjoyed by heroes"-this is the unfailing truth. Be a hero.
Alway
Hi Friend,
I need your help for this question:
How to count color fill up cell in excel.
Regards
Raj Bharti
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel a
Hi Mahesh,
>From where I can get the below mention software?
Regards
Hiren
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Prashanth Banneni
Sent: Friday, September 18, 2009 2:32 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: pdf to xl
Dear friend,
Able2Extract does not convert the xls in editable format.
Rgds,
Mahender Bisht
On Fri, Sep 18, 2009 at 2:32 PM, Prashanth Banneni wrote:
> Hi Mahesh
>
> Able2Extract_1_.Professional.v6.0.0.0 would help
>
> Thanks
> Prashanth
>
> On Fri, Sep 18, 2009 at 1:35 PM, Mahesh wrote:
>
>
Hi Nipun,
Sorry for delay, as I was little occupied throughout this week.
I have tried cracking this file, but as it a "password to open" which tooo
seems to have a good encryption of lengthy and complex password, it seems to
be very difficult for me. If it is worksheet password, workbook password
Hi Tomy,
Include the following at starting point of your code.
Application.DisplayAlerts=False
Application.DisplayAlerts=False
Application.ScreenUpdating=False
Don't forget to enalbe them at the end of your code.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dili
Hi Mahesh
Able2Extract_1_.Professional.v6.0.0.0 would help
Thanks
Prashanth
On Fri, Sep 18, 2009 at 1:35 PM, Mahesh wrote:
> Dear Team,
>
> Is there any software to convert a pdf into excel?
> if yes, please provide.
>
> --
> With Love,
> Mahesh Bisht
>
> >
>
--~--~-~--~~-
Hello.
Have a loop at the attached file. The macro "test" does the trick.
Regards.
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of rdavis7...@gmail.com
> Sent: jeudi 17 septembre 2009 18:29
> To: MS EXCEL AND VBA MACROS
>
Dear Team,
Is there any software to convert a pdf into excel?
if yes, please provide.
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Exce
Dear Friends,
Need your kind support.
In a single sheet I created 10 Pivots for same data.In all pivots have same
option is *Customer name*.When I change the customer name as "Rajesh" in a
first pivot, automatically should be change the same name "Rajesh" in other
9 pivots.PLease, give suggestio
20 matches
Mail list logo
