Jul 19

So, I am doing a project for my BCIS class, and the school computers use Powerpoint 2007. If I take it home to work on it and save it in Powerpoint 97-2003 format, will 2003 be able to display that template? Also, I downloaded some templates from Microsoft Online onto my 2003 version, would 2007 recognize it and display it properly?

The rule: later PowerPoint versions can open earlier ones. The template you saved in Powerpoint 97-2003 can be recognized by 2007 version.
But if you are to open a 2007 ppt template in a 2003 version, you should save the 2007 to 97-2003, and the new features in 2007 will get lost.

Jun 23

I need to make a project estimate template thingy for my dad’s small business. I can’t seem to figure out which program to use and how to make it the way I want.

I need it to have lines (fill in the blank) and columns but only where I want them, not everywhere.

here is what I can do using a combination of Word Perfect and ms paint
http://yfrog.com/c9projectinfoexamplep

I need a way to make this a form that my dad can fill out on the computer, right now all we know how to do is print it out and write in the info by hand.
I know that I can fill out the one I made on the pc but I need one that my dad can easily fill in the blanks on the computer. The one I made is not easy to fill out without messing up the way it looks.
I need a generic one that my dad can use over and over.
We have these programs on our computers at home:
Word Perfect
Word Pad
Note Pad
Microsoft Works

I have tried Microsoft Works Spreadsheet, but I can’t get the rows and columns to only be where I want them.

are there any free downloads on the internet for programs that can do this?

Surely using Mail Merge will be sufficient for entering data into the same position over and over?

If that doesn’t help you, I apologize I don’t really understand what you are asking for…

Jun 20

I am in a Journalism class in school and I have been assigned, as my final grade for the course, a project that includes making a newspaper with 2 major articles (300-500 words) and 6 minor articles (50-150 words). I would like to make this newspaper look as realistic and professional as possible so if anyone could give me a web site with FREE Microsoft Word 2007 templates that would be great. I also need to add pictures and ads. It must have a news, features, and a sports section. The articles must be in columns. Anything else are not required but could help my grade. Thanks!

You will, to get the best effect use Microsoft Publisher they have loads of templates, but seriously I suggest trying to do it on a mac :)

Jun 17

I downloaded a template for a project from my teacher, but it’s a 2002 doc word file and I have Office 2007 and Windows 7. When I open the file I cannot edit it at all when it’s in compatibility mode, nor save it in a different format. The only thing it’s letting me do is print. Some quick advice is nice, since I waited till now to do my project, hehe.
I actually tried installing the compatibility pack, but it says It’s already installed on my computer. :(

That doesn’t sound like a Compatibility Pack problem. It sounds like a free trial copy of Microsoft Office that was good for 25 uses (of all Office programs combined) or 60 days. At the end of that time it stops letting you edit your files or create new ones. You have to purchase Microsoft Office 2007, or at least Word 2007, to do that.

Note: The 25-character product key on the computer case or laptop bottom is NOT the key for MS Office. Its only for the Windows operating system.

Here are some of your options for paying less than full price for Microsoft Office 2007:

First, if you’re a student, you may qualify for the Ultimate Steal edition of Office at a pretty good price ($59.95):

http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx

Second, if youre interested in buying just Word, check out this URL, especially the second group of listings.

http://office.microsoft.com/en-us/products/FX101754511033.aspx

Note that the higher of the two prices quoted is for a full version of that program and the lower, for upgrades from existing software. Read the list of upgrade-qualifying software carefully: MS Works is often one, and may have come on your machine.

Finally, if you’re willing to spend a little to save a little, Microsoft Works is available in stores for about $40.00. You could buy a copy, install it, then buy Office at the upgrade level. I think you’d come out ahead. Note that the upgrade copy probably checks your machine for Works’ presence, so don’t get rid of it after you’ve installed Office. You never know when you’re going to have to reinstall Office.

Also, if you have files that are locked up in the new Word 2007 file format (.docx), heres a possibility for salvaging them. Microsoft offers a free Compatibility pack that allows earlier versions of Word (and Microsoft Works) to read and write Word 2007 files. If you have access to an earlier version, this can at least give you back your documents. Some new features of Word 2007 will be lost or converted to straight text in the conversion to the earlier version.

Good luck.

May 2

I’m making a web page in Web Developer for a class project and have run into a snag. The problem is this is an online class and it’s hard to get a response from this teacher. I am creating an RSS feed page and am using a tree view to list different servers to pull feeds from. I can not figure out how to change the header template when the feed changes. I’m using C# for the code to operate the functionality of the page. I simply want to substitute the current header template with the text value of the tree node that the user selects.
I’m not sure how to do that, I’m just learning this stuff. I have another issue now though that I’m more concerned about. I need to be able to change the format that I’m displaying the feed results in with the click of a button. Right now I’m displaying it as:

Title
pubDate
Description
Link

I’m wanting to be able to change the layout to simply:

Title
Link

Unfortnately the teacher has not covered how to do this in any of the material he gave us, but expects us to do it. He is very bad about this and I am getting very frustrated.

i think you should check the IIS configuration before launch the project.

Apr 30

I’m trying to print a "magazine" through publisher. I’m trying to put a different template on each page (there are 20 pages) but once i have the first one down – I try to change the 2nd page’s template and it changes the first one again and leaves the 2nd page blank :/

Please help – project due tomorrow!!

This is probably too late to help.

Open a new instance of Publisher, apply a template, copy/paste the template to your primary publication. Go back to the first publication, apply a new template, copy/paste to your primary document. You’ll have to do this several times if you want each page different.

Apr 28

Im working on a school english project
and we have to create a cd cover, back songs and a inside part that would hold lyrics.
i know how to print it double sided but
i dont know how to put it so that it will fold right…
does anyone have like a template for it?
cause i dont know.
and how do you everything into like where its split down the page so it is on one side then cont. on the other side?

Open a new document and set the page layout to Landscape – (File – Page SetUp – Landscape). Turn on your Drawing toolbar – (View – Toolbars – Drawing). Click on the Text Box tool on the Drawing toolbar and draw a Textbox to fill half the page on the left side (leave room for margins). Hold the Ctrl. button on the keyboard and click (on the edge) and drag a copy of the Textbox to the right side of the page. The left side represents the back of the CD cover and the right side the front. When you have the details entered, if you prefer, you can Format the Textboxes to have ‘No Fill’ and ‘No Line’ so that the outline will not be visible,- (Format – TextBox – Fill Color and Line Color).
For the inside, draw two more Text Boxes in the same way on a new page. Link the two boxes so that the lyrics will flow into the second box when the first box is full. Do this by right-clicking on the edge of the left Textbox and choose ‘Create Text Box link’. Now type the lyrics. Again you can Format the Text Boxes not to show any lines. Print out the first page and put it back into your printer so that you can print the second page on the reverse side.

Apr 26

We have to do a massive mailing to hundreds of clients. We usually print the client’s name & address on label stickers but I want to figure out if I can feed the envelopes through the printer instead of using label stickers. I have the mailing list in excel: one column has fist name, one last name, one with address #1, one with address #2, etc. The size of the envelope is a basic 9.5" X 4.5" inches.

I don’t know if I have to use some form of mail merge onto Word or Excel has a print envelope option. I saw the option under Tools, Letters>Letters/Mailings>Envelopes and Labels, however, I know how to use that option when drafting a letter. In this project, I do not have a formal letter that is included in this envelope (so this is not an option). Is there a Microsoft template I have to use?

It’s pretty much the same process as the one for stickers.

Start a Word document, select Tools> Mail Merge Wizard

Full insructions here:

http://www.port-huron.k12.mi.us/tech/Handouts/How-To/mailmergeenvelopes.htm

I’d suggest copying the first line of your address data into another Excel worksheet to do a test run. It might require a little experimentation to get the address to print in a good position on your envelope. You might need to work out which side up or which way round to feed envelopes into your printer.

Apr 24

If you’re reading this, thank you! Hopefully you know a little more about Excel than I do…

To give you a little background, I’ve downloaded a Microsoft template in order to create a calendar in Excel. Each month is it’s own tab and in each tab, the days of the month are are set up in cells B4-H8.

I also have a separate spreadsheet containing the events with dates (we’ll call this the list). What I’m hoping to do is to modify a code/module I’ve found (below) that will take the list and input each event into it’s respective date on the calendar.

The code below appears to be setup for a calendar that lives on one tab, as opposed to twelve. Can anyone assist me in modifying it to work with the calendar I have, or create a new code that will work?

Thanks so much!!
……………………………………………………………………………………………………….

In the "list", if column A contains the dates and column B contains the job name…
In cell C1 enter:
=IF(A1="","",DAY(A1))
In cell D1 enter:
=IF(A1="","",sheetname(A1))
Copy cells D1 and E1 down as far as the list could ever go

Right click a worksheet tab and select View Code to open the VBAProject window.

Note the members of VBAProject and then select Insert > Module to add a new module to the project

In the new module add the following code

Public Function SheetName(MonYear As Date) As String
SheetName = UCase$(Format$(MonYear, "mmm yyyy"))
End Function

Sub LoadList()
Dim oRow, oSheet, oCell As Object, iRow As Long
For Each oSheet In ThisWorkbook.Sheets
If oSheet.Name <> "List" Then
oSheet.Range("A5:G9").Clear
oSheet.Range("A11:G15").Clear
oSheet.Range("A17:G21").Clear
oSheet.Range("A23:G27").Clear
oSheet.Range("A29:G33").Clear
oSheet.Range("A35:G39").Clear
End If
Next
For Each oRow In Sheets("List").Rows: DoEvents
If oRow.Cells(1) = "" Then Exit For
Sheets(oRow.Cells(5).Text).Activate
For Each oCell In Range("A4:G40").Cells: DoEvents
If oCell = oRow.Cells(4) Then
For iRow = 1 To 5
If Cells(oCell.Row + iRow, oCell.Column) = "" Then
Cells(oCell.Row + iRow, oCell.Column) = _
oRow.Cells(3).Text + " " + oRow.Cells(2).Text
Exit For
End If
Next
Exit For
End If
Next
Next
End Sub

Back in the workbook select Tools > Macro > Macros > Options and assign the letter L (upper case l) to the macro LoadList.

Now each time you press Ctrl-Shift-l the list will reload.

The code you gave assumes the calendar days are in A4:G4 and then rows 5 to 9 will get your events (up to 5 events per day) and the A10:G10 have more days and then rows 11 to 15 are empty etc,

So your calendar days on each monthly sheet are in
A4:G4
A10:G10
A16:G16
A22:G22
A28:G28
A34:G34

Each monthly calendar sheet is named JAN 2009, FEB 2009 etc…

The code below will read each event from the "List" sheet and put them under the proper day in the proper monthly calendar sheet.

You don’t have to use the formulas in columns C and D on the List sheet. The macro figures out the day and month from the dates in column A.

Sub LoadList()
Dim rListDate As Range, ws As Worksheet, rCell As Range
Dim iRow As Long, sht As String

For Each ws In ThisWorkbook.Sheets
If ws.Name <> "List" Then
ws.Range("A5:G9").Clear
ws.Range("A11:G15").ClearContents
ws.Range("A17:G21").ClearContents
ws.Range("A23:G27").ClearContents
ws.Range("A29:G33").ClearContents
ws.Range("A35:G39").ClearContents
End If
Next ws

For Each rListDate In Sheets("List").Range("A1", Sheets("List").[A1].End(xlDown))
If IsDate(rListDate) Then
sht = UCase(Format(rListDate, "mmm yyyy"))
‘ Check if calendar sheet exists for the event date
On Error Resume Next
If Sheets(sht).Name = "" Then
On Error GoTo 0
Sheets("List").Select
rListDate.Select
MsgBox "There is no calendar sheet for " & rListDate
Else
With Sheets(sht)
For Each rCell In Union(.[A4:G4], .[A10:G10], .[A16:G16], .[A22:G22], .[A28:G28], .[A34:G34])
If rCell = Day(rListDate) Then
If Not IsEmpty(rCell.Offset(5, 0)) Then
Sheets(sht).Select
rCell.Select
MsgBox sht & vbCr & "Day " & Day(rListDate) & " is full."
Else
For iRow = 1 To 5
If IsEmpty(rCell.Offset(iRow, 0)) Then
rCell.Offset(iRow, 0) = Day(rListDate) & " " & rListDate.Offset(0, 1).Text
Exit For
End If: Next iRow: End If: End If: Next rCell: End With: End If: End If: Next rListDate
End Sub

Apr 22

for a school project, we have to creat a short film, and so i downloaded the MICROSOFT STORYBOARD TEMPLATE. and it has a box for the ‘balance’ and the ‘imbalance’. what should i write in the boxes? i can fill out the protagonsit, and solutions and theings, but what are the blance and imbalance??

I’m not certain I’m on the right track but here is an example:
In a movie about good and evil (plot or characters) the good is the balance and the imbalance would be evil.
A comedy may be imbalanced by serious scenes.

One thing is balanced by the other.

« Previous Entries