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
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
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
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,
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
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 aks.sharm...@gmail.comwrote:
Please try the below one.
Sub PasteValueOnly()
Dim rng As
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 only
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.
the solution 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 based on single column
] *On
Behalf Of *Cab Boose
*Sent:* Saturday, March 17, 2012 2:47 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Turn Tab Order on/off
Good Day Asa
Are you able to assist with this for me. Would be greatly appreciately.**
**
Thanks
Charlie
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 swch...@gmail.com wrote:
Hi Asa
At the moment the H1 setting makes no difference. The sheet works like
normal with the setting at activate
, f89, h89, j89?
** **
Asa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
*Sent:* Saturday, March 03, 2012 10:07 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Turn Tab Order on/off
** **
HI
(strMacroNames, ,)(lngLoop - 1)
.OnAction = Split(strMacroNames, ,)(lngLoop - 1)
End With
End With
Next
End Sub
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 6:44 AM, Cab Boose swch...@gmail.com wrote:
Hi
Xl2000
I want to add some macros
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
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
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 mmun...@ccc.com.qa wrote:
**
--
FORUM RULES (986+ members already BANNED
With ActiveSheet
.Name = what
'===
With Sheets(List).Range(d9:G1000)
.AutoFilter Field:=4, Criteria1:==* what *, Operator:=xlAnd
.Copy Sheets(bolt).Range(A1)
.AutoFilter
End With
'===
.Columns.AutoFit
End With
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Cab Boose
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
at 11:41 AM, Cab Boose swch...@gmail.com wrote:
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
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 swch...@gmail.com wrote:
HI
Have this code:
Sub GetColumnRef()
Dim MyInput
MyInput
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
With
End Sub
** **
Asa
** **
*From:* excel-macros@googlegroups.com [
mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com] *On
Behalf Of *Cab Boose
*Sent:* Saturday, February 04, 2012 4:27 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Text
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
*Sent:* Saturday, February 04, 2012 10:48 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ vlookup in Text Box
** **
Hi
See attached worksheet. Excel2000
I have userform1 and one
... 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:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros
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
If
End With
End Sub
** **
Asa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
*Sent:* Saturday, February 04, 2012 4:27 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Text Box - Properties
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
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)
/
On Wed, Jan 11, 2012 at 6:20 AM, Cab Boose swch...@gmail.com wrote:
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
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
*From:* Cab Boose swch...@gmail.com
*Sent:* Thursday
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
.
siti Vi
On Fri, Dec 23, 2011 at 4:45 AM, Cab Boose swch...@gmail.com wrote:
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
.
Regards
Charlie Harris
On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
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))
See attached sheet for reference
:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, *SearchFormat:=*True).Row
Thanks
Charlie Harris
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Cab Boose swch...@gmail.com
*Sent:* Saturday, December 17, 2011 2:05
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
'MsgBox em
ms = Cells(c.Row, g) Cells(ph, g) Cells(em, g)
Cells(Rows.Count, h).End(xlUp).Offset(1) = ms
'MsgBox ms
i = i + em
End If
Next
Columns(H).AutoFit
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Cab Boose swch...@gmail.com
*Sent:* Thursday, December 15
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 sushilck.sha...@gmail.comwrote:
Hi Manhar,
Please see this link http://31.222.142.10:8080/openerp/login?db=user=
Database:ManufacturingM
User:
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
fixit() 'fire if event code stops working
Application.EnableEvents = True
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Cab Boose swch...@gmail.com
*Sent:* Tuesday, October 18, 2011 3:06 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Paste
to get code.
Thanks and regards
Charlie Harris
On Tue, Oct 18, 2011 at 1:19 PM, Cab Boose swch...@gmail.com 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.
Thanks, apologies and regards
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
(Not -.Value))
End If
End With
End Sub
Regards,
Sam Mathai Chacko (GL)
*
On Sun, Oct 16, 2011 at 12:06 PM, Cab Boose swch...@gmail.com wrote:
Hi Don Sam
Don. appreciate your comment. I had not made it clear what I was
looking for. Apologies.
Sam, yes it is working
SalesAid Software
dguille...@gmail.com
*From:* Cab Boose swch...@gmail.com
*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 want to copy into a named range (say
'serialNo
SalesAid Software
dguille...@gmail.com
*From:* Cab Boose swch...@gmail.com
*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 Win7 Excel and on a laptop.
Don
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
Guillett
SalesAid Software
dguille...@gmail.com
*From:* Cab Boose swch...@gmail.com
*Sent:* Friday, October 14, 2011 2:33 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Toggle a Cell value
Hi eveyrone
See attached sheet.
For a 12 volt motor speed direction, Forward
@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 for all your options.
I would like to explain a little more. I want
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@googlegroups.com] *On Behalf Of *Cab Boose
*Sent:* 03 September 2011 05:13
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
--
dcolarde...@free.fr wrote:
… 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 :* $$Excel-Macros$$ Excel and Sending
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 swch...@gmail.com wrote:
Hi OOPS
This time attached.
Thanks
it is Add-In file 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 Boose swch...@gmail.coim wrote:
Hi
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
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
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
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
, Aug 29, 2011 at 11:18 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Cab,
If possible please provide a sample sheet..
On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose swch...@gmail.com wrote:
Hi
I have a list of data 5 columns 1000 rows. There are some blank rows in
this list. Sometimes
,*
*Venkat *
*Chennai*
** **
On Fri, Aug 5, 2011 at 12:44 PM, Cab Boose swch...@gmail.com wrote:
Hi Venkat
Thanks for the reference. I was pretty sure that it would work.
Unfortuanately no. I still get the same message.
Any other options ? I am sure
reinstalled and would not expect any add-in to be there.
Thnaks
Charlei
On Sat, Aug 6, 2011 at 7:29 PM, Cab Boose swch...@gmail.com wrote:
Hi Everybody
Thankyou for all your suggestions.
Still no success. Have tried new 'user', have reinstalled Office 2000,
have tried changing the settings
below links 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 swch...@gmail.com wrote:
Hi
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 2000
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 noorain.ans...@gmail.comwrote:
Dear Vijay,
Please find Error remover technique.
* Errors-World*
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 koul.ash...@gmail.com wrote:
try this
On Thu, Jul 21, 2011 at 11:36 AM, Cab Boose swch...@gmail.com wrote:
Hi Rajan
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.
End With
End Sub
Regards.
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* Cab Boose
*Envoyé :* lundi 18 juillet 2011 09:56
*À :* excel-macros@googlegroups.com
*Objet :* $$Excel-Macros$$ Comments
@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
Thanks for a great result. Not quite
= .Height * 2
.Width = .Width * 2
End With
End Sub
** **
Regards.
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* Cab Boose
*Envoyé :* lundi 18 juillet 2011 09:56
*À :* excel-macros
End If
Next Rg
End With
End Sub
** **
Regards.
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *De la part de* Cab Boose
*Envoyé :* jeudi 7 juillet 2011 08:56
*À :* excel-macros@googlegroups.com
*Objet
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 swch...@gmail.com wrote:
Hi Daniel
Thanks for code. Have done as you suggest and installed in the Shipments
wb. When I run
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
.
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *De la part de* Cab Boose
*Envoyé :* jeudi 7 juillet 2011 08:56
*À :* excel-macros@googlegroups.com
*Objet :* $$Excel-Macros$$ VBA Comment Box - Copy of
** **
Hi
Have a photo
75 matches
Mail list logo