Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
the start of code. and "Application.Calculation = xlCalculationManual" To
turn off the automatic calculation
at the beginning of the code
see example:
Dim u As Integer, v As Integer
u = Range("Months").Value - 1
Application.S
Hello Sarah, I can help you.
You could better detail what you need?
Regards,
Basole.
2015-07-06 12:33 GMT-03:00 Sarah Cartwright :
>
>
> Hi-
> I am in need of assistance with VBA code development to create a shareable
> template that can automatically generate a graph based on a user-friendly
Try reversing the variables, not to result in a negative number:
Set Date_Range = Sheets("Sheet1").Range("A1:A500")
YearStartDate = DateSerial(2014, 1, 1)
For Each DateVal In Date_Range
DateAge = YearStartDate - DateVal
If DateAge > 100 Then
MsgBox DateVal.Ad
Is an example: considering sheet1:
Sub TestButton()
Dim sht1 As Worksheet
Dim lastRow As Long
Set sht1 = Sheets(1)
lastRow = sht1.Cells(Rows.Count, 2).End(xlUp).Row + 1
sht1.Range("b" & lastRow) = sht1.[a1]
End Sub
rgds.
Basole
2014-10-06 16:39 GMT-03:00 Joe Coldwell :
>
mp; ".xls" like
> below,
>
> fileXLS = "T" & Replace(Format(Date, "ddmm"), "/", "") & ".xls" and
> example sent by you
>
> started working.
>
> Thank you very much.
>
> Eugene
>
>
>
>
>
&
Ok, is attached files.
To test, hold the 2 files in the same folder
Regards,
Basole.
2014-08-29 11:58 GMT-03:00 Eugene Bernard :
> Basole,
>
> Thanks for your solution.
>
> Can you please send me the working example along with excel file with
> sample data.
>
> I tried your code with my data,
Hi,
See this example extracts the data from your file T2308.xls (T & date: and
change the name according to the current(or system date)), using ADO and
SQL statement.
regards.
Basole
2014-08-23 8:55 GMT-03:00 Eugene Bernard :
> Dear all,
>
> I am daily using the attached sample query file t
u share the file pdf
regards.
Basole
2014-08-04 13:12 GMT-03:00 Sandeep Kumar Baranwal <
sandeepkumarbaran...@gmail.com>:
> Hi
>
> Could anyone help me with the VBA code to convert multi-pages PDF file to
> multiple sheets Excel spreadsheet ?
>
> Thanks & regards,
> *Sandeep Kumar Baranwal
You can share a model of two worksheets with their columns and some dummy
data?
Regards,
Basole.
2014-05-05 16:42 GMT-03:00 USMCRex :
> Sorry if this is a duplicate question... I could find nothing addressing
> this in my searches.
> I have a master spreadsheet with 10,000 items. I have a
Hi Falina Gan,
In Excel 2010, you can add the "Microsoft MonthView Control" check out this
tutorial:
http://www.fontstuff.com/vba/vbatut07.htm
Regards,
Basole.
2014-04-22 0:38 GMT-03:00 ashish koul :
> in excel 2010 and above calender control has been removed so you will not
> find i
Hi Falina, try this:
=RANDBETWEEN(1,10)/10 or
=RANDBETWEEN(1,99)& "," & RANDBETWEEN(1,99)
regards,
Basole.
2014-04-14 4:50 GMT-03:00 Falina Gan :
> To Whom It May Concern,
>
> Could you write in VBA on decimal random numbers?
>
> Hope to hear from you.
>
> Thanks.
>
> --
> Are you =EXP(E:RT
Hi Suyog Kulkarni,
See how build an Excel Add -In
http://www.fontstuff.com/vba/vbatut03.htm
Regards,
Basole
2014-04-05 1:22 GMT-03:00 Suyog Kulkarni :
> Hi Basole,
>
> It's working fine now following are the only problems remaining.
> 1. While creating macro, I have assigned "ctrl+q" shortcu
Below attached my suggestions:
1 - A small application (A-PDF Text Extractor) to convert pdf to txt.
2 - Macro that imports the file (M & M Price list.txt) to excel.
https://www.dropbox.com/s/y0xtlhgjbjgy0qb/Files.rar
Regards,
Basole.
2014-04-04 6:37 GMT-03:00 Neeraj Chauhan :
> Dear ,
Hi, try this:
x = Cells(Rows.Count, "A").End(xlUp).Row
y = Cells(x, Columns.Count).End(xlToLeft).Column
Range("A1:" & Cells(x, y).Address).Select
Regards,
Basole.
2014-04-04 11:17 GMT-03:00 Suyog Kulkarni :
> Hello All,
>
> I made my first macro code. Kindly review. Now only problem rema
Pls. share your PDF file, so I can adjust the code in this format.
Regards,
Basole.
2014-04-02 1:37 GMT-03:00 Abhishek Jain :
> I tried saving the PDF as Text and importing it in Excel, it didn't work.
> Do you have a sample macro or something that I can try?
>
> Thanks.
>
>
> On Tue, Apr 1, 2
Hi Abhishek Jain,
If the formatting of the PDF files is standardized, you can create a macro
to convert to TXT and then import into excel and then save in xlsx format
automatically for all pages.
Regards,
Basole.
2014-04-01 11:30 GMT-03:00 Abhishek Jain :
> Hi Friends,
>
> I have a PDF fil
Hi, try change SmtpserverPort to 465.
Basole
On Fri, 28 Mar 2014 09:20:54 -0300, excel-macros@googlegroups.com wrote:
>
--
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/dis
Hi Priti Verma, try this:
Sub sendmail()
Dim imsg As Object
Dim iconf As Object
Dim flds As Object
Dim schema As String
Dim stremailId As String
Dim strpassword As String
stremailId = InputBox("emailid")
strpassword = InputBox("password")
Set imsg = CreateObject("CDO.Message")
Set iconf = Cre
Olá carolina boa tarde,
Pelo que eu entendi, voce criou um link de uma imagem na pasta1 e colou o
link na pasta2 e voce quer que ao clicar no link da pasta2 abra a pasta1?
Caso seja isso, ao colar na pasta2, com o botão direito do mouse, siga a
opção COLAR ESPECIAL, e Depois, mais embaixo: COLAR
Hi Tricia,
could share a sample file
tks.
Basole
2014-02-13 17:33 GMT-02:00 Tricia Guitard :
> I am very new to VBA but I have learned so much thanks these forums so
> thank you! I could really use some help right now.
>
> I have created a questionnaire in Excel. For each question, the user
>
Hi pls. you can share your file example ?
2014-02-07 15:20 GMT-02:00 Darius Dempsey :
> Basically I would like for the user to be able to click on button on
> worksheet to open up the User Menu forn that exist in another workbook. I
> have a user Menu i created that the user uses to navigate to
Hi Rob,
To solve the problem of error, you can delete this ( Sheets("List3").Select
), it will not affect the main macro.
Basole
2014/1/24 Rob Flott
> Anoop,
>
> When I opened the file I got run time error '57121'
> "Application-defined or object-defined error"
> And when I clicked Debug it
Hi, suits your situation:
https://app.box.com/s/zxhxpoitad7sih0wpigl
https://app.box.com/s/szaxukie20xnutka8f3e
Basole.
2014/1/23 fahad hassan
> Hey i want to ask a question regarding data transferring from excel to
> access.
> I have 4 excel sheets with data in it. i want to copy each of th
Hi Rob Flott,
Can you share a sample file with some dummy data?
tks.
Basole
2014/1/22 Rob Flott
> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
> names. This range will vary, and I have a Named Cell that identifies the
> range. For example the range of names in
à vous!
>
>
>
> On Fri, Jan 17, 2014 at 4:39 PM, Ricardo® wrote:
>
>> bonjour Mariey,
>>
>> pourrait partager votre feuille de calcul avec des données fictives et
>> aussi comme un exemple du résultat désiré?
>>
>> Merci.
>>
>>
>>
bonjour Mariey,
pourrait partager votre feuille de calcul avec des données fictives et
aussi comme un exemple du résultat désiré?
Merci.
2014/1/17
> Bonjour itware2008,
>
> J'ai finalement trouvé la solution!
> Par contre, je bute face à un autre problème. Peut-être pourriez-vous
> m'aider!
hi pls. share example of formatting
Bsl.
2013/9/6 Anil Kumar
> Hi
>
> plz help me
>
> I have a set of data (about 3000 records) that are in the following format:
> Name: name1
> Address: address1
> City: city1
>
> Name: name2
> Address: address2
> City: city2
>
> I want the records to look lik
Ok the Password is: 1234
On Wed, 4 Sep 2013 07:48:52 -0300, excel-macros@googlegroups.com wrote:
> Hi Basole
>
> Thanks for the code ,Could You Pls tell me the Password that is in Your
> code.
>
>
> On Tue, Sep 3, 2013 at 12:37 PM, Basole wrote:
>
> > Hi, I adapted this code to use utilit
Hi, you can post example?
2013/7/26 Prabhu Pinky
> Hi..
> Am getting 0:00 as result for all examples...
> On Jul 26, 2013 10:15 PM, "Basole" wrote:
>
>> Use =HOUR(B1-A1)
>>
>>
>> Em sexta-feira, 26 de julho de 2013 13h30min08s UTC-3, Prabhu Pinky
>> escreveu:
>>>
>>> Hi experts,
>>>
>>> Pls h
29 matches
Mail list logo