On Sat, 12/30/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Saturday, December 30, 2017, 10:18 AM
On Wed, 12/20/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4
updates in 3 topics
To: excel-macros@googlegroups.com
Date: Wednesday, December 20, 2017, 9:19 PM
On Sun, 7/30/17, 'Martinez David' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help on Week Formula
To: excel-macros@googlegroups.com
Date: Sunday, July 30, 2017, 8:42 PM
On Su
On Tue, 7/4/17, Puttu * wrote:
Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
To: "MS EXCEL AND VBA MACROS"
Date: Tuesday, July 4, 2017, 10:03 AM
Thanks Sir, Formula match exactly my
requirement, however I have more tha
On Fri, 6/23/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back
ground : Richmond VA
To: excel-macros@googlegroups.com
Date: Friday, June 23, 2017, 4:53 PM
On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Thursday, June 1, 2017, 6:30 PM
--
On Thu, 4/13/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
To: excel-macros@googlegroups.com
Date: Thursday, April 13, 2017, 7:02 PM
-
On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot
To: excel-macros@googlegroups.com
Date: Saturday, April 8, 2017, 7:49 PM
-
On Wed, 4/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in
Excel VBA
To: excel-macros@googlegroups.com
Date: Wednesday, April 5, 201
groups.com
Date: Tuesday, April
4,
2017,
6:09 PM
----
On Tue, 4/4/17, 'Yu
Spain'
via
MS EXCEL AND VBA MACROS
wrote:
Subject: Re:
$$Excel-Macros$$
Re:
Customized
ril 4, 2017, 8:01 AM
On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Customized
Inventory
Software Required in Excel VBA
To: excel-macros@googlegroups.com
Date: T
On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in
Excel VBA
To: excel-macros@googlegroups.com
Date: Tuesday, April 4, 2017, 1:42 AM
---
On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in
Excel VBA
To: excel-macros@googlegroups.com
Date: Tuesday, April 4, 2017, 1:42 AM
---
Hi Excel Gurus,
I have been working with excel,VBA, C++ for 2 years. lately I have come
across this task where I need to download this excel sheet from web page. I
have no idea how to automate the downloading .Can some gurus give some tips
and help? any advice is welcome.
The web page
Hi
I am using vba and Reuter data everyday. I didn't get your question that
clearly.
normally I would use =RtGet("IDN",RIC,FieldName) to get live market
data.
I've never use application.evaluate(RIC) ...what is for?
On Thu, Aug 27, 2009 at 10:15 AM, thedoc wrote:
>
> Hi,
> I'm lo
independence day? which country ?
On Sat, Aug 15, 2009 at 10:19 AM, Dhananjay Pinjan wrote:
> Wishing you all a very happy Independence Day.
>
> Thanks & Regards,
> Dhananjay
>
> >
>
--~--~-~--~~~---~--~~
--
I didn't get this the meaning of this sheet..what am i supposed to do with
it?
On Wed, Aug 12, 2009 at 2:22 PM, Iqbal Shaikh wrote:
> Friends
>
> Can u solve this logo quiz?
>
>
>
>
>
>
>
>
> Iqbal S
>
> >
>
--~--~-~--~~~---~--~~
-
lease mention the return format...
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com - Saving energy-Save Earth
>
>
>
>
> On Mon, Aug 10, 2009 at 3:12 PM, zheng yu wrote:
>
>> Dear all,
>>
>>
>>
Super explanation !
On Thu, Jul 30, 2009 at 10:33 AM, Ajit Navre wrote:
> I think, it is due to the implicit conversion of constants in expression.
> In this particular case, both the quantities i.e. 4 and 1 are
> interpreted as integers. After multiplication, the result actually is 4
you mean progress bar?
On Thu, Jul 30, 2009 at 10:45 AM, vivek agrawal
wrote:
> Hi ALL
> Can any body help me create a progress reporter or if someone has it
> or if someone has build on his and he is willing to share that... then
> PLEASE do... Your help would be greatly appreciated...
use GOTO
there is no statement such as Continue in VBA
for i=1 to 1000
if i=5 then goto NextLoop
' other code
NextLoop:
next i
On Wed, Jul 29, 2009 at 2:47 PM, vivek agrawal wrote:
> Hello Kumaran
> Exit For would completely exit from the for loop..
>
> i want it to skip the code for th
, then the FTP client will uploads those files in
that folder to FTP server automatically at schedule time.
There are many free FTP client you can download
I just think this is easier than doing it in VBA
Cheers
Yu Zheng
On Mon, Jul 20, 2009 at 1:06 PM, MartyH wrote:
>
> Hi all,
Hi
sleep 100 is not that good in that it freezes EXCEL completely.
A better alternative is Application.onTime now+timevalue("00:00:10")
you can find detailed documention on Excel Help
On Tue, Jun 30, 2009 at 5:21 PM, Sandeep wrote:
> Hi Anil,
> I don't know much about VB but you c
le will open as 'hidden' (like the Personal.xls file) and you
> can distribute IT
> to others. when THEY open it, a copy is moved to their add-ins folder and
> will open "hidden"
> whenever THEY launch Excel.
>
> So...
> the short answer to your question is:
&
Hi All,
I move some excel workbooks from computer A to another B. Computer A
has Bloomberg excel addin, but Computer B doesn't have, not even has
Bloomberg.
Strange thing is that now when i start any Excel session on Computer B,
the Excel has an Bloomberg add-in, although it doesn't work.
Hi All,
Can anybody tell the difference between add-in in sheet and reference in
VBA?
cheers
Vincet
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and
hmm..anybody can make the macro work in the original sheet?
On Fri, Jun 12, 2009 at 6:29 PM, zheng yu wrote:
> Hey guys thanks
>
> but ..I copy the code into new sheet, and it works perfect too.. it is just
> in that original sheet, it only works for 0 ,but rest of them..
>
&g
me
> Have you turnedmacros on?
>
>
>
> 2009/6/12 zheng yu
>
>> Hi All,
>>
>>I got this request from a colleague who is asking me to find out the
>> problem assuming i am the best VBA and C++ programmer here.;P
>>
>>But I can't fix it
You can simply use "record macro" and do all the process through,then you
get it in VBA. You can see the VBA code in VBE editor
On Mon, Jun 8, 2009 at 2:36 PM, Philippe wrote:
>
> Hi,
>
> here is my problem. I would like to click on a button in my worksheet
> and doing so opening a web query win
desn't work for 2007 though
On Mon, Jun 8, 2009 at 6:20 AM, Ramesh Katta wrote:
>
> Hi all,
>
>
> Name : Ramesh
> Subject : Open a workbook which has formule.
> Tip :Use Ctrl+` to see the all formule which are in the sheet.
>
> We use Ctrl+` to see the all used formulas in the current work
cos you need to count the number manually.
My solution is I write a few lines to convert string name of Column to
number. How do you guys do it? or you use another way to find blank cells?
Cheers
Yu
On Sat, Jun 6, 2009 at 10:12 AM, Dave Bonallack
wrote:
> Hi Group,
> Tip.
> The follo
Hi Dear all,
Now comes to the tricky part :)
It is easy to use worksheet_change event to triger a macro when only
one cell in the sheet changes at a time. we can use
private worksheet_change(byval target as range )
If Target.address=$a$1 then
application.enableEvents=false
'your
this runs for me as well..my version is 2007
On Wed, May 27, 2009 at 7:22 AM, ddadmin2009 wrote:
> this runs fine for me and does not require any extra reference library.
> can u tell me your excel version n browser u have.. make sure u have some
> data in column A... i don't have any error hand
ena.in/software-development/1133040.htm
>
>
> Regards
>
> Ajit
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Yu
> Sent: Thursday, May 07, 2009 7:12 PM
> To: MS EXCEL AND VBA MACROS
&
Hi Dilip,
Thanks for your explanation.Great!
On Tue, May 12, 2009 at 4:59 PM, Dilip Pandey wrote:
> Hi Yu,
>
> For copy purpose, you can simply copy the formula and then you can replace
> (Ctrl +H) the "=" sign with "".
> Now moving over to your second qu
hahahaha...Ctrl+H again..hehe ,well it comes in handy:-)
On Tue, May 12, 2009 at 4:54 PM, Dilip Pandey wrote:
> Hi
>
> press Ctrl +H and replace "total charge:" with "".
>
> Thanks.
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...
Hi ,
I think the best and efficient way to learn is to buy a Excel 2003/2007
book and come to forum a lot. That is exactly how I started one and half
year ago.
On Sun, May 10, 2009 at 2:18 PM, bathina srinivasa rao <
ask_...@rediffmail.com> wrote:
> kindly help by sending Ebook on Excel.
>
>
Indeed insightful ! Thanks Paul
Just to give a hands-on example of Paul's explanation on converting number
to date using String. Here is how it is, i just tried:
Cell(A1) -- "12/05/2009 " This is a date format
Cell(B1) -- "=TEXT(A1,"MMDD")" ,then in Cell B2, you get the string
pr
Precise! Very useful !
when I export a Date (appears as a Date format) to XMl..why it appears as
a number 39919.375.any idea on that?
On Tue, May 12, 2009 at 2:15 PM, Paul Schreiner wrote:
> First, I want to remind you that the "date/time" isn't being stored as a
> "date".
> Excel stores
that you want to copy the formula WITHOUT the "=" ??
>
> I'm not sure if there is a shortcut.
>
> But in answer to your second question:
> Ctrl-D simply copies the contents of the above cell.
> Paul
>
> --
> *From:* Yu
> *To:*
old there is slight
differenct...
Thanks!
Yu
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http
s
>
> Rishi Pathak
>
>
> On Sun, May 10, 2009 at 5:13 AM, zheng yu wrote:
>
> Can anyone explain a bit principle and ways of BREAKING passwords?
>
> On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati wrote:
>
> Plz help me to crack the password for MS - Word.
> Thanks a
trick question...don't know how to trigger action on ENTER...hmm.waiting for
info as well:)
On Thu, May 7, 2009 at 9:58 PM, Doug wrote:
>
> I've got an Excel spreadsheet that I'm going to use a wedge program
> with to capture data from an instrument and parse it into the sheet. I
> would like t
Can anyone explain a bit principle and ways of BREAKING passwords?
On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati wrote:
> Plz help me to crack the password for MS - Word.
> Thanks and regards,
>
> Kamal Gulati
>
>
>
>
> On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte
> wrote:
>
>> Install Ultim
we can discuss these stuff here:)
Regards
Yu Zheng
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
Yes..it works! Thanks
On Wed, May 6, 2009 at 6:30 PM, Fabio Lemos wrote:
>
> You will need to use the indirect formula, which converts an addres to
> a reference
>
> =indirect(b1 &c1)
>
>
> Regards!
>
> Fabio L. Lemos
>
> cel.: 8122-1206
&
Hi Walid,
you can use Data-Validation to do that. Check Help on Validation
On Thu, May 7, 2009 at 9:09 AM, Mr Walid Zahran wrote:
>
> Hi Group;
>
> I'm new to MS EXCEL AND VBA MACROS. I want to know how to insert a
> ListBox into a Cell.
> I need it to be visible ony when this Cell is select
Hi dear all,
For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
has. Now B1 has value"A", and C1 has value "1", I want D1 has the
formula "=A1"
It doesn't work when I type "=B1&C1" in D1... Can anyone gives
some shine on it?
I know how to do it in VBA..quite easy: ra
Hi Dear members,
I need to extract some data from Database. For instance, I have
such an column in a table. I wanna extract Jan1 ,Feb2 and records
starting with 2009
Jan1
Feb2
20081001
20091092
20091093
20091094
20091095
I know how to extract record
more tips on Command line:
start a new Excel session:
call "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"
"Q:\Summit\Prod\Excel\test.xls"
start a workbook in existing Excel session
call "Q:\Summit\Prod\Excel\test.xls"
But any one knows how to save or close or other manipulation on Exc
ble to
> delete
> a single cell. You need to select the entire range and delete the formula.
>
> Regards
>
> Ajit
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Yu
> Sent: Friday, May 01,
Hi all,
I've been programming VBA for around 1 and half years.But this is
the first time I encounter this . It is a not a VBA issue.it is a
Excel Function i guess. But I have no idea what it is.
Here is what it does: Retreive Financial Calendar from a specified
date to a specified data via
Hi Gurumurty Sastry,
I have done the same thing as this before.
dim wk as workbook
For i=1 to number of files
set wk=workbooks.open (Filename:= Name of the file)
wk.range("T100").copy destination
:=workbooks("Spreadsheet").range(whatever you want)
Next i
Hope this can help
Kin
I have same questions as well!
On Apr 2, 3:07 pm, Ajay Varshney wrote:
> Hi,
>
> Can somebody provide me SUB for FUNCTION code for deleting a Module from
> Excel
>
> Regards,
> Ajay
--~--~-~--~~~---~--~~
-
Hi Dear all,
I have this puzzle for a long time. I often program UserForm and
always format controls like this :
.TextBox1.Height = 18
.TextBox1.Width = 100
.TextBox2.Height = 18
.TextBox2.Width = 100
.TextBox3.Height = 18
.TextBox3.Width = 100
.Text
Hi Hari,
Can you drop me some tips on breaking the VBA password ? some previous
employees have wrote some vba codes ..but they are password protected..and
we are not able to contact them.Thank you.
Kind Regards
Vincent Zheng
On Fri, Mar 20, 2009 at 6:49 AM, hari wrote:
> Hi Harmeet,
>
Hi Shay,
you can copy this and paste in your workbook_open() event. This should
meet what you want
Private Sub Workbook_Open()
Dim RemindTime As Integer
Dim B As Boolean
Dim C As Boolean
RemindTime = 5'set to whatever days y
Hello All,
I find a strange phenomena, I can use Timer no problem in some
workbooks. But in some workbooks, when I type "Timer" ,it just
automatically change to "timer" as a normal variable,not a VBA
Function. Do you have any ideas why?
Thanks !
Vincent
--~--~-~--~~--
Hi Mudassar,
while I am looking at "Drill bit equivalence" sheet, I noticed that you
have some drop-down llist/combo box..I wanna know are you using Validation
list or the Active Object Combo Box... and where you put the values that
displayed in the drop down list..I didn't find the values on t
This one is awesome! Thank you Mudassar!
On Thu, Mar 26, 2009 at 1:14 PM, Mudassar Ramzan wrote:
> Pl find the attachment.
>
>
> Thanks & regards,
>
> ||* **M**udassar Ramzan** *|* **MIS Officer** **|* *WorldCALL Telecom Ltd*
> *|** 061- 814-3999 *|* 0321 7325277 **||*
>
>
>
> >
>
--~--~--
Hi Vinu,
thanks for your post..but I don't get the Sumproduct
function..=SUMPRODUCT(($A$1:$A$9=F4)*($B$1:$B$9=G4))
what puzzles me most is (($A$1:$A$9=F4) ...I have never seen such an
expression..can you please explain it.what is the result of that
expression..
and I change the punc
Hi Alokeshwar Tiwary ,
can you explain what is [F17] mean here?
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
[F17].Activate
End Sub
On Sun, Mar 29, 2009 at 1:52 PM, Alokeshwar Tiwary <
alokeshwar.tiw...@yahoo.com> wrote:
> Though it looks like flash or something but its not. Ther
Hi Alokeshwar,
Whtat does [F17] mean here? what is it for?
On Mar 29, 1:52 pm, Alokeshwar Tiwary
wrote:
> Though it looks like flash or something but its not. There are several
> picture in each sheet which become visible and invisible one after another.
> See attached and you will get it.
63 matches
Mail list logo
