*I forget to attach the file which I'm doing now.*
On Saturday, February 15, 2020 at 3:04:56 PM UTC-5, Mike C. wrote:
>
> I am working on creating an Excel file that will pull data from
> barcharts.com for stocks listed in this Excel file and what I'm trying to
> have
I am working on creating an Excel file that will pull data from
barcharts.com for stocks listed in this Excel file and what I'm trying to
have it do is automatically show if it's a "sell", "strong sell", "buy",
"strong buy", "weak buy", etc. and then either say that like it already
does in colu
we provide GC and USC only
This is Mike from Golok Global . I have a* Tableau Developer/Admin ,
DevOps,Java Devloper,Java UI Devloper* those are GC’s and citizens . if
you have any requirements for my candidates*.*
Please forward your requirements to my mail Id:*m
we provide GC and USC only
This is Mike from Golok Global . I have a* Tableau Developer/Admin ,
DevOps,Java Devloper,Java UI Devloper* those are GC’s and citizens . if
you have any requirements for my candidates*.*
Please forward your requirements to my mail Id:*m
*** we provide GC and USC only***
Hi Partner,
Hope you are doing well….
Here is the list of
available consultants on my bench for C2C projects. They are very good at
communication skills and technical skills and are open to relocate to
anywhere in the USA. I am requesting you
*Greeting from hNexus, LLC.,*
This is Mike from hNexus, LLC and I would like to present our Hot-List of
available Candidates for projects, please let me know if you would like to
consider any of them for your Direct Client requirement's on C2C.
I would highly appreciate if yo
rtrand's Lounge, Inc. 7/24/16 5:15VGT 02 330618 501034
Bertrand's Lounge, Inc. 7/24/16 5:15VGT 03 B120762495 502474
Bertrand's Lounge, Inc. 7/24/16 5:15VGT 04 W2322052505368
Bertrand's Lounge, Inc. 7/24/16 5:15VGT 05 2082223 505025
Mike Barrett
mi
remove these from my macro
but still capture the company name and also the date?
Thank you very much,
Mike
Mike Barrett
mikeb...@gmail.com <mailto:mikeb...@gmail.com>
H - 847-587-7726
C - 312-560-6749
> On Mar 12, 2015, at 7:49 PM, Mike B wrote:
>
> Hi Mandeep,
> I wo
d to clients. I need to accomplish using an iMac
running excel 2016.
Thank you, Vikas!
On Tuesday, August 18, 2015 at 5:02:03 PM UTC-5, Mike B wrote:
>
> I would appreciate if someone would look at this formula and tell me what
> I am doing incorrectly; I have a large spreadsheet called POS where I have
> different variables separated and I am tryi
I would appreciate if someone would look at this formula and tell me what I
am doing incorrectly; I have a large spreadsheet called POS where I have
different variables separated and I am trying to use IF,AND,ISERROR in
nested IF statements and Excel doesn't like what I did. Please see my
form
I would appreciate any help with creating a macro to email individual PDF
documents to each client's email that is chosen from a list matched to the
client's PDF to send as an attachment.
Thank you,
MikeB
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO
you,
Mike B
=GETPIVOTDATA("Net Terminal Income",$A$3,"dba","17 North","Reporting_Period
",1,"z_Month","Jan 2015","IGB Number","513140","Manfacturer","IGT","VGT","VGT
01")
Thank you, Jayaraju.M! Your code works great! Thank you again, I
appreciate you help.
The Best,
MikeB
On Sunday, July 26, 2015 at 3:09:44 AM UTC-5, Jayaraju Metta wrote:
>
> Hi Mike,
> Below is the code to find string and paste it into desired cell.
> Please find the attache
I would appreciate any help with the following. I have a column "A" of
data containing shortened names in sheet 1 and another column "C"
containing the same names but in a much longer version on sheet 4; I was
thinking that perhaps I could somehow use the first five characters of the
short
Hi All
I am asking for advice! I have just been tasked with preparing some charts
of aggregated data. I am be asked to prepare four charts of customer
semi-monthly statements showing some revenue and trends of individual
items, then print a PDF file and email to each individual customer (a
ot;
ActiveSheet.Range("B2:B" & lr).SpecialCells(xlCellTypeVisible).EntireRow.Delete
ActiveSheet.ShowAllData
ActiveSheet.Range("A2:A" & lr).Replace what:="Establishment :", Replacement:=""
End Sub
On Sun, May 3, 2015 at 3:31 AM, Mi
uot;A" Using IF statement ( I think).
Hi MIke,,,check this!!!
On Sat, May 2, 2015 at 1:12 AM, Mike B mailto:mikeb...@gmail.com> > wrote:
I would like to copy this for each location and paste in front inventory
numbers in Column "A"(some begin with letters) and also in front of
I would like to copy this for each location and paste in front inventory
numbers in Column "A"(some begin with letters) and also in front of the
Establishment Totals: VC Count.
Then I would like to Remove the Word "Establishment" in from of the Totals:
VC Count.
Then I would like to delete the
something that can be automated
with a macro and if so would you be willing to help with it? Thank you again
for your help.
The Best,
Mike
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep baluja
Sent: Monday, March 16, 2015 11:35 PM
To
Hi Mandeep,
You are way ahead of me as a beginner, I am a novice but you just the code you
write is very succinct and clean. I have no doubt you will reach your goal/s.
Thank you again.
The Best,
Mike
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com
Hi Mandeep,
Thank you, thank you again for your excellent help. Is there anything I can do
for you to show my appreciation? I was really stuck and you bailed me out, I
tried severl different ways and could not get it to work. Thank you, Again.
The Best,
Mike Barrett
From
Hi Mandeep,
I would appreciate you looking at the attached worksheet, I have written
and explanation in a comment on the worksheet explaining the issues I am
experiencing, I thought it would be easier for you to understand.
On Sunday, March 8, 2015 at 12:08:13 PM UTC-5, Mike B wrote:
> Th
Thank you, thank you so much for all your help and quick response!! I am
going to have to study my books to understand your code fully, it is so
precise and quick. Thank you again, Mandeep!
On Thursday, March 5, 2015 at 10:16:12 AM UTC-6, Mike B wrote:
>
>
>
> I try it works but
, 2015 at 10:16:12 AM UTC-6, Mike B wrote:
>
>
> I try it works but goes back to what I just did even though I moved my
> cursor down 11 rows. I would appreciate any help how to get it to advance
> to the next block that I am trying to copy and paste. I have about 7,000
>
oes move forward only does the same cells.
Sub CopyDate()
'
' CopyDate Macro
'
'
Range("C:C").Find(What:="12/??/2014", LookIn:=xlValues).Activate
Selection.Copy
ActiveCell.Offset(1, -1).Select
ActiveSheet.Paste
I try it works but goes back to what I just did even though I moved my
cursor down 11 rows. I would appreciate any help how to get it to advance
to the next block that I am trying to copy and paste. I have about 7,000
rows of data to do.
Thank you
Mike B
Sub just_dates2()
'
' j
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thr
ides.Count)
'Copy the chart and paste it into the PowerPoint as a Metafile
Picture
cht.Select
ActiveChart.ChartArea.Copy
activeSlide.Shapes.Paste.Select
The issue is that the chart is loosing its formatting (colors etc) -
how do we retain this when
comment line, but he doesn't. Another
potential concern is that I am using excel 2007, and he is using excel
2003.
Any clues on where I can investigate?
Mike
--
--
Some important links for excel users:
1. Follow
Many thanks. I had actually tried that and it had failed but I've
subsequently worked out what was going wrong. The worksheet I was
copying from was protected. I just needed to unprotect first and it
all works fine now.
On Nov 16, 1:45 pm, Ashish Jain wrote:
> Hi Mike,
>
I have a macro that copies a large range of cells that contains a
mixture of cells with values and text and other cells with formulae.
I want to copy this range into a new workbook using VBA but I can't
seem to retain the formulae (which are converted to their values). I'm
sure there is a simple s
Hi,
I have a rather long macro that controls and limits the printing
process for the end user. It works okay but after running and you
return to the spreadsheet the screen is very slow to refresh as you
scroll around the worksheet.
The macro gives the user the choice of viewing a filtered set of
6CHK0131
2 276CHK0131
2 276CHK0131
3 276CHK0132
3 276CHK0132
3 276CHK0132
4 276CHK0133
Does anyone know a formula I can do this for? I have 2000 rows and do
not want to go through by hand.
Thanks! Mike
--
-
I had an xlsm workbook that was shared and very slow even though the
file size was only 3000 K. This file took around 3 minutes to open or
save. After removing the custom views that had been automatically
created by users editing the sheet, the file size went down to
200K ... opening now takes 4 se
I have a custom function that needs to read data from an external
worksheet.
To make sure that the workbook is open I use the following method:
Sub EnsureWorkbookOpen(ByVal fPath As String, ByVal fName As String)
On Error Resume Next
Err.Clear
Workbooks(fName).Activate
If Err.Numb
I'm working with variables that hold three decimal point numbers such
as .001 and 3.185. Excel VBA seems to add extra digits to these
variables so that instead of -0.004 the value is -0.0040018998981
for example.
I've tried adding lots of rounding statements everytime I work with
the variable
But it's not a formula in the cell.
Blank cell
code loops through sees if it has a "-" and if it doesn't it moves to
the next.
If it does, the data in that cell is 18 digits before the removal of
the "-", and 17 after.
The code does not modify the cell at all if there is no "-"
--
-
I have this code that replaces a "-" in a column.
It does just that, but when I link that workbook to Access and use a
"is not null" filter in a query the ones that are blank come up in the
query.
Thus my code is doing something to each cell to make Access think the
cell is not blank (whent it appe
I can send a corrupt Excel workbook to you if you want to test it out
yourself.
On Mar 13, 5:42 pm, mike wrote:
> Anyone??
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Anyone??
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=28777955567
I've been messing with that code snip you gave me all day to no avail.
A couple of things are missing from my description:
1. I'm running from a button on an access form
2. Corrupt file is at "c:\san_corrupt.xls"
3. Good file is at "c:\san.xls"
Basic code where I'm at:
***
Option
I am running some code withuin Access 2003 that opens and manipulates
an excel workbook.
The problem that I have is that once in a while the workbook that I
get from our vendor (through FTP) is corrupt.
"The fils is not in a recognizable format"
How can I test for this before proceeding into my c
On Feb 24, 9:53 pm, Mike wrote:
> Hi folks,
> Looking for a function(if it exists) that will grab the first letter
> in a string and put it in another cell. For example:
>
> '12 Roosevelt Ave.'
>
> Some function that will grab the '12' and put it
sevelt Ave.'
I don't know how easy/hard this would be but any help would be
appreciated.
TIA,
Mike
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http:
I'm looking to set up some VBA code to delete blank rows and columns
that just take up space in spreadsheets that I get from external
sources. ie: data is in 1 column(A), rows 1-10, if you place a cursor
in A1 and hit end down, you go to cell A64000.
So delete all empty columns, then rows, then r
Thanks for the input, I do however need a specific VBA solution.
--
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tuto
Well that works if using a formula, how about implementing that using
VBA?
On Dec 6, 6:17 am, Dilip Pandey wrote:
> Dear Mike,
>
> Below is the formula for your requirement.
>
> =IF(AND(A2="abcdCust",LEN(B2)=6),0&B2,IF(AND(A2="xyzzCust",LEN(B2)=8),LEFT
Thanks Paul! That is exactly what I needed.
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://ww
the userforms in the FORM module to be able to
export/import each individual userform. Does anyone have any code or
know of a way to do this?
Thanks in advance!
Mike
--
--
Some important links for excel users:
1
the userforms in the FORM module to be able to
export/import each individual userform. Does anyone have any code or
know of a way to do this?
Thanks in advance!
Mike
--
--
Some important links for excel users:
1
I have a set of data in Excel 2003 that is like this:
Customer OrderNum
abcdCust 234567
xyzzCust 12345678
...thousands of order entries, I'm just showing 2 taht are problems
for me.
The first customer needs to have a padded 7 digit order number as
"0234567"
The second needs a dash placed betw
Dave,
Your soultion was spot on.
It executed immediately.
THANKS THANKS THANKS !
On Nov 21, 12:00 am, Dave Bonallack wrote:
> Hi Mike,
> Try this code. It may be quicker. But it won't go to the end of Col B if Col
> B has any blank cells. Let me know if this is a problem.
&
What I need to do is insert a column at A:A
if there is data in B1 number A:1 as 1
down one to B2 number A:2 as 2
and so on to the end of data in column B
start with this
Col A
aaa
bbb
ccc
end with this
Col A Col B
1.aaa
2.bbb
3.ccc
(dots shown here as spacers)
The co
I am using Excel 2007 and have built a workbook that uses a lot of VBA
in the background. My problem centers around forcing the user to enable
macros.
Our security folks have set up rules on the use of macros which only
allows the user to enable the macros. I researched the use a digital
signa
visible. Has anyone else run into this situation? If so, how did you
get around it.
Thanks in advance.
Mike
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel
Hi,
Running a pool, and trying to create a macro to sort the results
automatically. Have a colunm with names and beside a colunm with
point totals (sum of three fields). Created a button that will sort
the results in order, based on points from highest to lowest.
any ideas??
Thanks
m
--~--~
ponse from Ashish Jain, but I haven' had
any luck thus far.
Hi Mike
Here is your solution:
Sub Login_Yahoo()
'Requires Reference to "Microsoft Internet Controls"
'Requires Reference to "Microsoft HTML Library"
'Declare Reference to InternetExplorer Ob
lt;26may.1...@gmail.com> wrote:
> Hi Mike
>
> Here is your solution:
>
> Sub Login_Yahoo()
> 'Requires Reference to "Microsoft Internet Controls"
> 'Requires Reference to "Microsoft HTML Library"
> 'Declare Reference to InternetEx
Hello, I am trying to accomplish the following, in case anyone knows
how to do it.
I need to (1) take the contents of the active cell, (2) open my yahoo
mail in internet explorer(http://us.mc576.mail.yahoo.com/mc/
welcome?.rand=d64n921nnhrdu).
And then (3) to place the active cell contents in t
Thanks so much!
On Mar 12, 7:50 pm, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Mike
>
> Here is your Solution:
>
> Sub Login_Website()
> 'Requires Reference to "Microsoft Internet Controls"
> 'Declare Reference to InternetExplorer Object
Someone gave the the below macro (using Microsoft Internet Controls
via Code Editor > Tools > References) for taking the active cell in
Excel and then automatically placing it in a search box in a new
Explorer Webpage, and then in effect, hitting ENTER.
It works with the website provided, www.eba
comma to column C?
Thanks very much.
Mike
--~--~-~--~~~---~--~~
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
For more options, visit this group at
http
When I access my catalog defintion I get over 250 cubes. I'd like to
limit the catalog to specific cubes.
My code is like:
Dim catAdoMD As ADOMD.Catalog
Dim conn As ADODB.Connection
sConnString = "Provider=MDrmSap.2;Data Source=SB2;User
ID=myname;SFC_CLIENT=010;SFC_LANGUAGE=EN;"
Set co
64 matches
Mail list logo
