How can I import Excel Sheet(UPC Code) into Retail Management Sys.
I collect UPC codes from my venders. Most of them are Excel sheet. Is there
any to import Excel sheet into Retail Management System?
Yes there is an import utitily
"bengoody" <firstname.lastname@example.org> wrote in message
>I collect UPC codes from my venders. Most of them are Excel sheet. Is there
> any to import Excel sheet into Retail Management System?
You can download the Import Utility from CustomerSource, or talk to your
...Turn auto hyphenation off permanently in publisher?
I would like to turn the automatic hyphenation off in publisher. I have to
do it manually for every text box.
Tools, Options, Edit tab, clear Hyphenation...
Mary Sauer MSFT MVP
"brogers" <email@example.com> wrote in message
>I would like to turn the automatic hyphenation off in publisher. I have to
> do it manually for every text box.
...A difficult VBA question...a challenge
ok, I'm not a pro, but this task seems like an extremely
difficult task - so hopefully someone is up to the challenge!
I have a MS Access 2003 database. I would like to use
VBA to accomplish the following tasks (keep in mind this
is originating from Access and not Outlook)...
I would like to take an email address and instead of creating a new message
to it I would like to REPLY to the last one that was received
from that address. Obviously the only real difference is that the
body of the message from the previous received message will
be included. Keep in mind I am talking about sendi...How to make two codes "Worksheet_Change" work together in same sheet code page
Please, anybody knows how to make these two VB codes work together?
When I put them together in the same "sheet code page" in VBA, th
second one doesn't work. Why?
*** Code 1 ***
Private Sub Worksheet_Change(ByVal Target As Range)
* * On Error GoTo QuitCode
* * If Intersect(Target, Range("c1:c15")) Is Nothing Then
* * * * Exit Sub
* * ElseIf Target.Value <>*"" And Target.Offset(0, -1).Value = "" Then
* * * * MsgBox "You haven't typed the name of the client yet."
* * * * Target.Offset(0, -1).Activate
...Wont copy and paste using VBA
I have a very large worksheet with a number of people on it. There are
multiple rows of data for each of these people.
I have managed to write code to set up a member tab for each of these
people (over 1000 !) but what I now want to do is copy the data for
each person to the relevant worksheet.
This is my code:
Dim wb As Workbook
Dim ws As Worksheet
Dim strSheetName As String
Set wb = Workbooks("PWSallocationsv1 3 (2).xls")
For Each ws In wb.Worksheets
If Not ws.Name = "Sheet1" Then
If Not ws.Name = "Raw Data" Then
'M...Turn on SpellCheck using registry?
Is there a way to turn on spell checking using a registry key for outlook
"Richard" <Me@noreply.com> wrote:
>Is there a way to turn on spell checking using a registry key for outlook
What's wrong with using the setup options in the program itself?
Unfortunately we have around ~2,500 pc's where it may or may not be turned
on. Take that number and average out the number of people who can actually
follow instructions and that leaves us with about ~2499 pc's to make sure
auto-spell check is enabled...
"Uncle Grump...RMS customization guide and source code!
hello good day can someone please email me a copy of the custimization guide
and source code PLEASE!!
my email: firstname.lastname@example.org
lol - I do not believe that Microsoft will give source code out :) I will
email you a few technical documents that you may find useful.
Afshin Alikhani - email@example.com
= = = = = = = =
"Trinidave" <Trinidave@discussions.microsoft.com> wrote in message
> hello good day can someone please email me a copy of the custimization
> and sour...how can I turn a spreadsheet from excel 2001 to into a xml file
I only got 2003 office today and I need to convert an older xls file to a xml
file. How can I do this?
> I only got 2003 office today and I need to convert an older xls file to a xml
> file. How can I do this?
open the spreadsheet select File > save as and in the drop down box at
the bottom select XML spreadsheet.
...you cannot save to this file format when the VBA project is protected
How can we abe to save the worksheet and at the same time still able to
protect the VBA project coding for viewing ? This development is just like
creating a Template with many macros programming and you do not want the
users go into the project and modify your programs.
It can be done before, why in Excel Visual Basic version 6.3 when you
protect the project for viewing , you workbook can not be saved any more,
unless you unprotect your project coding ?
Your kind solution at this matter is greatly appreciated.
Message posted via http://www.officekb.com
This is n...Add fields of Scroll window in VBA ?
I am able to add other fields in form but I am unable to add fields of
scrolling window in VBA.
Thanks in advance
While I'm happy you have things solved, I don't believe what you have below
is the correct solution. You should be able to add any fields of any
scrolling window to your project. I'm darn sure that is the case because
I've used VBA to pull values from lookup windows before and those are of
course browse only.
My only note for scrolling windows is you have to make sure the window is
"filled" before you try to add it to vba. ...Errors in OWA
Hi everyone, I have a problem that I have never seen before. When one of
our remote users who is using OWA, Exchange 2003 Service Pack 1, with IE on
Windows XP tries to reply to a message or send a new message sometimes the
email address will turn red and he is unable to send the message. Has
anyone ever seen this before and maybe know how to fix.
This seems like some kind of an address book issue or something.
Thanks in advance,
...AAC/M4A VB Tag Decoder Source Code ??
Does anybody have source code that can read AAC/M4A audio files in order to
extract the tags? I'm working in VB 6.0.
"David Kaye" <firstname.lastname@example.org> wrote in message
: Does anybody have source code that can read AAC/M4A audio files in order
: extract the tags? I'm working in VB 6.0.
I just Googled it. Losts of example there. Any reason you couldn't try
Customer Hatred Knows No Bounds at MSFT
Free usenet access at http://www.eternal-september.org
ClassicVB Users ...Question about how to use range in VBA
I am trying to cut and paste one range from one sheet to the same
range in a different sheet. I used the following code:
Range(Cells(startrow, 1), Cells(endrow, 12)).Select
Range(Cells(startrow, 1), Cells(endrow, 12)).Select --- ERROR HERE
This code gives me an error where indicated: Application defined or
Object defined error
Notice that I use the exact same line of code three lines earlier and
I get no error. If I change my code to read as
Range(Cells(startrow, 1), Cells(endrow, 12)).Sel...how do I turn off the automatic spelling and grammer check
I don't use the auto check on spelling and grammer and it is a nusanise
always popping up when I try to send an email. Please can anyone tell me how
to shut the darn thing off. using office 2007
Open Help, look up Check Spelling click link for
Check spelling and grammar, then "Outlook".
> I don't use the auto check on spelling and grammer and it is a nusanise
> always popping up when I try to send an email. Please can anyone tell me how
> to shut the darn thing off. using office 2007
Bob I wrote:
> jerryb wrote:
...Excel 2007 VBA
I have a number of scenarios that I need to perform some calculations on.
I am trying to keep the code short by having a for - next loop running
through all the scenarios.
I am not having much luck getting that to work, though.
Shouldn't the following work?
For intLooping = 1 To 20
The following, on the other hand, does work (but doesn't do any good).
For intScenNr = 1 To 20
arrScenarios(intScenNr - 1) = Scenarios(intScenNr).Name
MsgBox Scenarios(1).Name & " - to - " &...Trapping Print event in excel vba
I'm trapping the App_workbookbefore Print Event which is working
But The Question I've got is it possible to return what sheet, if only
one sheet is printed or sheets if multiple sheets are printed.
You can return the sheets selected like this:
Dim Sh As Worksheet
For Each Sh In ActiveWindow.SelectedSheets
but if the user chose to print 'Entire workbook' instead of the default
'Active sheet(s)' I'm not sure you can detect ...Sumproduct formula works in spreadsheet, NOT VBA. Help please
Basically, I want to replace this formula with VBA Code
I can get this one to work to sum
=SUMPRODUCT(--(DataTime="First day of employment (Time
When I change this to Count rather than Sum, my Code Evaluates as an Error
=SUMPRODUCT(--(DataTime="First day of employment (Time
The only line of code I switch out is the last mFormula row. The line of
code that works I've commented out. I am really stumped...
This is the cod...Code to expand/collapse combo box drop-down list
Does anyone know code to automatically expand a combo box list when the
control receives the focus and collapses it when the focus is lost?
In the Enter event, or GotFocus event use:
When you exit the combo box control the list will retract.
Arvin Meyer, MCP, MVP
"Graham Walker" <email@example.com> wrote in message
> Does anyone know code to automatically expand a combo box list when the
>...Code For On Mouse Move Event
This is a multi-part message in MIME format.
Access 2007 sp2.
I've changed from command buttons to labels for certain aspects of my =
I want to use the on mouse move event over the labels to trigger some =
indication that one's mouse pointer is over the label and then have it =
to normal when the pointer leaves the label. Like when moving over a =
I used to have code for this but I was...In Excel vba how do you Launch code a standalone Module from a Form or other Module ?
I can create stand alone modules in Excel vba by clicking File New Module or
How can I run the code in those stand alone modules from another module or a
Form that has its own code?
Thanks for any help.
If you're talking about "New Project" from the VBA File menu,
this create a new VBA project that is used to create COM Add-Ins,
a discussion of which is beyond the scope of a newsgroup reply.
In general, you want to use the Insert menu to create a new
module in an existing workbook.
In VBA, there is no such thing as a "stand-alone" module; all...how many PC's can I download Money 2006 into?
Does someone know into how many PC's I can download a version of money 2006?
I bought it last year and downloaded online, but my PC crashed last week. Now
I was looking to see if I could just go to a msn.com/money and download it
again for free since I already paid for it last year.
thanks for your help.
In microsoft.public.money, EP wrote:
>Does someone know into how many PC's I can download a version of money 2006?
>I bought it last year and downloaded online, but my PC crashed last week. Now
>I was looking to see if I could just go to a msn.com/money and download i...Chart Documenting Via VBA Questions
I've got a -lot- of Excel charts to document. I'm doing it all via VBA
procedures and saving the results into an Access table. Access VBA is
my main proficiency, so I've got to learn a lot about the Excel Object
Model. I've tracked down a lot of data, but here are a couple I just
1. The formula used in a ChartTitle. I see it in the formula bar when
it's selected, but everywhere I look it only returns the currently
showing text: the formula result. I *need* the formula, and I've got to
get it using VBA. It's obviously saved somewhere!
2...access 2007 - vba
j'ai �crit la fonction suivante pour changer la propri�t� filterOnLoad
de chaque formulaire de la db.
Dim Ff As Form, i As Integer
i = 0
For Each Ff In Forms
i = i + 1
DoCmd.OpenForm Ff.Name, acDesign
Ff.FilterOnLoad = False
DoCmd.Close acForm, Ff.Name, acSaveYes
MsgBox "forms:" & i
quand j'ex�cute sous access2007, il affiche "0".
Si j'utilise le m�me code pour modifier une propri�t� existant en access
2000/2002/2003 (filter, back...VBA AutoFilter how to apply 2 ranges for selection to copy
Using XL 2003 & 97
Currently the code below works fine. It selects values equal to or greater
than 20000 but less than 38999.
Cells.AutoFilter Field:=3, Criteria1:=">=20000", Operator:=xlAnd, _
...... (copy paste routine)
What is the most efficient syntax to convert the above code to handle:
">=20000 and =<35000"
">=35500 and <38999"
I think you've got trouble.
First, autofilter can only have 2 criteria.
And secondly, I do...Concealing VB code
In Excel 2000 or later, can you develop a spreadsheet with a lot of VBA code
and hide or compile the code so users can't see or modify it?
Hi, Karl. Right-click the module and choose Properties to get to the
password dialog. Keep in mind that many people know how to crack even VBA
code passwords, so Excel apps are NEVER really secure.
"Karl Irvin" <firstname.lastname@example.org> wrote in message
> In Excel 2000 or later, can you develop a spreadsheet ...