Hi
Looking for vba requirements for exporting commands (on, off, etc) to a
relay board for control of led lights etc.
Can someone send me in the right direction etc. Do I need an add-in or
activate some controls. Using 2000 at the moment but shortly onto Excel
2013.
Thankyou
Charles Harri
Hi
There are a lot of commercial software based around Excel for live logging
of incoming data from instruments etc.
Where can I find a site that covers the vba required for receiving data.
Say direct from data recorders and/or thru SMS and a website. That is a
temperature is sent by SMS from a
Hi
Have found plenty of programs to send emails/sms from Excel. I need
however something that will receive sms messages and then I will combine
with the map options to show positions and locations etc. Looks probably
like Power View Intereactive Maps. Any comments on that would also be
appreci
Hi
Microsoft 2013 version available online with VBA editing (see
http://blogs.office.com/2014/04/14/weve-updated-excel-online-whats-new-in-april-2014/
but you cannot create a macro online. Like fully use the online version
without requiring own excel on pc.
Is there anywhere with full online ?
Hi
Having a problem with Google Groups. Using Chrome Win7
To send a new message it comes up with email to, Subject heading, tags to
enter, but there is no message block! to type in a message. Is there
something I am missing !
Charles Harris
On Mon, Jun 16, 2014 at 11:23 AM, wrote:
> Today
I want to use an Excel workbook with 2 or 3 sheets with different small
databases.
One of the databases is to come from the web, from a SmartSheet
spreadsheet.
Once the data into the .xls sheet I will run a macro to run a report using
vlookup etc
To run the report I want a one button press to
Hi
Have this macro to take the
See code below. Comes up with compile error on the last row:
ActiveWorkbook..
Is it something to do in not having the sheet name ? If so it would have to
be taken from the tab. (I now see it is referenced as sht.)
or Is it something to do with the R1C1 re
Hi
I think I may need some macros here as well.
On this url there is a description of using HID devices in XL.
http://www.aggsoft.com/usb-hid-logger/tutorials/usb-hid-to-excel.htm
The description is:
"Excel has built-in tools for getting USB HID data. All you have to do is
specify the formula
Thnkyou Guys for the codes.
The code that Anoop sen t works very well, and I will go with that. Thanks
for your help Lalit and Anoop
Regards
Charlie
On Mon, Dec 31, 2012 at 7:45 PM, Anoop K Sharma wrote:
> Please try the below one.
>
> Sub PasteValueOnly()
> Dim rng As Range
> Set rng
Hi Lalit
Have tried the code , same result. Getting the 'application defined or
object defined error' message. Can you review for me. A mystery to solve.
Thnaks
Charlie
On Mon, Dec 31, 2012 at 4:11 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> Hi Charlie,
>
> You can copy on
Hi
I want to copy the values only to another sheet. Without .value on the end
it copies thru with error messages. If I put . value on the end it comes up
with message 'copy method of range class failed'. Do not want to use
copy/paste special method. Want to use 'Destination" as shown.
Shee
olution I posted for you?
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Friday, April 06, 2012 3:53 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Deleteing Rows
AutoFilter
> End With
> End Sub
>
> Sub delrowsSAS()
> Dim i As Long
> For i = Cells(Rows.Count, 2).End(xlUp).Row To 5 Step -1
> If InStr(Cells(i, 2), "SETOUTS") > 0 Then MsgBox i 'Rows(i).Delete
> Next i
> End Sub
>
> Don Guillett
> Microsoft
>
> Give it a shot, and post back. I can try to help you debug it if you need
> more help. It's kind of hard to do by email like this, though.
>
>
>
> Asa
>
>
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.co
Good Day Asa
Are you able to assist with this for me. Would be greatly appreciately.
Thanks
Charlie
On Wed, Mar 14, 2012 at 9:45 AM, Cab Boose wrote:
> Hi Asa
> At the moment the H1 setting makes no difference. The sheet works like
> normal with the setting at activate or deactivate
, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84,
> e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88,
> j88, e89, f89, h89, j89?****
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macro
Hi
See attachedI workbook. XL2000
Refer to summary sheet
I am wanting to extract data from some sheets into summary sheet. I can
exclude 1 sheet ok, but when I try to exclude others I get syntax error.
The line of code with problem is:
If Worksheets(k).Name = "summary", "forms", "admin" Then
Hi
I have opened the file for webandmacros workbook posted here. The first
sheet for stock management is blank. No buttons/forms etc. The other sheets
are ok and show the information.
If I go to VBA to check the code for the VBA Project it asks for a
password, which I do not know. Shoulod I nee
With .Controls.Add(Type:=msoControlButton, ID:=1)
> .Style = msoButtonIconAndCaption
> .Caption = "Run " & Split(strMacroNames, ",")(lngLoop - 1)
> .OnAction = Split(strMacroNames, ",")(lngLoop - 1)
>
Hi
You need to make the names of the macros in the call routine the same as
the name in the Tools/Macro list. That is Fill1, Fill2 etc and not Macro1,
Macro2 etc
On Sat, Feb 25, 2012 at 8:00 PM, Mohammed Muneer wrote:
> **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
Hi
Xl2000
I want to add some macros to the existing'Tools' toolbar. Have
looked at several on the net. JKP, Contextures, Vbax, etc. They seem to
use mainly a floating toolbar.
I just want to run a macro that says - Add this macro (from a list showing
in current workbook) onto the 'Tool
End With
> '===
> .Columns.AutoFit
> End With
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Cab Boose
> *Sent:* Tuesday, February 14, 2012 11:55 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-M
t; Dim CurrentIndex As Long
>> Dim MyInput
>> MyInput = InputBox("Enter Column to Search eg D5")
>> CurrentIndex = ActiveSheet.Index
>> If CurrentIndex > 1 Then
>> Sheets(CurrentIndex - 1).Activate
>> Range(MyInput).Select
End If
> End Sub
>
>
>
> On Thu, Feb 16, 2012 at 11:41 AM, Cab Boose wrote:
>
>> HI
>>
>> Have this code:
>>
>> Sub GetColumnRef()
>>
>> Dim MyInput
>> MyInput = InputBox("Enter Column to Search eg D:5")
>>
>>
HI
Have this code:
Sub GetColumnRef()
Dim MyInput
MyInput = InputBox("Enter Column to Search eg D:5")
Sheets.Add.Name = MyInput
End Sub
Works well, but leaves the active sheet as the new sheet. That is the
newly created sheet.
How do I get it to return to the the sheet prevously used. May
Hi
Excel 2000
Attached workbook 'Sheet!List' tab. For standardising descriptions,
(different users!) I need to be able to extract a string and copy /paste
all instances into a new sheet, sheet to be named the string of the
search. Full list 2000+ rows.
eg If I am looking for 'Bolt' the ma
**
>
> .TextBox1.Value = .TextBox1Cell.Value2
>
> End If
>
> End If
>
> End With
>
> End Sub
>
> ** **
>
> Private Sub Worksheet_Calculate()
>
> With UserForm1
>
> If .Visible Then***
File... then send the
> resulting .frm and .frx files?
>
> Thanks,
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 9:10 PM
>
> *To
ther workbook---that which is
> on-screen at any given moment. Avoid pitfalls that way. Whoops :)
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Saturday, February 04, 2012 1
*
>
> End Sub
>
> ** **
>
> Private Sub Worksheet_Calculate()
>
> With UserForm1
>
> If .Visible Then
>
> If .TextBox1.Value <> .TextBox1Cell.Value2 Then
>
> .TextBox1.Value = .TextBox1Cell.Val
Hi
I have a userform open with a 'text box' . Want to link with a cell in
sheet.
However the 'text box' properties does not show a 'linked cell'
heading. I am sure it use to. How do I restore the missing property or
is there another text box I should use.
Thks
Charlie
--
FORUM RULES (9
Hi
Is there anywhere online that MS Excel files can be stored and used. No
look-a-likes but Excel. Freeware or low cost.
Thanks
Charlie
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
gt;
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> On Wed, Jan 11, 2012 at 6:20 AM, Cab Boose wrote:
>
>> Hi
>>
>> Trying to get this to work. See below. Comes up with 'Invalid use of
>> porperty' ati = i + 1
>>
Hi
Trying to get this to work. See below. Comes up with 'Invalid use of
porperty' ati = i + 1
I think the probem is in the Dim declaration for i.Has Dim i As
Name, at the moment, have tried others instead of 'Name' no luck.
Want to list all Named Ranges (including Dynamic) in
o
>*DOUBLE CLICK ON ROW 4 TO SORT BY THAT COLUMN* *DOUBLE CLICK ON
> Filename ROW in ANY COLUMN to OPEN that file* *Select Filename Row in Any
> Column & click Kill button to delete file and row*
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *Fr
; ActiveSheet.Cells(RowN, 1).Value = SpecifiedDir
> ActiveSheet.Cells(RowN, 2).Value = vFName
> Next
> End If
>End With
> End Sub
> '--end of code -
>
> Looking forward to hear if this code works (or no
Hi
There are plenty of solutions for listing open excel files.
I would like to list all excel workbooks on my C: and F: drives. They
are all over the place. My bad housekeeping!
How do I get the complete address for each workbook ? either with a
hyperlink or not. But do need to print out t
lls(sr,
"G"), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, *SearchFormat:=*True).Row
Thanks
Charlie Harris
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
> *From:* Cab Bo
ress.
Regards
Charlie Harris
On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI wrote:
> Dear Cab Boose,
>
> Please use try function.
>
> Copy this formula and paste it in define name and provide name range *
> IsBold
> =GET.CELL(20,INDIRECT("RC[1]",FALSE))
&
umns("g").Find(What:="email", After:=Cells(i, "G"),
> LookIn:=xlValues, _
> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
> 'MsgBox em
> ms = Cells(c.Row, "g") & " " & Cells(ph, "g") & &qu
Hi
Have addresses like this: (columnG)
ABC COMPANY
123 Delta St
Town
Ph 0800123456
fax 234567
email1...@dfg.com
Sometimes there are more rows with irrelvant informtation
I want to select 3 of the rows :
ABC COMPANY Ph 0800123456 email 1...@dfg.com
And place them in a single row i
Hi Sushil
I cannot get the link to open. Are you able to email to me a xl file ?
Thanks
Charlie
On Wed, Dec 14, 2011 at 8:26 PM, sushil kumar wrote:
> Hi Manhar,
>
> Please see this link http://31.222.142.10:8080/openerp/login?db=&user=
>
> Database:ManufacturingM
> User: admin
> password:adm
Hi
I would like to use the 'File-Open' command in Excel to bring in a pdf
file and have it finish up in .xls format. Is there an add-in to do this
automatically or a vba way to have it converted. Most of the on-line
require the conversion to excel to be done before and creates its own
workbook
fset(-2) = "" Then
> tr = Cells(9, "m").End(xlDown).Row + 1
> br = Cells(Rows.Count, "M").End(xlUp).Row
> Cells(tr, "m").Resize(br - tr, 2).Delete
> End If
> End Sub
> Sub fixit() 'fire if event code stops working
> Application
get code.
Thanks and regards
Charlie Harris
On Tue, Oct 18, 2011 at 1:19 PM, Cab Boose wrote:
>
> Hi Don and ChilExcel
>
> Thanks for info. Don like earlier I have not put enough info. I should
> learn from this.
>
> See attached workbook with comments.
>
> Th
t;
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Cab Boose
> *Sent:* Monday, October 17, 2011 5:57 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Paste into a Named Range
>
> Hi
>
> I have a 2 cells in a row that I
to reverse direction of the motor"
> .Value = Abs(CLng(Not -.Value))
> End If
> End With
>
> End Sub
>
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> *
> On Sun, Oct 16, 2011 at 12:06 PM, Cab Boose wrote:
>
>> Hi Don & Sa
Hi
I have a 2 cells in a row that I want to copy into a named range (say
'serialNo') also only 2 columns.
Do I have to do the vba xcell up routine ? or should I be able to paste
into 'serialno' and it will go into next available row. I have tried
recording copy/paste, select 'serialno' but
llett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Cab Boose
> *Sent:* Friday, October 14, 2011 8:32 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Toggle a Cell value
>
> Hi Don and Sam
>
> Thanks for your input.
>
> I use
xit Sub
>> If Target = 1 Then
>> Target = 0
>> Target.Interior.ColorIndex = 4
>> Else
>> Target = 1
>> Target.Interior.ColorIndex = 3
>> End If
>> End Sub
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
Hi eveyrone
See attached sheet.
For a 12 volt motor speed direction, Forward or Reverse I want to have a
value of a cell to toggle back and forth between 0 and 1 and cell color also
to change each time between green and red.
Prefer to use a cell than use a toggle button, unless a toggle button
m [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* dimanche 4 septembre 2011 03:05
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Counter in a Cell
>
> ** **
>
> Hi Everbody
>
>
>
> Thanks
> Please find the attached file. I have used Spin button (Form Control). It
> can be used another sheet linked with sheet 1 – H11 as you requested.
>
> ** **
>
> *- Xcel Inspiration***
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@goog
Hi
In attached Sheet1, I want the cell to count from 0 to 16 up and down in
between. The count is of times up arrow and down arrow are pressed.
To set speed from, 0 to 16 for model railroad project.
Your advice appreciated.
Thanks
Charlie Harris
--
---
:
> … or a driver ?
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 30 août 2011 05:56
> *À :* excel-macros@googlegroups.com
> *Objet :* $$E
when you click on this, it will be Show in
> Add-in Menu bar when you need it can be use..
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Tue, Aug 30, 2011 at 12:10 PM, Cab
reply and attachment.
>
>
However the attachment opens Excel but will not show the workbook.
If you could check and resend for me that would be great.
Thanks and regars
Charlie Harris
>
>
>
> On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose wrote:
>
>> Hi OOPS
>
Hi once again
This is totally new subject. I have model railroads. I would like to
control from Excel.(there are some other software available but I would
like to use Excel)
I want to send from Excel to a bus wire digital information showing the loco
number and direction of travel (fwd/re
Hi
I would like to select an already named range and using a command button
convert it to dynamic named range by columns and rows.
Is this possible ? It would be a lot quicker than doing it manually each
time. I failed to make a lot dynamic when I set them up.
Appreciate your help, I am age
Hi
I have in attached workbook:
Has two worksheets- 'ByGroups' and 'ByAssly"
The two sheets should be the same, however they are in different order.
First Question: Which is the best way to find the differences between the
two sheets as at the moment so that corrections can be made. Have search
, Aug 29, 2011 at 11:18 AM, NOORAIN ANSARI
wrote:
> Dear Cab,
>
> If possible please provide a sample sheet..
>
> On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose wrote:
>
>> Hi
>>
>>
>> I have a list of data 5 columns 1000 rows. There are some blank rows in
>&g
Hi
I have a list of data 5 columns 1000 rows. There are some blank rows in this
list. Sometimes one sometimes several. I do not want to delete the rows.
I want a vlookup function or similiar, to lookup column A for the required
number and copy into normal cell where formula is. That is: just a n
reinstalled and would not expect any add-in to be there.
Thnaks
Charlei
On Sat, Aug 6, 2011 at 7:29 PM, Cab Boose wrote:
> Hi Everybody
>
> Thankyou for all your suggestions.
>
> Still no success. Have tried new 'user', have reinstalled Office 2000,
> have tried changi
gins else Create a New Login
> Account and try...*
>
> ** **
>
> *Best Regards,*
>
> *Venkat *
>
> *Chennai*
>
> ** **
>
> On Fri, Aug 5, 2011 at 12:44 PM, Cab Boose wrote:
>
> Hi Venkat
>
>
>
> Thanks for the refe
ks See if helps...
>
>
> http://www.leonelson.com/2009/08/25/windows-cannot-access-the-specified-device-path-or-file-you-may-not-have-the-appropriate-permissions-to-access-the-item/
>
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> On Fri, Aug 5, 2011 at 10:16 AM, Cab Boose
Hi
I am using Win7 and Excel 2000.
Have never had problems for years, but now all of a sudden Excel will not
open. Comes up with : "Windows can not access the specified device, path
or file."
I have been advised to reload Office 2000. A couple of questions:
1. Do I reload all of Office 200
Hi
Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in
one click. Magic.
Charlie
On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI wrote:
>
>
> Dear Vijay,
>
> Please find Error remover technique.
>
> * Errors-World* Error Type
> Erro
Hi
Where can I find some good info on :
When a macro runs I want a input box for user to insert the column range
A:(or B; or F: etc) and then a input box for the text to look for say
ABC or 123 or xyz etc and then a third box for the column for a format to be
done.
Have googled but have not
Hi Ashish
Thanks for that. How do I toggle the 'TabOrder' on ? At the moment the tab
order is not working.
Thanks
Charlie
On Thu, Jul 21, 2011 at 7:08 PM, ashish koul wrote:
> try this
>
>
> On Thu, Jul 21, 2011 at 11:36 AM, Cab Boose wrote:
>
>> Hi Rajan
&
Hi Daniel
Works perfect. I am very pleased with your help.
Regards
Charlie
On Wed, Jul 20, 2011 at 10:04 PM, Daniel wrote:
> My last effort ; see attached file.
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la
Hi everyone
Excel 2000 Win7
I am using code below to enter data onto a sheet. The sheet works well in
entering data, but when you go back to an entry above and delete the current
data and put in the correct data, on the delete key it deletes all data
entered and user has to start over again.
Ho
cel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 06:27
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Daniel**
>
> .Width = .Width / 2
>
> End With
>
> End If
>
> Res = Target.Address
>
> With Target.Comment.Shape
>
> .Height = .Height * 2
>
> .Width = .Width * 2
>
> End With
>
> End Sub****
>
> ** **
&g
Hi Ashish and all
I have a spreadsheet (thanks to Ashish) that uses comments boxes. The size
of the box is great. But on some occassions the user will want to see a
larger box. I know it can be increased thru edit and resize etc but is
there a way to say have a right click where the size could
Whole)
>>
>> If Not x Is Nothing Then
>>
>> Set Var = x.Offset(, 1)
>>
>> x.Offset(, 1).Copy
>>
>> Rg.Offset(, 2).PasteSpecial Paste:=xlPasteComments
>>
>> End If
>
Hi
Is someone able to comment on my problem as below. Tried to contact Daniel
with no luck.
Thankyou
Charlie Harris
On Fri, Jul 8, 2011 at 1:13 PM, Cab Boose wrote:
> Hi Daniel
>
> Thanks for code. Have done as you suggest and installed in the Shipments
> wb. When I run the c
**
>>
>> Set Var = x.Offset(, 1)
>>
>> x.Offset(, 1).Copy
>>
>> Rg.Offset(, 2).PasteSpecial Paste:=xlPasteComments
>>
>> End If
>>
>> Next Rg
>>
>> End With
&g
Hi
Have a photo in a comments box in Database.xls. Also have a vlookup in
another workbook Shipment-New.xls to bring forward the text from the cell
into
the wb. This works great. I also want to bring forward the comment box
in the same cell from Database.xls into Shipment-New.xls.
Would li
78 matches
Mail list logo