Take a look at the link below:-
http://www.andypope.info/vba/userformdraw.htm
The approach is, copying the shapes from the worksheet to clipboard, and
then reading the clipboard and place the clipboard BitMap/metafile on the
form as an OLE Picture.
Regards
Ajit
-Original Message-
Fro
check this page... may be it could be any use for you
http://www.ozgrid.com/forum/showthread.php?t=98321
Rg
On Wed, Aug 5, 2009 at 12:19 AM, peace wrote:
>
> I need to retrieve stock information from a web site. (It can be any
> site that provides such information - the site is not important)
Hi,
Jaspal Rehal
Thanks'Thanku very much it works,
On Tue, Aug 4, 2009 at 9:25 PM, Jaspal Rehal wrote:
>
> Try : COUNTIF formula
> Rg
>
> On Tue, Aug 4, 2009 at 6:14 PM, shivashankar
> katageri wrote:
> > Dear all,
> >
> > any body help me to sort out the with attached sheet
> > --
> > Thanks
Hi,
If you can please provide a sample file of the same, it will help us to find
the solution.
Regrds,
Deepak
On Wed, Aug 5, 2009 at 1:56 AM, Tim wrote:
>
> Hello all,
> I'm attempting to have a window pop up when the user clicks a
> command button on the sheet. The hurdle I have come to is
Good morning folks
I am looking for a database / excel list to maintain supplier invoices. I give
below what I could manually enter and what outputs I am looking for .
I am ready to / I will manually enter and maintain the following
(1) Supplier master data :
1.1. Supplier name
1.2.
Hello,
When I write the following string in notepad:
A B
C D
and copy/paste it to Excel, it fills 4 cells.
I tried to set the value of a range in a macro to a string containing
an equivalent content ("a" & vbTab & "b" & vbNewLine & "c" & vbTab &
"d")
But this does not work.
Could someone gi
Dear all,
I have several sheets in one excel file. I want to club row of each sheet
containing particular word in a new sheet.
Kindly help me on the matter.
Thanks all.
Narendra Ashara
--~--~-~--~~~---~--~~
---
good day everyone,
i need some help with little script, actually i need script to auto
fill serial numbers when qty is entered.
lets say i type in F530 product qty, 5, and i need that in H530 will
be start serial number,
starts with zero: 1, and in I530 stop serial number: 5.
cells J and K
If till now, no body has replied then try this
Before deleting the entries, in a new cell put the comments in text.
then use '&' key eg..if ur numerical entry is in B2 and comment in F2, then in
G2 put formula "=B2&F2"
Send me your excel file or sample one and I'd solve it with formula.
Thanx '
Its amazing as to what I learn from this group
Keep sharing keep growing
BEST regards
Subu
On Aug 5, 12:17 pm, Rakesh Sharma wrote:
> Hi Peace,
>
> May be this would resolve your problem,
>
> Regards
> Rakesh
>
> Yahoo! recommends that you upgrade to the new and safer Intern
i am guessing what your need might be...need some more details to
help...
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Fre
You can download the file from that link. And then suitably modify the code
to suit to your requirements.
Ajit
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Deepak Rai
Sent: Wednesday, August 05, 2009 11:34 AM
To: excel-macros@googlegroups.com
Subje
Just sent them an Excel file designed to get that CSV file as it
opens
--- Use Auto open macro in the file File
--- Ask user where the CSV file is
Execute formatting macro
PS Ensure that you put in place a Excel update routine because people
will ALWAYS uses th
One way to do it by formulas would be
StartSerial - Formula - "=1"Cell Format - Custom "0"
EndSerial - Formula - "=Qty" Cell Format - Custom "0"
Date- Cell Format - Custom "yymmdd"
Having done this, you can programmatically read the cell contents as
displ
Jaspal, Thank you very much for your input.
Regards.
Peace
On Aug 5, 12:52 am, Jaspal Rehal wrote:
> check this page... may be it could be any use for you
>
> http://www.ozgrid.com/forum/showthread.php?t=98321
>
> Rg
>
>
>
> On Wed, Aug 5, 2009 at 12:19 AM, peace wrote:
>
> > I need to retrieve
Rakesh,
Thank you very much for your input.
I appreciate you and others (Jaspal) taking the time to write.
Regards.
Peace
On Aug 5, 3:17 am, Rakesh Sharma wrote:
> Hi Peace,
>
> May be this would resolve your problem,
>
> Regards
> Rakesh
>
> Yahoo! recommends that you upgrade to the new
Dear All,
I am not able to remove the filter. Can anyone help me on this.
--
Luv & Regards
Ujjwal Jha
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA T
For example "Journal" this word is in one column of every sheet. This word
is in the same column of every sheet. i.e. Column D. I want the rows having
word "Journal" in a new sheet.
On Wed, Aug 5, 2009 at 4:51 PM, Prasanth wrote:
>
> i am guessing what your need might be...need some more details
see attached file
On Wed, Aug 5, 2009 at 3:27 PM, mageshwaran jayaraman
wrote:
> If till now, no body has replied then try this
> Before deleting the entries, in a new cell put the comments in text.
> then use '&' key eg..if ur numerical entry is in B2 and comment in F2, then
> in G2 put formul
Before pasting ur values press "F2" then paste the text which u copied from
notepad.
I hope this will help
On Wed, Aug 5, 2009 at 1:42 PM, Vivien Parlat wrote:
>
> Hello,
>
> When I write the following string in notepad:
>
> A B
> C D
>
> and copy/paste it to Excel, it fills 4 cells.
> I tri
Try to use shortcut key.*"Shift + Space Bar"*
On Tue, Aug 4, 2009 at 2:29 PM, Sheyn Lee wrote:
> Dear All,
> Is there any option that when I select a cell in the sheet, the whole row
> corresponding to that cell is highlighted.
> In the attached example I have selected cell C7. Required
We just converted to the new version of Excel. I used to use a couple
of functions from the data analysis toolpack (regression &
histograms). Can anyone tell me how to get at that functionality from
"the ribbon"?
--~--~-~--~~~---~--~~
could you please let me know how did you do it...
On Wed, Aug 5, 2009 at 11:32 PM, Harmeet Singh wrote:
> done!!!
>
> On Wed, Aug 5, 2009 at 9:18 PM, Ujjwal Jha wrote:
>
>> Dear All,
>>
>> I am not able to remove the filter. Can anyone help me on this.
>> --
>>
>> Luv & Regards
>> Ujjwal Jha
>>
i would like to add an example of what im trying to do. please let me
know how to add a file.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(V
I am assessing how many days poeple have off sick and have a sheet to
record this as follows.
cola Date_off
colb Date_ret
colc Total days (networkday between off and ret)
Does anyone have an idea how I can calculate in column colc how many
days a person hs been absent in the previous 6 mont
Dear All,
I can use mail merge with msword. But if I want to write mail in outlook and
want to send to many recipients but dont want them to see multi recipients'
names. I can use BCC but dont want to. I want to write mail and send them to
multiple but i want them to see their name only in 'TO' fi
Hi Osiso,
Can you just clarify what you are trying to do, as it sounds like we
are trying to make this more difficult than it needs to be.
Presumably you have an array of exchange rates from date x (eg 199712)
to date y (eg 200712) on one sheet.
On another sheet you are wanting to pull back the
pls search the forum. I had posted a solution some months back. Rgds
On 8/6/09, Ujjwal Jha wrote:
> Dear All,
>
> I can use mail merge with msword. But if I want to write mail in outlook and
> want to send to many recipients but dont want them to see multi recipients'
> names. I can use BCC but
-Original Message-
From: Aindril De
Sent: Saturday, August 01, 2009 8:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Submit data to a web site from excel
[The entire original message is not included]
--~--~-~--~~~---~--~~
-Original Message-
From: Aindril De
Sent: Saturday, August 01, 2009 8:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Submit data to a web site from excel
[The entire original message is not included]
--~--~-~--~~~---~--~~
On Aug 4, 10:44 pm, shivashankar katageri
wrote:
> Dear all,
>
> any body help me to sort out the with attached sheet
> --
> Thanks & Regards
>
> Shivashankar.C.Katageri.
Hi Shivashankar,
Here's another solution using VBA that may interest you.
Hope you find it usefull.
Regards,
Jonell
im using formula now, and i dont like filled cells, cause some people
will be confused when they see many data, lots of numbers going down,
but if it possible to change fields like i found script for date auto
fill, like line by line, without copying anything,
just enter qty number and that's it.
Hello,
In case a formula is returning “#N/A” then is there a way by which the
output of the formula could be made blank or zero. please help.
regards, Harris
--~--~-~--~~~---~--~~
--
33 matches
Mail list logo