Hello Dear
Two ways you can import your XML Data in your Workbook
1. Manually Importing XML Data
2. Programmatically Importing XML Data
Now how to…….
1. Manually Importing XML Data:
1. Start Excel and then click Open on the File menu.
2. In the Files of type list, select XML files.
3
Hello Dear
1 of the easiest method is,
Select the range
Data-->Filter-->Advance Filter-->Unique Record Only
For more have the attached Excel Macro.
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 1:29 AM, Rajesh Nair wrote:
> Hi All,
>
> Please help me to
Hello Dear
This is excel 2007 Compatibility issue,
Please contact or chat with Microsoft Specialist
https://support.microsoft.com/oas/default.aspx?gprid=11346&st=1&wfxredirect=1
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 5:21 AM, Vinod N wrote:
> Hi Gur
Hello Dear,
Try to use
tools-->macro-->vbaeditor-->insertmodule
and try to run simple programe
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 9:46 AM, nikhil deshpande wrote:
>
> Kindly gui
Hello Dear
Open this add ins and then your protected workbook.
Follow the instruction.
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 10:09 AM, Jai wrote:
>
>
>>
>> Dear All,
>>
>> Can you Give me VBA Passward Cracker,
>> --
>> Thanks For Mail.
>
> --
> -
Dear All,
Last Day i was contacted by a good consultant,i am not keen join his offer.
if any 1 interested,can use following contact and mail
Contact Person:
CHANDRA SEKHAR
CHAITRA SOFT
#103 l Suresh Harivillu Apartments l Road No.11 l West Maradpally l
Secunderabad 500 026
Tel: 040-4010
> Dear All,
>
> Can you Give me VBA Passward Cracker,
> --
> Thanks For Mail.
>
>
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Jo
Hi Tom,
Since you only seem to have 2 ranges, you could just name them, then use the
names in your formulas.
Regards - Dave
> Date: Thu, 8 Apr 2010 16:06:06 -0700
> Subject: $$Excel-Macros$$ MATCH question
> From: tomfabtas...@hotmail.com
> To: excel-macros@googlegroups.com
>
> Hi,
>
> I
Paul,
Thanks again, I really appreciate your help. I will send another post
with an Excel file to use as an example. Since the DB is not developed
yet, and I am finishing the Excel tool, we are in the perfect world;
we can decide how to handle.
You will see in the Excel a main sheet called Tracki
Thanks Paul, it works perfect.
On Apr 8, 10:41 am, Paul Schreiner wrote:
> Hide/Unhide is considered "formatting" of rows/columns
> When you protect the sheet, select the
> Format Rows
> Format Columns
>
> checkboxes.
>
>
> From: Hanum
> To: MS EXCEL AND VBA MAC
Hi Gurus,
At my workplace, we use Excel 2007(Licensed). We maintain daily volume
tracker(shared) and the same will be updated by my team members (8~10). They
save the file systematically, one after another. As you are aware, if one
user saves the shared file and at the same time another used saves
Hi,
In an excel worksheet, I have the below formulas in three different
cells. Is there a way to replace the SR_P1!$1:$1, SR_P2!$1:$1, SR_P3!
$1:$1 parts of the function by referencing another cell (maybe using
the address function, or similar) ?
MATCH($A15&D$47, SR_P1!$1:$1, 0)
MATCH($A15&D$47,
Hi All,
Please help me to find a method to find distinct values in a column by
clicking a command button
Regards,
Rajesh. Nair
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Hi,
I recorded a macro in Excell 2007 to import an xml file.
As I wnet through the steps manualy everything workeed fine.
When i try to run the macro I get an error.
Here is the macro I recorded:
Sub xml2()
'
' xml2 Macro
'
'
Range("A1").Select
ActiveWorkbook.XmlMaps("SecScan_Map").Imp
Hide/Unhide is considered "formatting" of rows/columns
When you protect the sheet, select the
Format Rows
Format Columns
checkboxes.
From: Hanum
To: MS EXCEL AND VBA MACROS
Sent: Thu, April 8, 2010 10:57:08 AM
Subject: $$Excel-Macros$$ Allow row hiding /unhi
Hi Grace,
Let's start with this... If any changes are needed, just tell me...
Kind regards,
Paul Willekens
'===
Sub CalcTime()
Dim cCode
Dim cDatum
Dim cOldCode
Dim cTime
Dim dDate
Dim lIn
Dim nTime
Dim nPosInOut
Dim nPosSpa
There are two sides:
a) the user side: if a1:b20 is all the sheet contains, the user could
save his sheet as "user.csv" in a particular folder
but if the range to import in access is only part of the sheet, maybe
I could develop a little macro to export only that part... You tell
me !
b) the centra
I have an Excel report. The sheet needs to be password protected, at
the same time users should be able to hide/ unhide rows and columns.
Is there a way to do it?
--
--
Some important links for excel users:
1. Follo
Hi Paul,
I'm glad that you have an option to deal with this. Yes, I am fully
open to your suggestion, each user exports as .csv in a shared drive
and then I import in my Access database, in my computer.
I will really appreciate your help/guidance on this. I don't know
where to start, I never worke
Hey Sudhir,
No need of a Look upOnly thing u can do a formulae for Transpose is
required..please find the attachement.
Surya
On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar wrote:
> *Hi friends*
> **
> *Please help me urgent*
> *problem of Hlookup formula in attached file.
> *
> --
> Sudhir V
Dear All,
Can you Give me VBA Passward Cracker,
--
Thanks For Mail.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Faceb
Thank you...If possible can u also help us on Finance domain
side. Completed MBA-Finance and having 4 yrs of Exp. in the Financial
Services & Microfinance.
On Thu, Apr 8, 2010 at 3:38 PM, rf1234 rf1234 wrote:
> Hello Dear,
> Here is the files without zipped.
>
>
>
>
>
>
>
>
>
>
>
>
Dear Sudhir,
Attached file has been solved per your requirements.
Get back to me in case of any queries.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Tue, Apr 6, 2010 at 7:44 PM, sudh
Dear Vikas,
Try following options:-
1) Copy the formula and move the desired cell, press Enter
2) Select the formula and select the desired cell while pressing shift key
(select the desired cell with the formula cell selected ) and press Ctrl + D
(to fill down the formula) OR press Ctrl + R (to
You are always welcome..!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Thu, Apr 8, 2010 at 4:26 PM, Anil Saxena wrote:
> thanks lot Dilip Ji
>
>
> On Thu, Apr 8, 2010 at 2:40 PM, Dili
*Dear VBA Experts,*
I'm wondering if there is a code possible to summarize the contents of a
text file as partly shown below.
I received this file at a certain period. Thousands rows of records. Each
data contains code and date time stamps. The first line is logged in and
the next logged out, the
Hello Dear,
Nice Article.Appriciate your team spirit.
On Thu, Apr 8, 2010 at 3:02 PM, paulwillekens
wrote:
> Hi Vivek,
>
> No need to make a .csv
>
> Open the .txt and Excel will ask whether there is a separator or fixed
> length... Choose the latter and on the sample you move the vertical
I guess you can drag it down/across. Or select the target area after copying
the formula and press Ctrl+V
On Thu, Apr 8, 2010 at 2:48 PM, Vikas Chouhan wrote:
> hi,,
>
> dear i have one problem. how to copy and paste formula because this
> is array formula function..
>
>
> On Thu, Apr
Hi Vivek,
No need to make a .csv
Open the .txt and Excel will ask whether there is a separator or fixed
length... Choose the latter and on the sample you move the vertical
"separator" lines so to form the columns... then just import and
adjust the column headings...
Go for it !
Greetings
Paul
Hi Chechu,
Why not export that particular range in a .csv file, that would be
stored in a dedicated folder on the network, and imported by Access on
its own time...
You need the macro to export the range in Excel, and a macro in Access
to check for those files and import them...
If that idea suits
hi,,
dear i have one problem. how to copy and paste formula because this
is array formula function..
On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey wrote:
> Hi Anil,
>
> Attached file is solved as per your requirements. Formula is also there.
> Let me know if you have any queries.
>
> -
Hi Hugo,
Total width for the 4 first samples seems 3300mm to me, which is
greater than 3000mm... Or do I not understand your explanation well?
Please confirm and correct if necessary...
greetings
Paul Willekens
--
---
Hi Madhu
Please solve this attachment.
On 4/6/10, madhu nair wrote:
>
> Done, see attach
>
>
>
>
> On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar wrote:
>
>> *Hi friends*
>> **
>> *Please help me urgent*
>> *problem of Hlookup formula in attached file.
>> *
>> --
>> Sudhir Verma
>> Asstt. Mngr.
Here it comes...
Please feedback !
Kind regards,
Paul Willekens
'==
Sub BOcount()
Dim lBO
Dim nBO
Dim nCol
Dim nMax
Dim nRow
'first determine how many dates are registered
nCol = 2
While Len(Cells(1, nCol).Value) > 0
nCol =
hello sham
your zip file is not woring at my place can u please send it in some other
format
On Thu, Apr 8, 2010 at 1:35 PM, rf1234 rf1234 wrote:
> Hello Dear,
> Carry on Hard Work,Group is here to Help Needy People...
> But Only for Excel,Vba
> :)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope It Will
Here it comes...
greetings
Paul Willekens
'==
Sub Kleuren()
Dim nRow
nRow = 2
While Len(Cells(nRow, 1).Value) > 0
If Cells(nRow, 5).Value >= Cells(nRow, 2).Value _
And Cells(nRow, 4).Value <= Cells(nRow, 3).Value Then
Hi Anil,
Attached file is solved as per your requirements. Formula is also there.
Let me know if you have any queries.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Tue, Apr 6, 2010 at
Hello Dear,
Following is the Code to Protect Unprotect Excel Sheet Using VBA.
''
Sub ProtectSheet()
Dim Passwo
Hello Dear,
Carry on Hard Work,Group is here to Help Needy People...
But Only for Excel,Vba
:)
Hope It Will Help
Happy To Help
:)
Shyam
On Thu, Apr 8, 2010 at 12:23 PM, saroj.32006 wrote:
> Thank you...Its really a life saving help for the
> needy people.
>
Thank you...Its really a life saving help for the
needy people.
Thank you once again.
On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234 wrote:
> Hello Dear,
> Go through,attached zipped.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
>
> On Mon
Hi Shawn,
Question: are cells in column B always with content, up to the last
"used" row?
In that case... see below...
Kind regards,
Paul Willekens
'===
Sub GoColumnB()
Dim rngClnB As Range, Cell As Range
Sheets("OTHER").Acti
41 matches
Mail list logo
