Over 1 million tech questions and answers.

Macro for Work Distribution !!

Q: Macro for Work Distribution !!

Hello Everyone,

Could you please post the full macro which would help me in distributing office work?...Lets say there are four rows of work and two executives, so the work should be distributed equally as 2 each and that too on random order on a separate sheet.

I really don't know how to develop macros. Thanks for your help !!

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Macro for Work Distribution !!

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 62

I've used the following from Rollin_Again, but the macro stops at the first bit of code. My Excel Spreadsheet has only the three columns, first name, last name, and email, but I can;t get past Public Sub....

I sure need to do this, would evveen buy software if available.

Help???

Public Sub DistributionList()

Dim objOutlook As New Outlook.Application
Dim objNameSpace As Outlook.Namespace
Dim objDistList As Outlook.DistListItem
Dim objMail As Outlook.MailItem
Dim objRecipients As Outlook.Recipients
Set objNameSpace = objOutlook.GetNamespace("MAPI")
Set objDistList = objOutlook.CreateItem(olDistributionListItem)
Set objMail = objOutlook.CreateItem(olMailItem)
Set objRecipients = objMail.Recipients
objDistList.DLName = InputBox("Enter name of Distribution List")

For i = 1 To Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row
objRecipients.Add (Range("C" & i).Value)
Next i

objDistList.AddMembers objRecipients
objDistList.Display
objRecipients.ResolveAll

Set objOutlook = Nothing
Set objNameSpace = Nothing
Set objDistList = Nothing
Set objMail = Nothing
Set objRecipients = Nothing

End Sub

 

A:Macro Excel to Distribution in Outllok

By the way I'm on Vista 32 bit, 4GB RAM
 

Read other 1 answers
RELEVANCY SCORE 61.6

I need a macro that will 1) create a new outlook folder, then 2) create new Outlook distribution lists from data in an Excel sheet.

The Excel sheet has columns:
A - ID
B - DEPARTMENT_DESC
C - STUDENT_LEVEL_DESC
D - MAJOR_DESC
E - PROGRAM_DESC
F - EMAIL_ADDRESS
G - LAST_NAME
H - FIRST_NAME

The first entry begins in row 2 with row 1 being the column title.

I need a new distribution list to be created for each department (column B) and each student level (column C). (Column B will only ever be one of 6 values, column C will only ever be one of 2 values. Therefore, the macro should create 8 distribution lists.)

I have looked at threads similar to this question but I can't seem to get anything working.
 

A:Macro from Excel to New Outlook Distribution List

I saw something you might could work with here: http://www.helenfeddema.com/CodeSamples.htm
scroll down for sample 61. I haven't used it but marked it one day. I'm assuming your wanting to make local distb list? Not in AD.
 

Read other 1 answers
RELEVANCY SCORE 52

This is personal SCCM but I need some help.

When I have msi application and want to distribute the content to SCCM and DP as distribution pons, DP received it and SCCM did not failed got this message  (Distribution Manager failed to connect to the distribution point ["Display=\\SCCM-M3N.M3N.com\"]MSWNET:["SMS_SITE=M3N"]\\SCCM-M3N.M3N.com\.
Check your network and firewall settings.)
Please help

Read other answers
RELEVANCY SCORE 45.6

Hello All...

I am currently working with a word document that is about 750 pages (generated from a report ). Because the report is often generated severl times a month… My goal is to make this document "easier" to navigate by creating a header for the “specific” name referenced in the first table on each page. This will enable me to add a table of contents and the ability to see the document map.

I created a macro to do this... However, I do not understand how to tell the macro to… go to the next page.. repeat… stop at the last page… skip blank pages.

Using MS Word 2007

Thank you in advance for any help offered!

Sub TESTPPDS()
'
' TESTPPDS Macro
'
'
Selection.MoveRight Unit:=wdCell
Selection.Copy
Selection.MoveDown Unit:=wdLine, Count:=1
Selection.Paste
Selection.MoveLeft Unit:=wdCharacter, Count:=23, Extend:=wdExtend
Selection.Font.Size = 3
Selection.Font.Color = -603914241
WordBasic.FormatStyle Name:="Heading 1", NewName:="", BasedOn:="", _
NextStyle:="", Type:=0, FileName:="", Link:=""
With ActiveDocument.Styles("Heading 1").Font
.Name = "Verdana"
.Size = 3
.Bold = True
.Italic = False
.Underline = wdUnderlineNone
.UnderlineColor = wdColorAutomatic
.StrikeThrough = False
.DoubleStrikeThrough = False
.Outline = False
.Emboss = False
.Shadow = False
.Hidden = False
.SmallCaps = False
.AllCaps = False
.Color = -603914241
.Engrave... Read more

Read other answers
RELEVANCY SCORE 44.8

Have an Access 2000 form that includes a subform for a child table. I want to update a checkbox which IS on the subform after the user enters a value in the field [Result]. Wrote a SetValue macro as follows and call it AfterUpdate:

Item: [Forms]![TestDetailSubform]![InitialDrugTest]

Expression: IIf([Forms]![TestDetailSubform]![InitiaDruglTest]=No,IIf([Forms]![TestDetailSubform]![TestType]="I" And [Forms]![TestDetailSubform]![Result]="P",Yes,No))

I've tried several iterations, but every time it runs, I get the message "Microsoft Access can't find the form 'TestDetailSubform' referred to in a macro expression or VB code". This is difficult to understand, since the field that has the macro is IN the TestDetailSubform!?! Why am I getting this message/how can I make the macro do what it's supposed to do?
 

A:Update macro doesn't work

Never mind! I found the answer. You'd think after using Access for 5 years that I'd remember that in a SetValue macro, you DO NOT/CANNOT include [Forms]![Formname] in the expression; you must only include the control name. So all of the "[Forms]![TestDetailSubform]" text in the expression has to be removed... after which it works fine.

Sorry for cluttering the forum with junk...
 

Read other 1 answers
RELEVANCY SCORE 44.8

Hi!
I created a macro for moving rows from worksheet A to worksheet B. And it worked fine when I ran it as a macro.
Then I created a CommandButton and copy-pasted the code there (to be ran by click) and it didn't work anymore! I tested it, and the commandbutton-action works fine within one worksheet. But then when it should move between sheets (within the same file) - nope, doesn't work anymore...!!!

Can someone give me some advice how to solve this problem.
I would prefer the commandbutton (vs. running it as a macro)
Thanks.
 

A:Solved: Macro does not work from CommandButton

Read other 11 answers
RELEVANCY SCORE 44.8

Can you write a macro that will copy something from excel and paste it into word?

If so how do you do it? Do you write the macro in Excel or Word?

Many thanks
 

A:Macro to work in Word and Excel?

Yes, this can be done. Describe in detail exactly what you are trying to do and I'll write you a sample macro. Where should the values appear in the Word document? Which cell values will you be using? If you could .ZIP and attach some sample files that would make things much easier.

The basic steps are:

1) Set reference to Word library in your VBA Editor in Excel
2) Create a new instance of Word Application within your Excel project.
3) Execute your code on the instance of Word application.
Code:
Dim wdApp As Word.Application

Set wdApp = New Word.Application

wdApp.Visible = True

wdApp.Documents.Open ("C:\Documents and Settings\DocumentName.doc")

'ADD MORE CODE HERE

WdApp.Quit
Rollin
 

Read other 2 answers
RELEVANCY SCORE 44.8

Hi Magicians

Sorry to trouble the experts with this query but am having no luck elsewhere.

I have tried a number of well known macro schedulers/keyloggers etc to produce a macro to carry out some tasks with a couple of programs open one of which is an old dos program and while the macro logger will recognise the Enter key on the keyboard there are a number of keys it won't recognise when in the dos program window. eg. up and down keys, Function keys and Number pad keys.

Can anyone suggest something I might try as a middle level computer user.

With thanks

Mike.
 

Read other answers
RELEVANCY SCORE 44.8

Hi "Masters of VBA",

I was wondering if you were able to help me out on a situation that i have where i am trying to do something on my own on a data conversion project at work. I need a vba code runned in a macro where whenever i find the word "confidential" it will delete that row including the following 6 rows below. And i have to loop it as many times as it comes in the file and mind you this file is massive and i ain’t allowed to send it as you know its a matter of confidentiality. And secondly i need a similar code where whenever i find the word MLI GST i can then delete it and the next 12 rows below.

Basically, I am only interested in the middle part of the file, which contains the juicy information with the columns etc. What i am trying to delete is the header (which includes the name and address of the client) and the footer summary. If there is anyone i know who can do some crazy stuff with VBA it would be you so that’s why i am coming to you for help.

Just a recap i will do a sort of pseudo code (i hope it makes some sense)

{Code to remove the header}

i = confidential
Do Loop
If (Ctrl Find = "Confidential"),
Delete 6 rows below (which also includes the row that contains the word confidential)
Next i
Else
Leave everything as is.
End Loop

{Code to remove footer}

i = "MLI GST"
Do Loop
If (Ctrl find = "GST MLI"),
Delete 12 rows below (which also includes the row which contains MLI GST)
Next... Read more

A:VBA macro urgent help for project at work!!!

Read other 8 answers
RELEVANCY SCORE 44.4

Have an Access 2000 input form (Signups) that contains a subform (HowPaidSubform). The subform contains two bound fields, [Posted], a checkbox, and [PostDate], a date field with m/d/yy format. I want the current date automatically entered into [PostDate] when [Posted] is checked, so wrote a simple macro:

Item: [Forms]![HowPaidSubform]![PostDate]
Expression: Date()

If I open the subform by itself, the macro works perfectly. But with the parent form open with the subform in it, it does not work; error message says it can't find the HowPaidSubform.

What am I doing wrong?
 

A:Solved: Macro in subform doesn't work

Read other 16 answers
RELEVANCY SCORE 44.4

Hi,
I have found this VBA macro that is supposed to copy numbers in a range over an indeterminate number of rows and 6 columns to a single column of the values excluding blank cells. In this case it copies all cells in A:F into column J

It does work, but it copies from right to left (eg starts at column F and finishes at Column A. Does anyone know how to make this work from column A to F instead? Or an alternative macro that will do that?

Thanks,
janie

Sub x()

Dim rng As Range, i As Long

Sheet1.Columns("J").ClearContents

For Each rng In Sheet1.UsedRange.Columns("A:F").SpecialCells(xlCellTypeConstants)
i = i + 1
Sheet1.Cells(i, 10) = rng
Next rng

End Sub
 

A:Solved: How to make VBA macro work from left to right

Read other 13 answers
RELEVANCY SCORE 44.4

Hey!

I tried to add "Abacus 2.0" (tool to calculate reference limits in laboratory analysis; http://www.abacus-validation-systems.de/) into my excel, but i only receive the error "Some objects couldn't be loaded, because they are missing on this computer." (translated from german )

Afterwards i confirmed two times the same failure and a new error appears: "Compiling error in the masked modules. This failure normally occurs if the code isn't compatible with the version, platform or architecture of this application." (translated again from a german error)

Again i have to confirm two times and excel finally loads. the add-in "Abacus" is available in excel, but as soon as i click at any button i have to see this error:
"Cannot run the macro 'RibbonXOnAction'. The macro may not be available in this workbook or all macros may be disabled."

All my security settings are wide open. I have searched the web high and low and can'tfind a solution to this issue. Please help me! Thanks in advance!

Best regards,
hanjef
 

Read other answers
RELEVANCY SCORE 44.4

I have a macro written in one of my Excel worksheets but I want to be able to use it in all of the worksheets in the workbook. If I insert a module and put the macro there it doesn't. What do I need to do to get it to work in all sheets?
 

A:How do you make a macro work on all sheets in a workbook?

Read other 6 answers
RELEVANCY SCORE 44.4

I used the Find and Replace dialog box in Word 2003 to find paragraphs formatted with 1 inch left indent and 0 inch right indent. With the box for "Highlight all items found in Main Document" checked, clicking "Find All" selects all the paragraphs in the document that have this formatting, many of which are non-contiguous, which is exactly what I want. I used the Macro Recorder to record this action. But when I execute the recorded code from the VBA editor, nothing happens. The code recorded by the successful use of the dialog box is as follows:

Sub Macro4()
'
' Macro4 Macro
' Macro recorded 11/4/2008 by deranger
'
Selection.Find.ClearFormatting
With Selection.Find.ParagraphFormat
.LeftIndent = InchesToPoints(1)
.RightIndent = InchesToPoints(0)
.SpaceBeforeAuto = False
.SpaceAfterAuto = False
.FirstLineIndent = InchesToPoints(0)
.CharacterUnitLeftIndent = 0
.CharacterUnitRightIndent = 0
.CharacterUnitFirstLineIndent = 0
End With
Selection.Find.ParagraphFormat.Borders.Shadow = False
With Selection.Find
.Text = ""
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
End Sub

Using the VBA editor I tried adding a Selection.Find.Execute statement after the first End With statement. The result is that the modified macro selects the next paragraph after the cursor position... Read more

Read other answers
RELEVANCY SCORE 44.4

I'd like to be able to open a template I configured by clicking a toolbar button. With Word 2011 I have to click the template button, then click My Templates, then select the template I use most often from the others, then click the choose button. So I tried recording a macro and went thru all those steps. But when I run the macro, I get the blank template opened, not my template.I can't "write" in Visual Basic, but here is what was recorded in VBSub NewNotes()
'
' NewNotes Macro
'
'
Documents.Add Template:="Normal.dotm", NewTemplate:=False, DocumentType:=0
End SubI tried editing the code to Add Template:="Notes.dot", which is the name of my template. Then I tried also changing NewTemplate:=True. I get a runtime error 4198 command failed. I don't know what DocumentType:=0 does.Because I'm running Word 2003 in a virtual machine, I use .dot templates in 2011 instead of .dotm and I save my documents in .doc instead of .docx so I can open the docs saved in 2011 in 2003. I tried creating a Notes.dotm template and recording the macro, but when I ran the macro I got the blank template instead of Notes.dotmAnyone know how I can edit the macro to make it open Notes.doc or Notes.docm?

Read other answers
RELEVANCY SCORE 43.6

Hello, I would like to make a macro in excel that I can use for any spreadsheet. We constantly get reports and I would like to make a macro that performs the necessary tasks for each one. However, whenever I make a macro, it seems like it can only be used for that certain report. Is there a way I can make one that I can just use for any spreadsheet? Thanks in advance.
 

A:Solved: Is is possible to make an excel macro to work with all sheets?

Read other 16 answers
RELEVANCY SCORE 43.6

access 97 macro, trying to send oject as RTF to outlook 2000 - will not recognise. it works with access 2000 and outlook 98, and it works with access 97 - outlook 98. Get error -- cannot open mail session. HELP!!!!!
 

A:Access 97: Macro to Outlook 2000 Doesn't Work

Likely, it's because you can't "move upward". Most programs are downward compatible, but not upward. The reason Outlook 98 probably works is because it's really nothing more than an upgrade of Outlook 97. Outlook 2000 came with the Office 2000 suite. If I were you, I'd just open the DB in Access 2000 and convert it, if necessary, and have the macro in there. You should be able to import the new tables quicker than trying to find some other workaround. You can probably just add that to the macro, you know--import tables (linked even) from Access 97 DB, run report, send as rtf to OL2K.

?
 

Read other 3 answers
RELEVANCY SCORE 43.6

Hi All,

on this occasion Google has not provided me with the answers i am looking for.

I have got an excel macro that i have sent out to a number of people, for those who use excel it is fine but i am needing it to work in open office or similar open source free program for the few that dont have access to MS Office.

I know that the coding is different and after the research i have done it seems that there are extentions or converters that make the VBA code work in Open office.

Does anybody know how i can get this to work? I can not find the extentions but am told they exist.

Any help would be really great

Cheers
 

A:Excel Macro needs to work in Open office ir Similar

Google is a wonderfull search tool, have you tried it?
I found the link below that opens a pdf file with the nice sounding name: "Porting Excel/VBA to Calc/StarBasic"
http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf

I think this is what you need.

...but there is more

http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html

Happy coding

BTW this is what the Open Office site claims:

VBA Support

OpenOffice.org can run many VBA macros unmodified due to its built-in; limited VBA support.
Click to expand...
 

Read other 1 answers
RELEVANCY SCORE 43.6

Hey everyone,
So I used this code to copy a range of cells from multiple workbooks and paste it into one workbook. It used to work fine but now it gives me the 400 error. I've been adding files to the directory that it pull the files from and it was working fine, but all of a sudden it's causing this error. Can someone please help me out?

Dim xcell As Range
Dim ycell As Range
Dim sheetname As String
Dim wblist() As String
Dim i As Integer
Dim wbname As String
Dim j As Integer

i = 0
j = 0
FolderName = "C:\Documents and Settings\s.k\Desktop\CRs\LOG"
wbname = Dir(FolderName & "\" & "*.xls")

Application.ScreenUpdating = False

Do While wbname <> ""

i = i + 1
ReDim Preserve wblist(1 To i)
wblist(i) = wbname
wbname = Dir
Set ycell = Range(Cells(i + 3, 2), Cells(i + 2, 28))
Set xcell = Range(Cells(2, 3), Cells(2, 28))
sheetname = "loging form"

ycell.Formula = "=" & "'" & FolderName & "\[" & wblist(i) & "]" _
& sheetname & "'!" & xcell.Address
Loop

Do While j < 100
Cells(j + 3, 1).Select
ActiveCell.FormulaR1C1 = "=LEFT(RC[6],4)"
'ActiveCell.FormulaR1C1 = "=LEFT[RC[6],4]"

Cells(3 + j, 1) = Val(Cells(3 + j, 1))
Cells(3 + j, 2).Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-1],'[CR Status.xlsx]Sheet1'!R3C1:R189C3,3,FALSE)"

If Cells(3 + j, 1).Value = 0 Then
Cel... Read more

A:Excel VBA Macro Problem - Code used to work, now 400 error

Read other 7 answers
RELEVANCY SCORE 39.6

I am using the MSN Stock Quote addin with MS Excel 2003. Prior knowledge of this should not be necessary, but I just thought I'd provide full context to my issue. I wrote a macro that essentially records daily stock prices. Because I don't want to store old quotes into perpetuity, i need to ensure that the update quotes button has been hit. I use sendkey() to accomplish this, and then the macro copies the quotes and pastes them elsewhere. My main goal is to have the task scheduler open this file daily so i dont ever have to think about this again, and i'm so close. Essentially my problem is that it takes a few seconds after the update button is hit for the add-in to fetch the new prices from the internet, and this process appears to be delayed until the macro is finished. This is a problem because the macro ends up recording un-updated quotes. I have tried the Application.Wait procedure, and I've tried time consuming loops, do while loops, etc. All of these approaches result in the same thing: Can someone please help me with this? I'm too lazy to hand update this spreadsheet every trading day for the rest of my life (or until i quit). Thank you in advance!
 

A:Excel Macro - Allow cells to update query before macro completes

Can't you just put the update macro code in a module of it's own and call it from the main macro?

Regards,
Rollin
 

Read other 1 answers
RELEVANCY SCORE 39.2

Hi,
Don't mind the curious ones, but I'm one of them. So anyway, almost one year ago now, the Word macro virus W97M/Marker.C was running rampant around Gordon College, with many teachers and students alike being infected. I was even infected with it thanks to one of my professors posting an assignment description document that had it. I was running AVG 9.0 at the time, and it was flagged many a time over. I think there were like six or so instances. My memory may be flaky, as my laptop has undergone many reformats since then, but what I do remember is trying to ignore AVG's warning, due to the fact that AVG has given me many false positives when I used it. The message Word gave me was that the document couldn't be opened because it wasn't available. But the strange part of that is that AVG had not removed anything from the file. I can think of two reasons why the file wouldn't run with the virus in it. Tell me which, if either, is correct. One is that Microsoft has since changed the macro format from 2003 and earlier versions of Word simply due to the many viruses that once existed for it, or two, that message was a very convoluted way of telling me that Windows 7 no longer supports Virtual device Drivers (*.vxd) as I was able to open the file after it had been cleaned up by Eset NOD32. Any knowledge you folks have would be very interesting, as I have always been curious about the very odd weekend of February 12, 2010. Now don't get me ... Read more

A:random curiosity about MS Word macro viruses and why (thank the Lord), they don't work in Word 2007/2010

I don't know the particulars of the macro virus you mention, but with Microsoft Office 2003, a significant change was implemented that effectively stopped the propagation of macro viruses.

Prior to Office 2003, macros were enabled by default, and opening a document with macros and auto-execute meant the macros were automatically executed (and thus the virus could infect and propagate).

With Office 2003, macro security was introduced. With a Microsoft Office 2003 default install, macros need to be signed with a certificate issued by a trusted root CA. Macros that are not signed will not be executed. Users have to explicitly lower the macro security level for unsigned macros to execute. Almost all macro viruses were unsigned.

Read other 3 answers
RELEVANCY SCORE 39.2

How do you keep a macro running until you reach the end of a page? Currently I just hold down the control or Alt keys. I have long documents so holding down the Alt + whatever key is not always practical.

Here is a sample macro. How do I make the macro run until the macro reaches (in this case) the top of the page?

I think the "do until" feature is used in the code but I do not know the syntax for "do until".

Code:
Sub DelimitBoldSentenceOnRightWithATab()
Selection.Find.ClearFormatting
Selection.Find.Font.Bold = True
With Selection.Find
.Text = "*"
.Replacement.Text = ""
.Forward = False
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = True
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
Selection.TypeText Text:=vbTab & vbTab
Selection.MoveUp Unit:=wdParagraph, Count:=1, Extend:=wdExtend
Selection.MoveLeft Unit:=wdCharacter, Count:=1
Selection.TypeText Text:=vbTab & vbTab
Selection.MoveLeft Unit:=wdCharacter, Count:=3
Selection.Find.ClearFormatting

End Sub

Thank you in advance for your replies.
 

A:Word Macro: How to keep macro running until end of page is reached

You can evaluate the current page number using the following property:

Selection.Information(wdActiveEndPageNumber)

Just use a loop and have it execute while Selection.Information(wdActiveEndPageNumber) = 1

Can you post your sample document?
Regards,
Rollin
 

Read other 2 answers
RELEVANCY SCORE 39.2

Hi Im an amatuer photographer and i'm looking to dupe my heap of old 35mm slides using my canon 180mm 3.5f macro lens... I'm wondering if anyone has tried doing so with a macro lens similar ..
I use a 40d digital canon camera. The shortest focusing distance for the lens is just under half a metre.
I also have a 1.4 extender that gives extra magnification but dont think i would need it.
I imaging the idea is to photograph down a piece of pipe (ie fit it to the lens somehow) and have the 35mm slide illuminated from the rear using some sort of slide holder and external flash behind....
The macro lens will do 1to1 life size is made to shoot a fairly flat field and the camera is capable of automatic exposure and bracketing... does that sound like a lot of rot ? or is it a proposition... I havnt seen a commercially made gadget to use on a dslr for this purpose. I copuld buy a dedicated dupe machine but im wondering if the optics and software are any better than the camera i've got?
Maybe someone is already doing it! I'm just new to this forum so a bit inexperienced in this process.... Regards to all
jim t
 

A:anyone tried duplicating 35mm slide via macro a macro lens

Read other 12 answers
RELEVANCY SCORE 38.4

Hello!

I've been tasked to compile in a sheet the monthly ending balances (from July to Dec) of customer receivables for 493 CUSTOMERS. That's a lot! I already started, but I know continuing until the end is crazy and even impossible. So please help?

Below is a picture of the first sheet containing the ledger data of the 493 customers dated July to December. I just blocked the center and changed the customer names in an attempt to maintain confidentiality.

As an example, for Customer 1, I need the July, Aug, Sept, Oct, Nov, and Dec ending BALANCES (last column) of the receivables.

(I ALSO ATTACHED FILES OF THE FF 2 PHOTOS WHICH I UPLOADED IN FLICKR JUST IN CASE)

For july 31, since the first entry is already 08.15 or August 15, this implies that the July balance must be 0 which I have to input into the July 31 column in the second sheet as shown in the second picture.

For Customer 1 August 31 2012, the closest date to August 31/8.31 entry indicates a balance of 0 so this must be the August 31 balance.

For customer 1 Sept 31 2012 to November 2012, no entries are inputted for these months (9-11) so the August 31 balance mustn't have changed and is the standing balance as of November 31.

For Customer 1 December 31 2012, the outstanding balance is 0.

Oh, as an added note, just in case, debit adds to the balance and credit deducts from it.

I've had to manually mine the ending balances for 90+ customers so far. HUHUHU. I just know macros and YOU wil... Read more

A:Macro Help: Macro for Copying Certain Values Using Certain Criteria

It will be easier if you make sheet1 like a database table.
That is
Column A is all customer name with no blank rows.
Column B is the invoice date
Debit and Credit can be in 2 col or 1 col.

Try not to "beautify" your source data with empty rows and columns, it makes summarisation difficult.

When all is done, you may use sumif to sum all values before a particular date.
 

Read other 1 answers
RELEVANCY SCORE 38.4

I have set up a macro to print multiple reports. Using the following:
OpenReport
PrintOut
OpenReport
PrintOut etc.

I get a Print Macro Definition message between printing each report that I cannot make go away.

Please, make it go away!!!
 

Read other answers
RELEVANCY SCORE 38.4

hello everyone,

i would like to ask for help,

i already made a macro for mac excel 2011, the macro is only move and copy an active worksheet to the last position of sheets.

however, i found something wierd, suddenly there is code inside the new sheet module. the code is

'True
End

this code makes me un able to run macro anymore, but after i remove that code, i can run again the macro.

could any one help me regarding this problem?

Thankss...

the code i was using as follow

sub test123()

activesheet.copy after:= sheets(sheets.count)

End Sub
 

A:un able run macro in 2011 after adding new sheet by macro

Are you sure thes isn't any code in the source sheet?
 

Read other 3 answers
RELEVANCY SCORE 36.4

Hi,
I want to distribute IE8 setup with my product. Do I need to buy any licence for it. It will be used intranet thats why I can't give a link to microsoft site.

Any suggestion.


Thanks
Muthu

A:IE Distribution licence

Hello and welcome to the forum.

Windows has IE built into the OS. Sorry I dont quite see why you need the setup for it?

In the EULA it mentions Unauthorized reproduction or distribution is illegal

Thanks..

Read other 3 answers
RELEVANCY SCORE 36.4

My older (third computer) needs a new operating system, and I don't want to pay . I will be giving this computer to someone who doesn't know much about computers, and the specs are as follows:

Intel Pentium III @ 866MHz
40GB Hard Drive (Not sure of brand nor speed)
128MB SD-Ram
(Model Sony VAIO #PCV-RX360DS)

I want to try to get a distribution of Linux on the computer, and since the computer is not currently running an operating system, and I'm not skilled with Linux (usually in the CPU or Vid Card section of this site so...) I need help. Thank you for any help.
 

A:Which Linux Distribution?

I've always found that the Ubuntu distribution is a good choice for this sort of computer. It's based on Debian . . . very stable and proven.
Try a "Live" copy first if you like.
Nothing is installed to the hard drive . . it runs completely from the DVD ROM.
To date I haven't had a problem getting it to find any hardware on laptops nor set-top boxes.
Good Luck
 

Read other 9 answers
RELEVANCY SCORE 36.4

I have just installed my new Sapphire HD 5770 1 Gig card. Now I am ruining Win7 Pro 32 bit and have 4 Gig on board memory. Now with the new card I would in affect have a total of 5 Gig. So as we know 32 bit only looks at 4 Gig so when playing games how is the memory now distributed or what effect does the additional 1 Gig on the ATI card have?

A:Memory Distribution

32bit is only read max 4GB of the memory. and you have VGA card 1Gb. what game that's u mean??

you can open the task manager when you run a game. and that's will show you how much memory used.

Read other 9 answers
RELEVANCY SCORE 36.4

This is my first post on this site so I hope this is the correct forum for this topic. I'm finally upgrading to a new PC which of course will have Windows 8. I'm coming off of an XP machine and will need to transfer my files and folders. Simple enough, however I've read both here and MS site about the libraries and file system that W8 uses and how they're different than older versions so I'm now a bit confused as to the proper way to distribute my files when I put them on the new machine. For example, in XP I simply had a single folder for each piece of machinery (CNC machine that is) which contained all the documents (.pdf, xls, etc.), pictures, and videos directly pertaining to that individual machine. If I understand the W8 library system correctly, for best results I should now start an individual folder for each machine in each of the Windows libraries. That is, a folder in Documents for machine X, a folder in Pictures for machine X, a folder in Videos for machine X, etc. and then continue the same way for machine Y and so on. Am I correct? I have no problem doing this I'm just looking for best procedures to follow whenever possible and use the OS as designed.
Sorry for the rookie question, but most of my experience using computers, besides the typical "home" use has been with PPCL programming and process control. Any suggestions would be appreciated.

A:Help with file distribution

You can set it up any way you want. There is no requirement to make the changes you mention. If you're comfortable with the structure you have now, stay with it. No need to even use Libraries unless you want to.

My recommendation would be to stay as you are initially, then as you get used to Windows 8, and it will take considerable getting used to, especially coming from XP, start making changes that add to the usability. Just my $.02 worth.

Read other 2 answers
RELEVANCY SCORE 36.4

Can someone give me a few good PDU(power distribution unit) options with around 30A input capacity for 19” rackmount system?

Read other answers
RELEVANCY SCORE 36.4

I am interested in creating a website where people can go and sign up to receive a green newsletter. The only information I need for them to provide is there name, email address and age range. Is there a program that I can purchase and put on Windows XP Professional or Windows 2003 server. I prefer not to use an outside service like constant contacts. I would like the program to automatically save the information after the person enters it so that it does not have to be imputed manually. Any suggestions would be helpful. Thanks.
 

Read other answers
RELEVANCY SCORE 36.4

I am responsible for about 225 Windows XP PCs on a Novell network. If anyone has experience pushing updates or new applications to several hundred PCs, I am looking for the best (easiest) way to do this. I just finished an upgrade that I did using sneaker-net, and it was too much.
 

A:application distribution

LOL, Sneakernet, haven't heard that term in a while....

here's a couple places to start digging,
mostly the type of thing like running them from a network share on some server via batch file or script, plus Microsoft has quite a few options in the remote deployment arena
http://www.microsoft.com/windowsxp/downloads/updates/sp1/hfdeploy.mspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=3E90DC91-AC56-4665-949B-BEDA3080E0F6&displaylang=en

http://thesource.ofallevil.com/technet/prodtechnol/winxppro/deploy/hfdeploy.mspx

It may or may not be exactly what you're looking for, but at least it's a start.
edit: I dunno what's up with the domain on that last link, I didn't even notice it until after I posted it, I'm looking into it, that's just weird.
http://s.microsoft.com/technet/prodtechnol/winxppro/deploy/hfdeploy.mspx
is the acrtual MS link to the same content.......still weird.
 

Read other 1 answers
RELEVANCY SCORE 36.4

My older (third computer) needs a new operating system, and I don't want to pay . I will be giving this computer to someone who doesn't know much about computers, and the specs are as follows:

Intel Pentium III @ 866MHz
40GB Hard Drive (Not sure of brand nor speed)
128MB SD-Ram
(Model Sony VAIO #PCV-RX360DS)

I want to try to get a distribution of Linux on the computer, and since the computer is not currently running an operating system, and I'm not skilled with Linux (usually in the CPU or Vid Card section of this site so...) I need help. Thank you for any help.
 

A:Which Linux Distribution?

I've always found that the Ubuntu distribution is a good choice for this sort of computer. It's based on Debian . . . very stable and proven.
Try a "Live" copy first if you like.
Nothing is installed to the hard drive . . it runs completely from the DVD ROM.
To date I haven't had a problem getting it to find any hardware on laptops nor set-top boxes.
Good Luck
 

Read other 9 answers
RELEVANCY SCORE 36.4

Can someone tell me of a way a person can distribute a file to other people other than e-mail and are not connected to a network. I appreciate any help.
 

A:File distribution

You could try a free filesharing programme
http://www.wfshome.com/

Or a paid for web hosting service - there's lots out there, some with trial periods
http://www.mydocsonline.com/

Instant messaging - they allow you to send a file

Via a website if you have one

If they are photos - there's free pic hosting sites
http://www.photobucket.com/

Or you could mail them a floppy
 

Read other 1 answers
RELEVANCY SCORE 36.4

I have inherited a list of 57 email addresses that I will use frequently over the next months. Is there a way to create a distribution list in Outlook without having to enter each address as a new contact? Can I cut and past the whole list into a distribution list? Currently, I have savied as a word document and just cut and past into bcc field when I have to send, but I'd love to have this in an Outlook list if possible.

Does anyone know the maximum number of email addresses that one can include on a single message in Outlook? I have another list that has 194 names on it. What's the best way to send as a mass email? This is a neighborhood security patrol alert announcement email, not advertising.
 

A:Distribution list

Hi needhelp1950

Your ISP determines how many e-mail addresses you can send at one time. You might try a maximum of 25 addresses to see if that message is allowed through or not.
Otherwise, call your ISP to see what their limitations are.

Copy the e-mail addresses to a spreadsheet and Import them into Outlook.
First, Export your existing Contacts from Outlook as a .csv file to see the template that Outlook uses. Then copy the names into the .csv file and Import it back into Outlook.
Which version of Outlook are you using?
 

Read other 3 answers
RELEVANCY SCORE 36.4

I work at a small private school that occassionally sends school information home to parents. The school has tasked me with researching a way that we, the school, can send emails containing the school information to parents.

Our list of parents who want to receive these emails is about 300 - 350 parent email addresses. Our desire is to develop emails containing important school related info. and email everybody on the list as a BCC. Our desire is to transmit these emails but not allow anybody to "Reply" to the emails.

Does anybody know of an easy way we can email messages in mass?

We are hoping for a simple and economical way to simply send one-way emails to parents.

We do not want to use the current email engine that presently exists within our school system. (The reasons we don't want to use our current email system is a whole other story and is not for this forum.)

I am new to forums and hope I haven't over stated my self. I will appreciate any feedback from anybody.
 

A:Email Distribution

Create a distribution list. I don't understand what you mean when you say you can't use "the current e-mail engine". Are you referring to the client or the server?
 

Read other 1 answers
RELEVANCY SCORE 36

Hi,

There is a manager in my office that randomly looses his distribution list.

When he sends out an email, through Outlook web, using the distribution list, it disappears and there is no way to get it back. It does not go into the deleted folder or anywhere that I have been able to find. It does not seem to happen when he uses Outlook 2003.

This has happened 5 or 6 times now. As far as I know there are no other applications running at the time he sends out the email.

We are set up on an Exchange server.

Has anyone ever heard of this problem before? Any Ideas?
 

Read other answers
RELEVANCY SCORE 36

Is there a way to undelete a distribution list I deleted by accident?

Thank You,
Michael
 

A:Undelete Distribution List

It should still be in your Deleted Items folder within Outlook. If not and you are trying to do it at work then try "Tools">>"Recover Deleted Items" from the menu bar.
 

Read other 1 answers
RELEVANCY SCORE 36

I have a business. I need some software to make my business simpler. But I don't know of such software. This is what my business does:

1. receive files from several customers at my central server
2. distribute those files from server to employees daily (with administrator control over who gets what)
3. employees return processed files to server
4. server sends processed files to the respective customers

how can I automate this process? What software is out there for this problem?
 

Read other answers
RELEVANCY SCORE 36

I just got hired by a company and it is an accounting firm. They currently do not have any way of pushing updates out to there users. They make instruction for them and tell them were the exe is located. We all know how that works, people don't do the updates and then are behind 5 or 6 versions. They use WSUS for windows update. I am not familiar with any software distribution packages that are out there. Can someone help me out.

Thanks
 

A:Software Distribution Program help please

We use Ignite
 

Read other 1 answers
RELEVANCY SCORE 36

Created a new distribution list in Outlook, however would like for the email addresses to stay unknown? Any help??
 

A:undisclosed Distribution Lists

Put it in the bcc instead of To
 

Read other 1 answers
RELEVANCY SCORE 36

Hi folks, I have a few questions about C:\WINDOWS\SoftwareDistribution.old. The folder is 456MB.What is this, and can it be deleted? I think it has something to do with Microsoft updates. I should clarify something: I have TWO Software Distribution folders. A few months ago, after the folks at the HiJackThis forum helped me clear up a malware infection, I started having some problems with some Windows functions. A Microsoft techie solved the problem, but in order to do so he had to create two "Software Distribution" folders. He named the one that already existed "Software Distribution.old" (this is the 456 MB folder), and created a new one: "C:\WINDOWS\SoftwareDistribution".After he created the ".old" folder, the problems I was having cleared up... so his solution seemed to work. So can I now delete the ".old" folder?Thanks a million, D.

A:Software Distribution Folder

Most likely you can delete it without any issues. But I'd recommend moving it to another location for a week or two to see if you need it. Then, if you still don't need it, delete to the Recycle Bin - where it'll remain until it's forced out (thereby providing a measure of extra protection).

Read other 2 answers
RELEVANCY SCORE 36

In outlook 2000

I imported a *.pst file with 4 distribution lists and 50 contacts

When I go to use that distribution list it says there are no recipients in that list to use. However when I open up the contacts folder I can see them.

No I know if you hit "update now" it repairs to the connection or something?!??!

Doing that works, however is this step neccessary. What does update now do?
 

Read other answers
RELEVANCY SCORE 36

I've purchased my copy of the student Windows 7 Professional 64 bit through the Digital River provider. The purchase went through, I got the download link but I did not receive a product key from them. My room mate also purchased the software and got an identical email to one I got except her had a key in it. Does anyone know of a direct way to contact Digital River Customer Support? Sorry if this is in the wrong thread wasn't sure where to put this :/

A:Digital River distribution

Here ya go...Here

Read other 1 answers