$$Excel-Macros$$ Re: PDF to txt by vba code

2018-03-14 Thread Basole
Rashid, I did tests on the pc with windows10-64 bits and office 2016-64 bits, and it worked. Regards, Basole. Em segunda-feira, 5 de março de 2018 07:03:51 UTC-3, prkhan56 escreveu: > > Dear Basole, > I am using 64 Bit version. > It gives error. > How can I fix it plea

$$Excel-Macros$$ Re: PDF to txt by vba code

2018-03-14 Thread Basole
Hi Franz, try saving the pdftotext.exe file to the \system32 folder. This way, you will not have problems with the path of pdf files. regards, Basole. Em quarta-feira, 14 de março de 2018 09:40:30 UTC-3, Franz Braun escreveu: > > hi Basole, > > did that, doesn't w

$$Excel-Macros$$ Re: PDF to txt by vba code

2018-03-03 Thread Basole
Hi Franz, put the PDFs files in the same folder as the workbook. regards. Basole. Em terça-feira, 3 de setembro de 2013 10:22:31 UTC-3, Priti_Verma escreveu: > > Please ignore previous mail and consider on this. > > i want to convert PDFs file to .txt file. through vba code. &

$$Excel-Macros$$ Re: PDF to txt by vba code

2018-01-11 Thread Basole
Hi Zaka, I fixed some errors in the shell command line, now it works fine. See link file download: http://ge.tt/4ZLsH4o2 Regards, Basole. [] Em terça-feira, 3 de setembro de 2013 10:22:31 UTC-3, Priti_Verma escreveu: > > Please ignore previous mail and consider on this. > &g

$$Excel-Macros$$ Re: SQL Queriies in Excel sheets

2015-12-07 Thread Basole
ok, I'm glad to have helped, is attached, other filter options with SQL syntax. Regards. Abx. Basole. Em segunda-feira, 7 de dezembro de 2015 08:40:33 UTC-2, luciano de souza escreveu: > > Hello all, > > This is my first message to the group and I am glad to participat

$$Excel-Macros$$ Re: SQL Queriies in Excel sheets

2015-12-07 Thread Basole
Luciano is attached a SQL synthesis of example that gets the data from another tab, but can be adjusted to retrieve data from another workbook regards. Abraço. Basole. Em segunda-feira, 7 de dezembro de 2015 08:40:33 UTC-2, luciano de souza escreveu: > > Hello all, > > This

$$Excel-Macros$$ Re: Pls fix this error

2015-07-17 Thread Basole
Hi, pls.what is the project password ? Em sexta-feira, 17 de julho de 2015 04:07:46 UTC-3, jocky Beta escreveu: > > Hi All, > > i need help on above attached excel sheet. it always shows the error and > can't work properly. > > Your help regarding on this will be very much appreciated > > > Rega

$$Excel-Macros$$ Re: Conditional Formatting by Group

2014-01-16 Thread Basole
Dear JCraig, download your spreadsheet this site: http://www.sendspace.com/file/box6mv Basole. Em quarta-feira, 15 de janeiro de 2014 18h35min23s UTC-2, JCraig escreveu: > > Hello Forum. > I use this forum extensively for review and research yet I have never > submitted a que

$$Excel-Macros$$ Re: Conditional Formatting by Group

2014-01-15 Thread Basole
Dear JCraig, Please could better elaborate your question including some lines manually with the desired result rgd, Basole Em quarta-feira, 15 de janeiro de 2014 18h35min23s UTC-2, JCraig escreveu: > > Hello Forum. > I use this forum extensively for review and research yet I h

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-14 Thread Basole
4) = Replace(orig2, orig2, Mid(orig2, 2, 6)) 'For the case of a batch number has 6 digits this amendment will consider this possibility rgd, Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Experts, > > I am

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-13 Thread Basole
n study the possibilities? *K010B* K100 K200 K300 K400B K500B K600B K700 K800 K900NT Basole Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Experts, > > I am looking to copy individual rows of data from one spreadsheet

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-13 Thread Basole
be in the same columns and rows from the previous. Another thing: the code which is written "Worksheets (1)" and "Worksheets (2)", you must change the numbers in parenthesis according to the numbers of the new workbook. Basole. Em quarta-feira, 8 de janeiro de 2014 11

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-13 Thread Basole
Sorry I'm not understanding what you mean by "One thing, once the data gets to 10 or 100 they skip to the top of the column (ie batch 100K or 010K) is this just what will happen or can it be changed?" Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Y

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-09 Thread Basole
Hi Tom, Please manually enter the "Cusum" tab, showing the desired result. As for the "H" column want the macro to copy the data in this column? Tks. Basole Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Exp

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-09 Thread Basole
Basole, That's incredible, how do you do that?! Macro to do this, I inserted a function that reverses the data of the cell then the code puts the data in ascending order, and then inverts the data again. tks. Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Y

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-09 Thread Basole
Hi Tom, yes that what you want is possible. To do that I need additional information, such as name of the workbook, description of the column and rows etc.. Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Experts, > &g

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-09 Thread Basole
Dear Tom, here me the macro is working perfectly. I am attaching a workbook for you to test. Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Experts, > > I am looking to copy individual rows of data from one spread

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

2014-01-08 Thread Basole
'Hi Tom Yaxley, 'try this macro, copy and paste the code in sheet1 and to test, put some data in column "A" from cell "A1" 'Hope this helps. 'rgd, 'Basole. Sub OrderData() Dim orig, rev Dim Lastrow As Integer Dim i As Long

$$Excel-Macros$$ Re: Amazon - Compare Prices

2014-01-06 Thread Basole
Excel has this native option. Click on> DATA> GET ON EXTERNAL DATA> click on> WEB> when opening a window insert your URL to open the page, there you select the screen through the "little arrows" yellow the area that you want to import. rgds. Basole. > > -- A

$$Excel-Macros$$ Re: Macro to change existing formatting of numbers based on Criteria

2014-01-05 Thread Basole
Left(Cells(i, 1), _ InStr(Cells(i, 1), ".") + 2) End If If x = "Cr" Then Cells(i, 2) = NumberFormat & Left(Cells(i, 1), _ InStr(Cells(i, 1), &q

$$Excel-Macros$$ Re: Find Item in combobox

2014-01-01 Thread Basole
Hi Mr., sorry try this now: Private Sub UserForm_Initialize() Dim contA As Integer Dim contP As Integer Dim small As String Dim Elm As Integer Elm = ComboBox1.ListCount For contA = 0 To Elm - 2 For contP = contA + 1 To Elm - 1 If ComboBox1.List(contA) >

$$Excel-Macros$$ Re: Find Item in combobox

2014-01-01 Thread Basole
ets("plan1") LastRow = .Cells(Cells.Rows.Count, "A").End(xlUp).Row For x = 1 To LastRow + 1 ComboBox1.AddItem .Cells(x, 1).Value Next End With End Sub ''rgds. 'happyNyear 'Basole Em quarta-feira, 1 de janeiro de 201

$$Excel-Macros$$ Re: I have a problem adding two columuns and subtracting a 3rd from the first two.

2013-12-30 Thread Basole
share your spreadsheet, indicating the result you need with regards Mr. Basole Em segunda-feira, 30 de dezembro de 2013 20h33min59s UTC-2, JJ escreveu: > > > I have a spreadsheet, to keep my Craps game activity straight. > I've used it from the very beginning of my play. T

$$Excel-Macros$$ Re: Listbox data adding problem

2013-12-30 Thread Basole
Hi renuka chari, solve your problem? Basole Em domingo, 29 de dezembro de 2013 13h46min05s UTC-2, renuka chari escreveu: > > Dear Experts, > > Please provide the solution for the attached worksheet. > > problem was written in the excel please go through that. > > than

$$Excel-Macros$$ Re: I have a problem adding two columuns and subtracting a 3rd from the first two.

2013-12-30 Thread Basole
Hi JJ, pls. share an example highlighting the results you need. regards, Basole. Em segunda-feira, 30 de dezembro de 2013 20h33min59s UTC-2, JJ escreveu: > > > I have a spreadsheet, to keep my Craps game activity straight. > I've used it from the very beginning of my play.

$$Excel-Macros$$ Re: Need Help with VBA in Excel

2013-12-20 Thread Basole
PG, Please share an example with some data! regards, Basole. Em sexta-feira, 20 de dezembro de 2013 16h27min17s UTC-2, PG escreveu: > > Hi, > I have a problem to solve here. > > I have a master list of about 1000 records, which has Order ID, Customer > Name, Address

$$Excel-Macros$$ Re: Find, move & delete

2013-12-20 Thread Basole
You're welcome, Regards, Basole. Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q escreveu: > > Hi, > > The macro below currently finds and removes selected characters that it > find. It works great. No issues. > > What I would like is this to

$$Excel-Macros$$ Re: How to generate correlated random variables in excel?

2013-12-20 Thread Basole
Not at all! regards, Basole Em quinta-feira, 19 de dezembro de 2013 14h45min36s UTC-2, XX escreveu: > > HI all, > > I need some help with using excel to generate two sets of correlated > random variables, anyone can help me with this? What's the formula to use? > Than

$$Excel-Macros$$ Re: How to generate correlated random variables in excel?

2013-12-19 Thread Basole
Hi, if not what you need, " =RANDBETWEEN(1,100)*0.5 " please share an example for better understanding of your problem. regards, Basole Em quinta-feira, 19 de dezembro de 2013 14h45min36s UTC-2, XX escreveu: > > HI all, > > I need some help with using excel t

$$Excel-Macros$$ Re: How to generate correlated random variables in excel?

2013-12-19 Thread Basole
XX, try this: Ex. =RANDBETWEEN(1,100) and press "F9" for test. Basole Em quinta-feira, 19 de dezembro de 2013 14h45min36s UTC-2, XX escreveu: > > HI all, > > I need some help with using excel to generate two sets of correlated > random variables, anyone can help

$$Excel-Macros$$ Re: Find, move & delete

2013-12-18 Thread Basole
hen FirstPartH = Left(Cells(i, 2), InStr(Cells(i, 2), "-") - 1) 'start b1 SecontPartH = Right(Cells(i, 2), Len(Cells(i, 2)) - InStr(Cells(i, 2), "-") + 1) Cells(i, 3) = FirstPartH 'start c1 Cells(i, 4) = SecontPartH 'start d1 End If End If Next End Sub '

$$Excel-Macros$$ Re: Find, move & delete

2013-12-18 Thread Basole
Hi Bill, press the "F8" key on VBE (VB editor) to check what line and what kind of character the error occurs. Basole. Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q escreveu: > > Hi, > > The macro below currently finds and removes selected char

$$Excel-Macros$$ Re: Find, move & delete

2013-12-18 Thread Basole
Bill, this example of data that had sent me two different situations "+" and "-". Indicate whether the other possible situations that can occur with other data! regards, Basole. Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q escreveu: > >

$$Excel-Macros$$ Re: Find, move & delete

2013-12-18 Thread Basole
, 1), "-") > 0 Then FirstPartH = Left(Cells(i, 1), InStr(Cells(i, 1), "-") - 1) SecontPartH = Right(Cells(i, 1), Len(Cells(i, 1)) - InStr(Cells(i, 1), "-") + 1) Cells(i, 2) = FirstPartH Cells(i, 3) = SecontPartH End If End If Next End Sub '_ 'Basole. Em s

$$Excel-Macros$$ Re: Find, move & delete

2013-12-17 Thread Basole
sorry Bill, try now this: Sub CLEARNUMBERS001() s = Array("+", "-", ".5", "-.5", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9") For Each r In Selection

$$Excel-Macros$$ Re: Need help

2013-12-17 Thread Basole
Hello Philip, I think this is not an appropriate environment to request this kind of help! regards, Em terça-feira, 17 de dezembro de 2013 11h37min16s UTC-2, Philip escreveu: > > Hope you get this on time, I made a trip to Ireland and my Bag was stolen > from me with my passport, cash and cr

$$Excel-Macros$$ Re: Find, move & delete

2013-12-16 Thread Basole
Hi Bill, try this: Sub CLEARNUMBERS001() s = Array("+", "-", ".5", "-.5", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9") For Each r In Selection v = r.V

$$Excel-Macros$$ Re: PowerPivate Utility

2013-11-28 Thread Basole
hi, see this . http://social.technet.microsoft.com/wiki/contents/articles/714.powerpivot-install-the-powerpivot-add-in-for-excel.aspx Em quinta-feira, 28 de novembro de 2013 10h31min47s UTC-2, Tariq Aziz escreveu: > > Dear Team Member > > > How to install "PowerPivat" Utility and run this

$$Excel-Macros$$ Re: Scurb two columns using VBA

2013-11-21 Thread Basole
hi santy, pls. share an example with some data. tks. Em quinta-feira, 21 de novembro de 2013 15h26min01s UTC-2, Santy escreveu: > > Hi All, > > > > How to scrub how columns using VBA for example I have 2 columns both > contain data, I want if first column value matched in second column

$$Excel-Macros$$ Re: HYPERLINKS

2013-11-21 Thread Basole
hi mickey, pls. share an example with some data. tks. Em quinta-feira, 21 de novembro de 2013 20h01min49s UTC-2, Mickey Davis escreveu: > > I have a spreadsheet with links to various cells. The sheet is constantly > changing, so the cell references change. Is there a way I can link from one

$$Excel-Macros$$ Re:

2013-11-19 Thread Basole
See this.. http://www.addictivetips.com/windows-tips/enable-all-macros-in-excel-2010/ http://office.microsoft.com/en-us/excel-help/enable-or-disable-macros-in-office-files-HA010354316.aspx regards Basole Em sábado, 16 de novembro de 2013 11h09min57s UTC-2, sharad escreveu: > > The attac

$$Excel-Macros$$ VBA Tips - Learn the name of the Windows user

2013-11-18 Thread Basole
VBA Tips - Learn the name of the Windows user: https://groups.google.com/forum/#!topic/excelvbamacros/-pvfIVv7cp4 -- 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

$$Excel-Macros$$ Re:

2013-11-18 Thread Basole
Dear Sharad, the result is obtained through the macro. The macro does exactly what you would do manually adds an "enter" after each gluing one item from each column in the spreadsheet sub_ledger. Basole Em sábado, 16 de novembro de 2013 11h09min57s UTC-2, sharad escreveu: > >

$$Excel-Macros$$ Re: paste multiple ranges in vba excel 2010

2013-11-17 Thread Basole
ok Cristian, not at all. tks, Basole. Em quarta-feira, 13 de novembro de 2013 04h14min03s UTC-2, cristian paduraru escreveu: > > Hello to You all, > > > > I encountered following issue: > I want to copy multiple ranges and paste to it in the specific ranges. I > wi

$$Excel-Macros$$ Re: paste multiple ranges in vba excel 2010

2013-11-14 Thread Basole
us, LookIn:=xlFormulas).Row For x = 1 To UsedRow Cells(x + 4, "C").Copy Worksheets(1).Cells(Rows.count, "D").End(xlUp).Offset(5, 0).PasteSpecial xlPasteValues Next x Application.ScreenUpdating = True Application.CutCopyMode = False '

$$Excel-Macros$$ Re: paste multiple ranges in vba excel 2010

2013-11-13 Thread Basole
;).Select Application.CutCopyMode = False Selection.Copy Range("H22").Select ActiveSheet.Paste Application.CutCopyMode = False End Sub 'Basole Em quarta-feira, 13 de novembro de 2013 04h14min03s UTC-2, cristian paduraru escreveu: > > Hello to You all, > > > &g

$$Excel-Macros$$ Re: Need help to convert Txt to Excel

2013-11-13 Thread Basole
Range("B" & Cells.Rows.Count).End(xlUp).Offset(1, 0).Value = CardHolder Worksheets(1).Range("C" & Cells.Rows.Count).End(xlUp).Offset(1, 0).Value = DoorZone Worksheets(1).Range("D" & Cells.Rows.Count).End(xlUp).Offset(1, 0).Value = Status Lo

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-12 Thread Basole
Dear Sandeep, follow a link to an example of integration excel + access. And excel working with front-end Link: http://www.4shared.com/rar/z6j4vQEO/Excel-Access.html tks. regards. Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > &

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-08 Thread Basole
Dear Sandeep, it seems to me that this code was used in excel 2003 with connection via the "ODBC" nowadays use more connection "ADO" "DAO" etc.. Well I have some models use excel to ms Access with tables and indexes, which I will share with you. Regards, Basole.

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-08 Thread Basole
Rupesh Patil: Hi Expert. How generate PDF file using VBA. Thanks Hi Rupesh Patil, try this: Sub Creati_PDF() Dim Filepdf As String Filepdf = "C:\Temp\FileName.pdf" ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFullName, _ Quality:=xlQualityMinimum, IncludeDocPropertie

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-07 Thread Basole
Dear Sanddep, thank you for your kindness! Sorry, but what is the difference between recordset and querry tables? Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS >

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-06 Thread Basole
.4shared.com/rar/pfq_GUuR/excel_2010_vba_and_macros.html thanks, regards Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-05 Thread Basole
: Database Engine 2010 download here: http://www.microsoft.com/en-us/download/details.aspx?id=13255 Any questions I am available. rs. Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is func

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-04 Thread Basole
ame in the path. Any questions I am available. Basole Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know a

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-03 Thread Basole
Hi Sandeep, what is the error message that appears? Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me kn

$$Excel-Macros$$ Re: Need macro for converting PDF in to given format

2013-10-17 Thread Basole
Dear Jocky, what is your version of MS Office? Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta escreveu: > > Hi Team, > > I need help on above attached sheets, In the excel sheet i should browse > the PDF file (which is attached in this mail ) and then the output data >

$$Excel-Macros$$ Re: Need macro for converting PDF in to given format

2013-10-17 Thread Basole
Hi Jocky, I'm checking out the reason of error. Anyway see your text file attached to test another worksheet. Basole. Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta escreveu: > > Hi Team, > > I need help on above attached sheets, In the excel shee

$$Excel-Macros$$ Re:

2013-10-15 Thread Basole
Dear Sandeep, i did some testing, and here is working properly, the only error that appears, is when the macro finds some protected worksheet. Try using a new worksheet and paste this code below ... and then test to see if it works. Option Explicit #If VBA7 Then Private Type BROWSEINFO

$$Excel-Macros$$ Re:

2013-10-15 Thread Basole
Hi Sandeep, try this: > Replaces the highlighted code for this: Option Explicit #If VBA7 Then Private Type BROWSEINFO hOwner As LongPtr pidlRoot As LongPtr pszDisplayName As String lpszTitle As String ulFlags As Long lpfn As LongPtr lP

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-14 Thread Basole
Ok Bill, any questions let me know ... Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: > > Hi, > > I am using Excel 2007 and have Gmail as my primary email account. > > I have a dynamic spreadsheet that monitors different stock prices that is > refreshed ever "x" amount o

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Basole
Bill, enable reference, as indicated Ashish Watve and keep the quotes ("") in their name and email in the email password. Basole. Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: > > Hi, > > I am using Excel 2007 and have Gmail as my primary email

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Basole
'Ashish Kumar, thank you very much. Pls. add this code: Private Sub Worksheet_Calculate() If ThisWorkbook.ActiveSheet.Range("A1") < 10 Then Call SendEmail Else End If End Sub 'and in cell A1, enter the formula: =RANDBETWEEN(1,15) 'and press F9 to test. 'I share

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Basole
Aashish, try changing the port number in this line:Flds.Item(schema & "smtpserverport") = 465 see this site indicated by Ashish: http://www.rondebruin.nl/win/s1/cdo.htm Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: > > Hi, > > I am using Excel 2007 and have Gmail as my

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-07 Thread Basole
mp; rng SendEmailGmail = .Send End With MsgBox " Email sent to " & nTo & " successfully ! " Set iMsg = Nothing Set iConf = Nothing Set Flds = Nothing End Sub Private Sub Worksheet_Change(ByVal Target As Range) If ThisWorkbook.ActiveSheet.Range("A1") <

$$Excel-Macros$$ Re: I want to show flag using conditional formatting

2013-10-06 Thread Basole
Ok Waseem, my suggestion would be as an alternative. But really the flags icon sets conditional formatting are more defined. tks. Em sábado, 5 de outubro de 2013 01h31min52s UTC-3, Waseem Saifi escreveu: > > Hi Experts, > I want to show flag next to value's coulmn basis on criteria that if

$$Excel-Macros$$ Re: I want to show flag using conditional formatting

2013-10-05 Thread Basole
Hi Waseem, see the suggestion using conditional formatting, only to color the font and fill the cell. tks. Basole. Em sábado, 5 de outubro de 2013 01h31min52s UTC-3, Waseem Saifi escreveu: > > Hi Experts, > I want to show flag next to value's coulmn basis on criteria that

$$Excel-Macros$$ Re: Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread Basole
Hi Bill, see this example attached... Em quarta-feira, 2 de outubro de 2013 10h24min32s UTC-3, Bill Q escreveu: > > Hi, > > I know how to insert the image. The thing is I want the cell to always be > always the same size. > > Any advice ? > > Thanks. > -- Are you =EXP(E:RT) or =NOT(

$$Excel-Macros$$ Re: Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

2013-09-11 Thread Basole
ok De Premor, tks. Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon escreveu: > > Dear All, > > > I have a DBF Table containing Vouchers Month wise like > > 70001 (Dated : 05-July-13) > 70002 (Dated : 08-July-13) > 80001 (Dated : 02-August-13) > > > Now i want to get

$$Excel-Macros$$ Re: Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

2013-09-11 Thread Basole
Hi, the dbf attachment is corrupted. Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon escreveu: > > Dear All, > > > I have a DBF Table containing Vouchers Month wise like > > 70001 (Dated : 05-July-13) > 70002 (Dated : 08-July-13) > 80001 (Dated : 02-August-13) > > > No

$$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread Basole
Will save in the same folder. This problem can occur due to application "DOS" PDFtoText.exe, only read files with up to eight (8) digits. Try to rename your PDF file with 8 digits (eg "myfile1.pdf"), to see if it works. Bsl. Em terça-feira, 3 de setembro de 2013 10h22min31s UTC-3, Priti_Verma e

$$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread Basole
hi sorry, password is: 1234 Bsl Em terça-feira, 3 de setembro de 2013 10h22min31s UTC-3, Priti_Verma escreveu: > > Please ignore previous mail and consider on this. > > i want to convert PDFs file to .txt file. through vba code. > i have been search it on Google ,but not get any solution. > Can

$$Excel-Macros$$ Re: Opening only file in folder

2013-09-04 Thread Basole
Not sure I understand, but see if this is what you need? rsg. Bsl Em quarta-feira, 4 de setembro de 2013 05h09min50s UTC-3, Jorge Leote escreveu: > > Hi guys, > > I have this macro to open a excel file in a specific folder, I now want to > do the same in another folder, but the problem is th

$$Excel-Macros$$ Re: need to change to print area settings - Reg

2013-08-18 Thread Basole
Try this .. Sub ActivAreaPrint() 'defines the print area as selected cells ActiveSheet.UsedRange.Select ActiveSheet.PageSetup.PrintArea = Selection.Address 'ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _ ' IgnorePrintAreas:=False End Sub Em domingo, 18 de agos

$$Excel-Macros$$ Re: Hours difference formula

2013-07-26 Thread Basole
Try this: =IF(B1<=A1,HOUR(A1-B1),HOUR(B1-A1)) Em sexta-feira, 26 de julho de 2013 13h30min08s UTC-3, Prabhu Pinky escreveu: > > Hi experts, > > Pls help with formula to find difference between two hours. Below are the > examples. > 1. Diff between : 08:00 &15:00 > 2. Diff between : 10:00 &21

$$Excel-Macros$$ Re: Hours difference formula

2013-07-26 Thread Basole
hi pls, which the provisions of values (hours) cell a1, cell a2, etc Em sexta-feira, 26 de julho de 2013 13h30min08s UTC-3, Prabhu Pinky escreveu: > > Hi experts, > > Pls help with formula to find difference between two hours. Below are the > examples. > 1. Diff between : 08:00 &15:00 > 2. Dif

$$Excel-Macros$$ Re: Hours difference formula

2013-07-26 Thread Basole
Use =HOUR(B1-A1) Em sexta-feira, 26 de julho de 2013 13h30min08s UTC-3, Prabhu Pinky escreveu: > > Hi experts, > > Pls help with formula to find difference between two hours. Below are the > examples. > 1. Diff between : 08:00 &15:00 > 2. Diff between : 10:00 &21:00 > 3. Diff between : 22:00 &

$$Excel-Macros$$ Re: Translate PDF as a text

2013-07-24 Thread Basole
Hi, see (attached) if that's what you want Em quarta-feira, 24 de julho de 2013 07h29min47s UTC-3, Pravin Gunjal escreveu: > > Hello, > > > > I would like to translate this attached PDF texts (words) in to English to > work out on it. I tried my best but couldn't get the exact result. Can

$$Excel-Macros$$ Re: Export Table Created in Access(2007) to local drive

2013-07-19 Thread Basole
Hi, try to use this spreadsheet to import from MS Access http://goo.gl/YxPK6 Em sábado, 20 de julho de 2013 01h07min46s UTC-3, Chinnumanas escreveu: > > Team.. Pls help > > -- Forwarded message -- > From: vijayKumar > > Date: Fri, Jul 19, 2013 at 7:20 PM > Subject: $$Excel-Macr

$$Excel-Macros$$ Re: Export Table Created in Access(2007) to local drive

2013-07-19 Thread Basole
The DoCmd.TransferSpreadsheet command, when activated with parameter acSpreadsheetTypeExcel12, is able to export more than 65,536 rows. So, create a macro (mcr_Exportation) and add the action "ImportrExport workbook "; Transfer Type: Export, type spreadsheet: Excel Workbook; Table Name: YourQuery

$$Excel-Macros$$ Re: Whole Sheet is Hidden, But actually not Hidden!

2013-07-19 Thread Basole
It depends on the preference of each. I suggest an idea for improving the performance of file since lighter and worked up data Em sexta-feira, 19 de julho de 2013 03h38min32s UTC-3, Waseem Saifi escreveu: > > Dear Experts, > >I have an Excel file. which has huge amount of data. it has mo

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-07-19 Thread Basole
Hi Sandeep, has to do with what you need. I need to know:: The database access is within the SQL server? tks. and rgs. On Wednesday, July 17, 2013 11:48:43 AM UTC-3, Sandeep Kumar Baranwal wrote: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 201

$$Excel-Macros$$ Re: Whole Sheet is Hidden, But actually not Hidden!

2013-07-19 Thread Basole
Excel does not support a lot of data. I think the ideal would be to store the data on another worksheet, or access and process the data and make queries on the worksheet page. Em sexta-feira, 19 de julho de 2013 03h38min32s UTC-3, Waseem Saifi escreveu: > > Dear Experts, > >I have an Ex

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-07-18 Thread Basole
Please can attach example tks. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute f

Re: $$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Basole
See if that is what needs: http://www.homeandlearn.co.uk/excel2007/excel2007s8p4.html Em quarta-feira, 10 de julho de 2013 09h51min06s UTC-3, Santy escreveu: > > Hi, > > I need help urgently > > how to copy value from an object (i have copy objects from web page) > > > > > Thanks in advance >

$$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-25 Thread Basole
Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: > > Hello, > I hope you're having a good day. > I would like some help in my project involving imprting some data from pdf > into excel spredsheet. >