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" <bengoody@discussions.microsoft.com> wrote in message
news:D33B9569-2D2E-4660-91F9-578A2A61589E@microsoft.com...
>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
reseller.
...
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
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"brogers" <brogers@discussions.microsoft.com> wrote in message
news:F8A2506C-44A3-46BB-9399-22C5A07F999A@microsoft.com...
>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 challengeok, 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
Friends,
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
End If
QuitCode:
...
Wont copy and paste using VBAI 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:
Sub ExportData()
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
(not OEx)?
Thanks
"Richard" <Me@noreply.com> wrote:
>Is there a way to turn on spell checking using a registry key for outlook
>(not OEx)?
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: shashdsurfer@hotmail.com
>thanks
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 - afshin@rrdisti.com
Retail Realm
= = = = = = = =
"Trinidave" <Trinidave@discussions.microsoft.com> wrote in message
news:510A04B8-1566-4772-BE9F-FDE38467D25D@microsoft.com...
> hello good day can someone please email me a copy of the custimization
> guide
> and sour...
how can I turn a spreadsheet from excel 2001 to into a xml fileI only got 2003 office today and I need to convert an older xls file to a xml
file. How can I do this?
Vet wrote:
> 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.
gls858
...
you cannot save to this file format when the VBA project is protectedUrgent !!
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.
Thanks,
jchan
--
Message posted via http://www.officekb.com
This is n...
Add fields of Scroll window in VBA ?Hi,
I am able to add other fields in form but I am unable to add fields of
scrolling window in VBA.
Thanks in advance
--
Aditya
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 OWAHi 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,
Paul Stephenson
...
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" <sfdavidkaye2@yahoo.com> wrote in message
news:i089v8$qrf$3@news.eternal-september.org...
: 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.
I just Googled it. Losts of example there. Any reason you couldn't try
that first?
--
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 VBAHello,
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
Selection.Copy
Worksheets("SUMM").Activate
Range(Cells(startrow, 1), Cells(endrow, 12)).Select --- ERROR HERE
ActiveSheet.Paste
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 checkI 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".
jerryb wrote:
> 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 VBAHi,
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
Scenarios(intLooping).Show
Next
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
Next
MsgBox Scenarios(1).Name & " - to - " &...
Trapping Print event in excel vbaHi,
I'm trapping the App_workbookbefore Print Event which is working
wonderfully!
See http://www.cpearson.com/excel/AppEvent.aspx
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:
Sub ShowSelectedSheets()
Dim Sh As Worksheet
For Each Sh In ActiveWindow.SelectedSheets
MsgBox Sh.Name
Next
End Sub
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 pleaseBasically, 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
1)"),--(DataPosition=N6),(DataQuestion1)
When I change this to Count rather than Sum, my Code Evaluates as an Error
=SUMPRODUCT(--(DataTime="First day of employment (Time
1)"),--(DataPosition="Registered Nurse"),--(DataQuestion1<>"*"))
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 listDoes anyone know code to automatically expand a combo box list when the
control receives the focus and collapses it when the focus is lost?
Thanks
In the Enter event, or GotFocus event use:
Me.ComboBoxName.Dropdown
When you exit the combo box control the list will retract.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"Graham Walker" <walgra@dodo.com.au> wrote in message
news:465c37cf$0$90645$c30e37c6@lon-reader.news.telstra.net...
> Does anyone know code to automatically expand a combo box list when the
>...
Code For On Mouse Move EventThis is a multi-part message in MIME format.
------=_NextPart_000_003E_01CAABB2.CA5D7010
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Access 2007 sp2.
I've changed from command buttons to labels for certain aspects of my =
db.
I want to use the on mouse move event over the labels to trigger some =
visual
indication that one's mouse pointer is over the label and then have it =
return
to normal when the pointer leaves the label. Like when moving over a =
command button.
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
some such.
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.
tmb
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
Excel 2003
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
can't find.
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 - vbaChers tous,
j'ai �crit la fonction suivante pour changer la propri�t� filterOnLoad
de chaque formulaire de la db.
*************************
Function correctAccess2007()
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
Next
MsgBox "forms:" & i
End Function
**********************
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 copyUsing 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, _
Criteria2:="<38999"
Range("A1").Select
...... (copy paste routine)
What is the most efficient syntax to convert the above code to handle:
">=20000 and =<35000"
AND
">=35500 and <38999"
TIA
Dennis
I think you've got trouble.
First, autofilter can only have 2 criteria.
And secondly, I do...
Concealing VB codeIn 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.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Karl Irvin" <88karl3200@comcast.net> wrote in message
news:a-mdnQTVwrzJaSvfRVn-1Q@comcast.com...
> In Excel 2000 or later, can you develop a spreadsheet ...