Re: $$Excel-Macros$$ terms

2015-09-08 Thread Paul Schreiner
ocedure", your confusion is probably with the definition of "sub". It is NOT "subordinate"as if it were:1) Procedure a) Sub-Procedure It refers to a SUBROUTINE: As in: Sub Test   MsgBox "Hello"End Sub If you need help with the VBA debugger or specific help with a p

Re: $$Excel-Macros$$ paste data to a different area of my totals sheet

2015-09-06 Thread Paul Schreiner
STRINGS rather than a date comparison. When comparing Strings, in this case, it would compare the first characters:"9" and "S"This isn't what you're looking for. You need a DATE comparison.I'd suggest Datediff() If ((DateDiff("d", Range("T2").Value,

Re: $$Excel-Macros$$ macro to loop through data sheet , fetch 8 rows at a time and put in new sheet

2015-09-03 Thread Paul Schreiner
, "A").Value = Sheets("data").Cells(RowSource, "A").Value     Sheets(Teacher).Cells(RowDest, "B").Value = Sheets("data").Cells(RowSource, "B").Value     End If     Next RowSource     Sheets("data").Select     Appl

Re: $$Excel-Macros$$ Sort Date on the Basis of Day

2015-08-30 Thread Soumyendu Paul
Hi, Is there anyone to help? On Mon, Aug 31, 2015 at 5:18 AM, Soumyendu Paul wrote: > Hi, > In attached file there is a date column containing all dates of > September month. I want to sort data like 1Sep, 2Sep, 3rd Sep irrespective > of year using VBA. Please help me. > Regar

$$Excel-Macros$$ Sort Date on the Basis of Day

2015-08-30 Thread Soumyendu Paul
Hi, In attached file there is a date column containing all dates of September month. I want to sort data like 1Sep, 2Sep, 3rd Sep irrespective of year using VBA. Please help me. Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

Re: $$Excel-Macros$$ Re: Delivery Status Notification (Failure)

2015-08-28 Thread Paul Schreiner
Are you saying that you'd like a macro that:1) Prompts you to select a folder.2) Opens all Excel files in the selected folder.  ?? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the

Re: $$Excel-Macros$$ Urgent Help Required

2015-08-26 Thread Paul Schreiner
to do, what you've accomplished so far, and what you're having trouble with. I'm sure someone would be glad to help.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all th

$$Excel-Macros$$ Urgent Help Required

2015-08-25 Thread Soumyendu Paul
Hi, Want to search header "Name" in attached file through vba but unable to do with find method. Please help Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.co

Re: $$Excel-Macros$$ If i try to crack a password of a vba macro, will the author be notified?

2015-08-24 Thread Paul Schreiner
proach would work in your case.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as eve

Re: $$Excel-Macros$$ help required in petty cash transanction

2015-08-24 Thread Paul Schreiner
ction sheet, you will have to "copy/paste Values" on the petty cash sheet. An alternative would be to write a macro that updates only the single record. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the pla

Re: $$Excel-Macros$$ help required in petty cash transanction

2015-08-21 Thread Paul Schreiner
ansaction_06.01.2015!$A$2:$B$50,2,FALSE),"") becomes: =IFERROR(VLOOKUP(C$2,INDIRECT("transaction_"&TEXT($B4,"mm.dd.")&"!$A$2:$B$55"),2,FALSE),"") You drag THAT across and down. Then, as long as the new sheets are named

Re: $$Excel-Macros$$ Re: Error : FileDialog

2015-08-21 Thread Paul Schreiner
is a flag telling the Filesystem Dialog method to return the name of a selected FILE,msoFileDialogFolderPicker returns the name of a selected FOLDER. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you c

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-08-21 Thread Paul Schreiner
ink is "too simple".The guy that answers might not be the one that writes 10,000 lines of code a day, it could be the one that just came across your problem yesterday and knows how to fix it!  Paul- “Do all the good you can, By all the means you can,

Re: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-18 Thread Paul Schreiner
always be blank.which means that using .end(xlToRight) should move to column XFDwhich is column 16384. You might as well simply set LastColumn = 16384 If instead, you're trying to find the column number of the last column with a heading in row 8, you could use: Lastcolumn = Cells(8, "G").E

Re: $$Excel-Macros$$ Excel to Pdf

2015-08-18 Thread Paul Schreiner
  OpenAfterPublish:=False or hide all the sheets except the ones you want to publish and use:    ActiveWorkbook.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:="C:\temp\Displayed_Sheets.pdf", _ Quality:=xlQualityStandard, _ IncludeDocProperties:=Tru

Re: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-17 Thread Paul Schreiner
me <> "Summary B") _    and (sht.name <> "Summary C") _    ) then  sht.select  movedata    end if  next Sht  Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can,

Re: $$Excel-Macros$$ HELP REQUIRED

2015-08-17 Thread Paul Schreiner
In the autofilter panel,you are selecting cells that begin with "M".In the next box,choose cells that do NOT begin with "MN"  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can,

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

2015-08-17 Thread Paul Schreiner
Please notice the Forum Rules:3) Don't post questions regarding breaking or bypassing any security measure. If you are the owner of the application, there are places to go to get it unlocked.Simply Google something like: excel vba password recovery I found 357,000 hits...

Re: $$Excel-Macros$$ Macro from non specific cell

2015-08-13 Thread Paul Schreiner
e cell. Now, if you want a macro to REALLY automate the collection,then you can write a macro that loops through all of the .csvfiles in the folder, reads them and enters the data.(I'm assuming the filename has the date?) Paul- “Do all the goo

Re: $$Excel-Macros$$ Excel to Pdf

2015-08-13 Thread Paul Schreiner
Are you familiar with macros?This is fairly straight forward with a simple macro.Especially if you're using Excel2007, 2010 or 2013.Earlier versions it's a bit more difficult. Paul- “Do all the good you can, By all the means you can, In all th

Re: $$Excel-Macros$$ Help with saveas file code

2015-08-11 Thread Paul Schreiner
The user's "My Documents" folder is USUALLY set up in the C:\users\useridfolder. There's several ways of getting the login account name, but I think something like: MyDocsPath = Environ("USERPROFILE") & "\My Documents" should give you the p

Re: $$Excel-Macros$$ AUTOMATED "PRIORTITY LIST"

2015-08-11 Thread Paul Schreiner
Take a look at this solution. I use a Change Event in which I check for change to cell C2.(so you should be sure to enter the task BEFORE the priority) I also "assumed" that it would NOT increment tasks that where there was a blank task. That is: with priority 1,3,4,7 if I entered a priority "3":

Re: $$Excel-Macros$$ count # of common strings between two cells

2015-08-11 Thread Paul Schreiner
inx))     If (Val & "X" <> "X") Then     If (Dict_Data.exists(Val)) Then     DupCnt = DupCnt + 1     End If     End If     Next inx     Cells(4, C).Value = DupCnt   

Re: $$Excel-Macros$$ Need help to split numbers available in the last

2015-08-05 Thread Paul Schreiner
Sorry, I am unable to view the response.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley

Re: $$Excel-Macros$$ Need help to split numbers available in the last

2015-08-05 Thread Paul Schreiner
e to look at an alternative.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.

Re: $$Excel-Macros$$ Need help to split numbers available in the last

2015-08-05 Thread Paul Schreiner
For MOST of the data, you could use an excel function like: =TRIM(RIGHT(TRIM(A3),15)) (for row 3) but rows 2 and 7 do not have the $$ at the end of the row.In fact, they do not seem to have the $$ at all! Paul- “Do all the good you can, By all the means you

Re: $$Excel-Macros$$ Need help to split numbers available in the last

2015-08-05 Thread Paul Schreiner
What type of solution are you looking for?VBA macros? Excel function?Manual steps? how often do you need to do this?(is it a one-time thing, or daily/weekly/monthly?) What is the source of the data?Can you provide delimiters in the output?  Paul- “Do all

Re: $$Excel-Macros$$ Copy data from one column and create a new one

2015-08-04 Thread Paul Schreiner
uot; & sArray(inx)  next inx end if    cells(nRow, "BQ").value = strend if Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you ca

Re: $$Excel-Macros$$ Remove Outlook Security Alert(Urgent!)

2015-08-04 Thread Soumyendu Paul
Is there anyone to help? On Tue, Aug 4, 2015 at 2:28 PM, Soumyendu Paul wrote: > In my case Antivirus is installed; so this option is disabled > > On Tue, Aug 4, 2015 at 2:25 PM, Abhishek Jain > wrote: > >> What worked for me on Outlook 2007 - >> >> Run Outloo

Re: $$Excel-Macros$$ Remove Outlook Security Alert(Urgent!)

2015-08-04 Thread Soumyendu Paul
tic Access, select - Never warn me about suspicious > activity > > HTH, Abhishek > > On Tue, Aug 4, 2015 at 2:12 PM, Soumyendu Paul > wrote: > >> Hi, >> >> How to remove Outlook Security Alerts without using Application.wait & >> Sendkeys >>

$$Excel-Macros$$ Remove Outlook Security Alert(Urgent!)

2015-08-04 Thread Soumyendu Paul
Hi, How to remove Outlook Security Alerts without using Application.wait & Sendkeys Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RU

Re: $$Excel-Macros$$ Filter Data for Current Month

2015-08-03 Thread Soumyendu Paul
Is there anyone to help? On Tue, Aug 4, 2015 at 10:43 AM, Soumyendu Paul wrote: > I want to filter all data for all July irrespective of year > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook pag

$$Excel-Macros$$ Filter Data for Current Month

2015-08-03 Thread Soumyendu Paul
I want to filter all data for all July irrespective of year -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Hiding empty columns using VBA - Some columns not hiding

2015-07-29 Thread Paul Schreiner
you can step through the macro to see where it's finding a value that causes it to fail to hide. I'll take a look again after my 7:30 meeting! :) Paul- “Do all the good you can, By all the means you can,

Re: $$Excel-Macros$$ Query for Code

2015-07-28 Thread Paul Schreiner
June, would the totals include Centres started in May and July? or ONLY those that started in June?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you

Re: $$Excel-Macros$$ Query for Code

2015-07-28 Thread Paul Schreiner
rt date is changed to a different date?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - J

Re: $$Excel-Macros$$ Query for Code

2015-07-27 Thread Paul Schreiner
A and C have a column for May 1, 2016, they won't be included in the total because it isn't in column "C"? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can,

Re: $$Excel-Macros$$ FIFO UDF not working

2015-07-27 Thread Paul Schreiner
ter, 1).Value & "X") then Do you use breakpoints and step through your code when debugging? If not, you really ought to learn how.it is AMAZING for looking at run-time values as you step through your code to see what each line is doing! Paul-

Re: $$Excel-Macros$$ Forecast template required

2015-07-24 Thread Paul Schreiner
requires one). Forecasting is very much customized for every application.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long a

Re: $$Excel-Macros$$ How to get specific text from first page of word Document using macro vba?

2015-07-24 Thread Paul Schreiner
, "")     If (Not IsNumeric(Right(EffDate, 1))) Then     EffDate = Left(EffDate, Len(EffDate) - 1)     End If     Exit For     End If     Next i     Set wrd = GetObject(, "Word.Application&

Re: $$Excel-Macros$$ Macro for Column to Rows

2015-07-24 Thread Paul Schreiner
Based on your sample file, I put together two macros:RowsToColumnsColumnsToRows you need to select an input sheet and run the appropriate macro. I'm sure this doesn't do ALL you need, but it should give you an idea of tools and techniques to customize to your ne

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

2015-07-21 Thread Paul Schreiner
n the LAST record. So, if you sort the data by EMP_ID and Newest-to-oldest of the "Period To", you would use Range_Lookup = FALSE.if you sorted by EMP_ID and oldest-to-newest of "Period To", you would use Range_Lookup = TRUE. I also added an indicator to the Data sheet to see whi

$$Excel-Macros$$ Query in VBA

2015-07-10 Thread Soumyendu Paul
Dear All, My query for attached file When we select data from drop down A cursor to move A6;when we select B from drop down cursor move down B13 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

$$Excel-Macros$$ Query

2015-06-29 Thread Soumyendu Paul
In attachment; sheet1 we are sending a mail on clicking a shape. My query is to give an alert(like popup message box) when shape is not cliked -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://w

Re: $$Excel-Macros$$ How to filter only numbers in the list

2015-06-17 Thread Paul Schreiner
er alphabetic values.In which case, you can use a filter >=A (see attached) Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, A

Re: $$Excel-Macros$$ How to filter only numbers in the list

2015-06-17 Thread Paul Schreiner
Simply turn on filters and select values > 0. (see attached) Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - J

Re: $$Excel-Macros$$ Inverse Selection of Worksheets.

2015-06-17 Thread Paul Schreiner
---    ' Select other sheets    '    For Each sht In Sheets        If (Not Dict_Sheets.exists(sht.Name)) Then            If (sht.Visible) Then                sht.Select (False)            End If 

Re: $$Excel-Macros$$ Inverse Selection of Worksheets.

2015-06-16 Thread Paul Schreiner
Could you please explain? Are you saying you want to select all sheets EXCEPT specific sheets? Or select specific sheets, then use a macro to reverse the selection?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all

Re: $$Excel-Macros$$ I need a excel where users can add data but cannot delete.

2015-06-04 Thread Paul Schreiner
lls:=True, AllowFormattingColumns:=True, _        AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=TrueEnd Sub'Sub Unprotect_Sheet()    ActiveSheet.UnprotectEnd Sub'

Re: $$Excel-Macros$$ Insert Blank Row After Each Row

2015-06-04 Thread Paul Schreiner
=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove    Next R    Application.ScreenUpdating = TrueEnd Sub  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as e

Re: Fwd: $$Excel-Macros$$ Query (Outlook VBA)

2015-06-03 Thread Soumyendu Paul
Thanks for help On Jun 3, 2015 4:43 PM, "Soumyendu Paul" wrote: > -- Forwarded message -- > From: "Soumyendu Paul" > Date: Jun 3, 2015 4:21 PM > Subject: $$Excel-Macros$$ Query (Outlook VBA) > To: > Cc: > > Hi, > > I have an ou

Re: $$Excel-Macros$$ I need a excel where users can add data but cannot delete.

2015-06-03 Thread Paul Schreiner
of any rows with values (data) to "locked"Protect the sheet You can decide when protecting the worksheet whether the user is allowed to select locked cells.Otherwise, they cannot modify the protected cells. If you need help with this, let me know.  Paul--

$$Excel-Macros$$ Query (Outlook VBA)

2015-06-03 Thread Soumyendu Paul
Hi, I have an outlook message stored in hard drive folder. Want to read this file for extracting data into excel. Please help!! Regrds, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ http

$$Excel-Macros$$ Urgent Help Required!(VBA Outlook)

2015-06-03 Thread Soumyendu Paul
Hi, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ Outlook Signature Problem using VBA

2015-06-01 Thread Soumyendu Paul
Thanks Ashish Regards, Soumyendu On Thu, May 28, 2015 at 10:37 AM, ashish koul wrote: > try example 1 > > http://www.rondebruin.nl/win/s1/outlook/signature.htm > > On Thu, May 28, 2015 at 9:20 AM, Soumyendu Paul > wrote: > >> Dear All, >> >> Please find

Re: $$Excel-Macros$$ How To: Email macros to another user?

2015-05-27 Thread Paul Schreiner
Also, you can export the macro module, send the exported file, and the other user can import the module. (some email firewalls may have trouble with the .bas or .cls file extensions, so you may need to rename the file to get to avoid being removed from the email)  Paul

Re: $$Excel-Macros$$ Re: Dynamic Combobox in Userform

2015-05-27 Thread Soumyendu Paul
inkedin.com/profile/view?id=312532939 > > > > > On Tuesday, May 26, 2015 at 1:06:40 PM UTC+5:30, Soumyendu Paul wrote: >> >> Dear All, >> When you click button2 in sheet1,a userform will popup along populated >> combobox with employee Id. My query is when I t

Re: $$Excel-Macros$$ Re: Dynamic Combobox in Userform

2015-05-27 Thread Soumyendu Paul
Have seen ur attachment will check after going back home On May 27, 2015 4:39 PM, "Mandeep Baluja" wrote: > drop down ??? It's a combo box > > On Wednesday, May 27, 2015 at 4:27:22 PM UTC+5:30, Soumyendu Paul wrote: >> >> Its a drop down with employee code &

Re: $$Excel-Macros$$ Re: Dynamic Combobox in Userform

2015-05-27 Thread Soumyendu Paul
ps://www.linkedin.com/profile/view?id=312532939 > > > > > On Tuesday, May 26, 2015 at 1:06:40 PM UTC+5:30, Soumyendu Paul wrote: >> >> Dear All, >> When you click button2 in sheet1,a userform will popup along populated >> combobox with employee Id. My query i

Re: $$Excel-Macros$$ Dynamic Combobox in Userform

2015-05-26 Thread Soumyendu Paul
Any update please. On 5/26/15, Soumyendu Paul wrote: > Dear All, > When you click button2 in sheet1,a userform will popup along populated > combobox with employee Id. My query is when I type 12 all empoyee Id > beginning with 12 should be displayed in combobox. >

$$Excel-Macros$$ Dynamic Combobox in Userform

2015-05-26 Thread Soumyendu Paul
Dear All, When you click button2 in sheet1,a userform will popup along populated combobox with employee Id. My query is when I type 12 all empoyee Id beginning with 12 should be displayed in combobox. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:O

Re: $$Excel-Macros$$ Need to merge excel files whilkt maintaining their links to a Powerpoint file

2015-05-19 Thread Paul Schreiner
similar to your conditions.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - J

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Paul Schreiner
y = split(range("A1").value,"_") Then: Range("B1").value = mArray(0)Range("C1").value = mArray(1)Range("D1").value = mArray(2)  Paul- “Do all the good you can, By all the means you can, In all the ways you

Re: $$Excel-Macros$$ Text separated with formula

2015-05-12 Thread Paul Schreiner
What version of Excel are you using?Excel 2010 has "Text to Columns" on the Data tab. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you ca

Re: $$Excel-Macros$$ Macro to Copy sheets and filter from on Workbook to multiple Workbook

2015-05-01 Thread Paul Schreiner
Oops.. you SAID your file was Macro.xls, but you attached .xlsx which means you have Excel 2010 or greater.Sorry for the misstatement. still... what do you know about macros?  Paul- “Do all the good you can, By all the means you can, In all the ways you

Re: $$Excel-Macros$$ Macro to Copy sheets and filter from on Workbook to multiple Workbook

2015-05-01 Thread Paul Schreiner
Do you have any experience with macros? What version of Excel do you use? (I noticed your sample file is in Excel97 format, is this a requirement?)   Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you

Re: $$Excel-Macros$$ Copy Dynamically From Column and Pate

2015-04-30 Thread Paul Schreiner
e "x" variable, you can use: Sheet1.Range(Cells(1, "E"), Cells(1, x)).Copy (Personally, I'd use a variable like "LastCol" instead of "x", but that my OCD talking) hope this is what you're looking for. Paul- “Do all

Re: $$Excel-Macros$$ Re: Query to retreive data

2015-04-28 Thread Paul Schreiner
uns MUCH faster) So, I'm curious as to why your file is 350mb.Does it contain graphics/images?Are there lots of formulas?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times

Re: $$Excel-Macros$$ Re: Please help with Activex "cannot insert object". error

2015-04-24 Thread Paul Schreiner
Just to be sure, try changing to the  C:\users\[username]\Appdata  folder and search for *.exd from there. I actual found two but they evidently have been corrected.Since they're dated 3/24/2015 and 3/25/2015and are not causing a problem. Paul- “D

Re: $$Excel-Macros$$ Please help with Activex "cannot insert object". error

2015-04-23 Thread Paul Schreiner
art of the installation. I'd try searching for and deleting thest MSForms.exd files and see how it does.(if you're worried, simply rename the files to something else like:MSForms.e and see if everything works correctly)  Paul- “Do all the good

Re: $$Excel-Macros$$ Port VBA code to VB.net

2015-04-14 Thread Paul Schreiner
port to an Oracle database and exits. So, in this case the VBScript is the "executable" file that launches the Excel/VBA. So, without knowing what your VBA macros do, it is difficult to know how to answer your question. Paul- “Do all the good you c

Re: $$Excel-Macros$$ Print duplicate in same page-Excel

2015-04-07 Thread Paul Schreiner
ksheet has: Row_1Row_2Row_3 Your printed output looks like+--+|[header]  ||Row_1 ||Row_2 | |Row_3 ||  | |[header]  ||Row_1     ||Row_2     | |Row_3     |+--+Is that what you're looking for?  Paul- “Do all the good you can, B

Re: $$Excel-Macros$$ Re: PLS SOLVE

2015-03-10 Thread Paul Schreiner
er, you're trying to interest a bunch of people in taking part of THEIR day to help you (free of charge) with a problem YOU are having. You need to SELL it! and... there goes my hour... Paul - “Do all the good you can, By all the means you can, In all

Re: $$Excel-Macros$$ Need macro help

2015-03-05 Thread Paul Schreiner
would do to manually update the records. stop recording. the recorded macro would provide the steps. You then have to modify it to open the other files based on how you select which files to update. Paul - “Do all the good you can, By all the means you can

Re: $$Excel-Macros$$ Need macro help

2015-03-05 Thread Paul Schreiner
lp, please provide more specific information. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - J

Re: $$Excel-Macros$$ Opening & Closing Message for an excel file and Sheet

2015-03-05 Thread Paul Schreiner
;No value entered in cell A1" Cancel = True End If End Sub ===== But I'm sure your requirement is much more than that. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places y

Re: $$Excel-Macros$$ Dynamic chart between data range

2015-03-04 Thread Soumyendu Paul
Dear Amar, Sorry for being late. Kindly find the attachment. On Mon, Feb 23, 2015 at 12:10 PM, amar takale wrote: > Dear experts > > I want to update chart as per date change in cell I3 & J3.means between > date range. i think it done by offset formula through name range. > > pls guide me > >

Re: $$Excel-Macros$$ Function for Data validataion

2015-03-02 Thread Paul Schreiner
=AND(LEN(B8)=11, ISNUMBER(INT(RIGHT(B8,7))), EXACT(B8,UPPER(B8)), ISERROR(INT(MID(B8,1,1))), ISERROR(INT(MID(B8,2,1))), ISERROR(INT(MID(B8,3,1))), ISERROR(INT(MID(B8,4,1 Paul - “Do all the good you can, By all the means you can, In all the ways

Re: $$Excel-Macros$$ Function for Data validataion

2015-03-02 Thread Paul Schreiner
OOps... sorry. ISTEXT() isn't working because 1abc is considered "text", so istext(left(B8,1)) evaluates to "true". I'll look again and get back to you. Paul - “Do all the good you can, By all the means you can, In all the w

Re: $$Excel-Macros$$ Function for Data validataion

2015-03-02 Thread Paul Schreiner
dually. At least this option reduces the tests from 10 to 7! =AND(LEN(B8)=11, ISNUMBER(INT(RIGHT(B8,7))), EXACT(B8,UPPER(B8)), ISTEXT(MID(B8,1,1)), ISTEXT(MID(B8,2,1)), ISTEXT(MID(B8,3,1)), ISTEXT(MID(B8,4,1))) Paul - “Do all the good you can, By all

Re: $$Excel-Macros$$ Re: Creating new sheet for each person and transferring their data

2015-02-27 Thread Paul Schreiner
I've never worked with Google sheets, so I have no idea. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” -

Re: $$Excel-Macros$$ Re: Creating new sheet for each person and transferring their data

2015-02-27 Thread Paul Schreiner
Rows" & Chr(13) & "To Create " & Sheets.Count - 1 & " sheets in:" tstop = Timer TMin = 0 TElapsed = tstop - tstart TMin = TElapsed \ 60 TSec = TElapsed Mod 60

Re: $$Excel-Macros$$ Function for Data validataion

2015-02-27 Thread Paul Schreiner
ISTEXT(MID(A1,2,1)), ISTEXT(MID(A1,3,1)), ISTEXT(MID(A1,4,1)) ) Hope this helps Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Paul Schreiner
Mid(target, Pos, 1))) Then StrNew = StrNew & LCase(Mid(target, Pos, 1)) Else StrNew = StrNew & UCase(Mid(target, Pos, 1)) End If Next Pos CaseSwap = StrNew End Function Paul - “Do all the good you can

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Paul Schreiner
n, there's no way to "process each character". Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As l

Re: $$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-24 Thread Paul Schreiner
lank sheet (with any name you like) go to the Data tab, and select "From Access". Select your accessdb. This should walk you through accessing specific tables within the AccessDb. Paul - “Do all the good you can, By all the means you can, In all

Re: $$Excel-Macros$$ Removing duplicates within cell

2015-02-24 Thread Paul Schreiner
What type of solution are you looking for: VBA macro? steps in Excel? Do you know how to use/maintain a VBA macro if one is provided? in your example: f,g,a,b,f would result in f,g,a,b not f,g,a Paul - “Do all the good you can, By all the means you

Re: $$Excel-Macros$$ In need of an Excel macro to filter selected data and copy it incrementally to a central file

2015-02-19 Thread Paul Schreiner
From: dza49 >To: excel-macros@googlegroups.com >Sent: Thursday, February 19, 2015 12:20 PM >Subject: $$Excel-Macros$$ In need of an Excel macro to filter selected data >and copy it incrementally to a central file > > > >Hello, > >I have a couple of unique requests for a macro that I'm attem

Re: $$Excel-Macros$$ Computer Login & Logout Time Record

2015-02-18 Thread Paul Schreiner
Win32_NTLogEvent Then search through that log to find what you're looking for. I don't have any way to try this on an XP machine. try googling: SELECT * FROM Win32_NTLogEvent WHERE logfile = and see what you get. Paul - “Do all the good you can, B

Re: $$Excel-Macros$$ auto move or cut copy paste function

2015-02-12 Thread Paul Schreiner
an excel function cannot modify another cell. You have to use VBA macros. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
invest the time to dive into the world of VBA macros, I'd suggest sticking with the simpler copy/drag of the Excel functions. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
Sorry, EXCEL functions cannot act on other cells. If you wanted to write a VBA macro, then this could be done. You could even make it an "event" macro on "Worksheet one" such that when the values in the two cells change, "worksheet two"

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
!$B$2,"") in cells B4 through Z4 is that the kind of thing you're looking for? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the

Re: $$Excel-Macros$$ Count duplicate records.

2015-02-11 Thread Paul Schreiner
"duplicate". you said you wanted a "formula". By "formula", do you mean Excel "function" or VBA functions in a macro? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places y

Re: $$Excel-Macros$$ User name to be picked up in excel

2015-02-11 Thread Paul Schreiner
Where do the names come from? what does the value in column "K" have to do with these names? I see JKD lsted for case 48 and 12, so it evidently isn't some form of unique index... Paul - “Do all the good you can, By all the means you can,

Re: $$Excel-Macros$$ Add No of Years Specified

2015-02-10 Thread Paul Schreiner
How's this? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John W

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

2015-02-08 Thread Paul I
sing it to look up a list of wine makers, which some people often enter different (i.e. Domaine Paul Isgreat, Dom. Paul Isgreat, Paul Isgreat, Domaine Isgreat) so the safest bet is to type "ISGREAT" and then see what pops up in the combobox. I wish there was a way to get the linked co

Re: $$Excel-Macros$$ Move Sheets by Worksheet Index

2015-02-05 Thread Paul Schreiner
quot;B").Value = "Move") Then Sheets(Cells(i, "A").Value).Delete i = i + 1 Loop For i = 2 To 100 If (Cells(i, "B").Value = "") Then Exit For Workbooks(Cells(i, "C").Value & ".xlsx").Close savechanges

Re: $$Excel-Macros$$ Unable to run macro in attached excel file

2015-02-05 Thread Paul Schreiner
n you step through the Workbook_Open event macro in the ThisWorkbook module? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ev

Re: $$Excel-Macros$$ How to convert PDF file to Excel file using excel vba?

2015-02-04 Thread Paul Schreiner
If you search within the forum, you'll find several discussion threads regarding this. There's really no need to reinvent the entire discussion. However, I believe that it involves the use of a third-party software. take a look. Paul - “Do al

<    1   2   3   4   5   6   7   8   9   10   >