thanks alot sir.
On Thu, Sep 15, 2011 at 5:47 PM, NOORAIN ANSARI wrote:
> To find a merged cell in Excel 2003.
>
> 1. Open a Find and Replace Menu.
> 2. Next to the Find What Field is a Format Box, Click it.
> 3. This opens the Find Format Menu screen which looks very similar to the
> Cell Format
Dear Alisha
Very Very thanks for Help nicely Explained
Shrinivas
On Mon, Sep 19, 2011 at 10:13 PM, alisha malhotra <
alisha.malhotr...@gmail.com> wrote:
> Dear Shrinivasan/Umar,
>
> From the slide master you can copy & paste it in your presentation.You can
> change the colour as well.
>
> After c
Hi Harry
1 are all the workbooks in xlsm or xls format is it possible for u to share
a sample workbook
On Tue, Sep 20, 2011 at 1:28 AM, HarryP Knuckles wrote:
> Good afternoon,
>
> I have 20,000 workbooks that are going to be returned to me shortly
> and i need a template from which i can ope
Hi all,
I have an urgent requirement for a macro that can open all the files
from a path provided in a cell in excel work book and copy the
contents from Columns A to K (consolidated data) in the new workbook.
Kindly provide me the code to perform this operation, so that I can
modify it according
thank you for responce
On Mon, Sep 19, 2011 at 7:45 PM, rajan verma wrote:
> You can try visual studio , by excel its not possible
>
> On 19/09/2011, Sam Mathai Chacko wrote:
> > No
> >
> > On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema
> > wrote:
> >
> >> Hai Goodmorning all,
> >>
> >> Is it
Hi John
Try this one
you need to have full paths in column f Like below
C:\Documents and Settings\achamanlalko\My Documents\Downloads\3004.OUT.txt
C:\Documents and Settings\achamanlalko\My Documents\Downloads\7110.txt
Sub importnotepaddata()
Dim i, j As Long
Dim s As String
Set objFSO = Cre
Are you wanting to disable the macros "permanently" and save the file?
or are you just needing them disabled so you can extract the information you
need?
If you just need them deactivated temporarily,
you can create a macro that issues:
Application.enableevents = false
then, open each of the 20
Good afternoon,
I have 20,000 workbooks that are going to be returned to me shortly
and i need a template from which i can open the workbooks
(individually) and have a marco to perform three necessary functions
on all of these workbooks (each workbook will have a unique name). My
objective is to:
Please help, it is very very important to me.
On Mon, Sep 19, 2011 at 8:37 PM, vinod rao wrote:
> Hi,
>
>
> I need a dynamic macro delete the worksheet based. Should segregate files
> accordingly, First one should contain Worksheet 1 to 7 and second file
> should contain 1 to 2 and 8 to 11 and th
Dear Shrinivasan/Umar,
>From the slide master you can copy & paste it in your presentation.You can
change the colour as well.
After clicking on the custom animation pane, you can see what i have done.
Still I am trying to explain you.
First take any shape or text box.
Then in custom animation
Dear Ajjw,
Please try.
and see attached sheet..
*Sub import_csvfile()
On Error GoTo abc
Dim csvfile
csvfile = Application.GetOpenFilename("CSV (*.CSV),*.CSV", , "Please select
CSV file...")
Workbooks.OpenText Filename:=csvfile, Origin:=xlWindows, StartRow:=1
With ActiveWorkbook
Active
hi all, I have an urgent requirement for a macro that can open all file
from a path provided in a cell in excel work book and copy the contents from
Columns A to K (consolidated data) in the new workbook. Kindly provide me
the code to perform this operation, so that I can modify it according to m
Hi,
I need a dynamic macro delete the worksheet based. Should segregate files
accordingly, First one should contain Worksheet 1 to 7 and second file
should contain 1 to 2 and 8 to 11 and thrid file will be 1 to 2 and 13 & 14.
Worksheet1
*Total*
**
*should remain *
Worksheet2
*Summary*
i am very new to vba programming in excel.
So pls help me
I would like to import a csv file daily into a fixed workbook by
asking the name of the csv file from the user.
--
--
Some important links for excel users:
1.
You can try visual studio , by excel its not possible
On 19/09/2011, Sam Mathai Chacko wrote:
> No
>
> On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema
> wrote:
>
>> Hai Goodmorning all,
>>
>> Is it possible to make an Excel Userform as an executable file ?
>>
>> --
>>
>> ---
hi John
can you attach the notepad file and output "excel file"
On Mon, Sep 19, 2011 at 6:40 PM, johnofeasttex wrote:
> Can anyone show me how to import the first 2 rows of data from the
> text file into excel as the following code builds the list?
>
> Thank You for ANY help..
>
> John
>
> On S
No
On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema wrote:
> Hai Goodmorning all,
>
> Is it possible to make an Excel Userform as an executable file ?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow u
Can anyone show me how to import the first 2 rows of data from the
text file into excel as the following code builds the list?
Thank You for ANY help..
John
On Sep 16, 2:04 pm, johnofeasttex wrote:
> I searched around and found some code that allows me to create a list
> of the files in a given
Dear Alisha
Many many thanks for the help
Really Good Work and Defenitely It will work.
Now Can I copy paste that rotating round in my presentation which is already
ready
I also Want to change the colour
If yes please let me know how to do it
Thanks once again
Shrinivas
On Sat, Sep 17, 2011 at 10:
Hi All,
Any suggestions?
Regards
Shiek
On Thu, Sep 8, 2011 at 10:46 PM, anu gomathi wrote:
> Hi All,
>
> Please help me with macro to populate the data from the the pivot to the
> specific fields
>
> Regards
>
> Anu
>
> On Wed, Sep 7, 2011 at 3:17 PM, anu gomathi wrote:
>
>>Hi,
>>>
>>> Att
20 matches
Mail list logo
