Hi
I have a small query. I have data like as follows..
product codes
123AA+BB+CC+DD+EE+FF
145BC+DE+FE
687UU+VV+WW+GG
The data should be converted as follows:
codes product AA 123 BB 123 CC 123 DD 123 EE 123 FF 123 BC 145 DE 145 FE
145
Hallo,
I need your help. I need a macro which look in a specific folder,
which contains other folders, each of them having some word files
inside. After finding them, open, extract the paragraphs and close
them again.
Thank you,
A-M
--~--~-~--~~~---~--~~
Visit th
Hi,
Not sure if you can use this, but the following is what I do to get around the
importing of formats.
Import the data initially to a spare sheet.
Then copy all data, and use Paste Special, Values to paste the data into the
intended sheet.
The intended sheet retains all its original formatting
there is no file attached kindly attach file.
rgds,
bilal
On Fri, Dec 19, 2008 at 6:16 PM, madhur baharani
wrote:
> Dear All,
>
> Please do reply soon if someone know it's solution.
>
> Thanks in advance.
>
> On Mon, Dec 8, 2008 at 5:00 PM, madhur baharani > wrote:
>
>>
>> Dear All,
Dear All,
Please do reply soon if someone know it's solution.
Thanks in advance.
On Mon, Dec 8, 2008 at 5:00 PM, madhur baharani
wrote:
>
> Dear All,
>
>I am very much thankfull for all the support and positive
> feedback.
>
> My query is how to recover the VBA_Password
As I wrote before, I am trying to learn how to program so rewriting
some old codes I have is good exercise. In this case, there is a
tricky if then sequence. Another reason is that some of the Excel
functions have well documented bugs. If I can get my own version to
work properly, then I don't nee
HI GUYS,
I AM FACING A LITTLE PROBLEM HERE. I HAVE AN APPLICATION THAT EXTRACTS
DATA FROM THE DATAWAREHOUSE AND EMIAL THE DATA CONTENTS TO THE END
USERS BY EXPORTING THE DATA INTO EXCEL SHEETS.The problem starts here,
there are some null values in the data and they are replaced by a 0
(zero) at th
Dear Yoni,
Open the csv file using excel and then save the file in XLS format this will
solve ur problem. Ensure the csv file must have extension .csv check it by
clicking on that file once and press F2 if you dont find the .csv in end
then type .csv manually then it can be opened in excel.
Regar
Use this formula
=DATEDIF(A1,B1,"D")*24 This if for calculating hours between two
dates.
=DATEDIF(A1,B1,"D")*24*60 This is for calculating minutes between two
dates.
Assumption : Cell "A1" has Start date and Cell "B1" has End date.
On Fri, Dec 19, 2008 at 11:10 AM, Santhosh Ku
Hello there,
What ever i have understood from your question and providing you the answer
for it *" type =row()" *to get the required result i.e row number
If this is not the case try others answers to get what you are expecting.
Regards
Ahmedhonest
On Thu, Dec 18, 2008 at 10:32 PM, ShellyGirl wr
You can use text to column option in excel by using , as a separator and get
the data in excel in columnar form.
Thanks & Regards...
cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI)
Vivek Shantilal Jain & Co.
Chartered Accountants
3010 Ram Kumar Arcade,
Chatribari Road, A T
Dear Friends,
Please, send formulareqarding the above suject...
Regards,
Santhosh
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Your problem solved in the attachment. This should help you. Let me know if
you still have any query.
On Thu, Dec 18, 2008 at 8:21 PM, xrull wrote:
> On Dec 18, 2:52 am, Ajay wrote:
> > On Dec 18, 11:08 am, xrull wrote:
> >
> >
> >
> > > I need some expert help.
> > > I'm a battering VBA co
Hi Karthick,
Check this file and let me know your ideas.
regards
Officevbatrainer
From: Karthick.A.R
To: excel-macros@googlegroups.com
Sent: Thursday, December 18, 2008 2:33:43 PM
Subject: $$Excel-Macros$$ Problem with date
Hi all
I've created a form with o
Excel is not a text file. So you can not change a text file to an excel file
by simply changing extension or by replacing comma with other characters.
You may try to open an excel (.xls) file with a text editor to see its
format.
Akhilesh Kumar Karna
On Fri, Dec 19, 2008 at 6:38 AM, Yonih wrot
HI there,..
Send me the file and I will break the password and give you the new
password..
Regards..
Manjit Singh
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of AMARNATH RAVEENDRANATH
Sent: 16 December 2008 09:12 PM
To: excel-macro
16 matches
Mail list logo
