Discussion Locked

Office suite Q&A

0 helpful
135 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This is page 2 of the discussion. Read the opening post

135 replies

by nancyt

At my last job, we used to have a similar problem. Turns out, it was an "issue" between GroupWise (a Novell product) and Office. It involved the order in which Office, GroupWise, Windows, and the Novell network pieces were installed.

by popsprice

You must use the section break function to switch back and forth between portrait and landscape mode. Insert break > section break > next page then in the new section change your page layout, use print preview to verify it works correctly and then print.
Pops

by merrickps

Just wanted to let you know how enlightening and valuable I have found your Office Suite tips. I always find something that proves useful in the work that I do. Thanks again!

by jimmyjam

My database in Access has a field for "Age" and "Date of Birth." What is the formula to get the computer to compute "Age" so I don't have to use the calculator? I want the "Age" field to update as birthdates occur.

by larry3500

Try the following steps (rather than a Macro):

* Highlight the column containing the data (where the zeroes are). It is more complex if you are dealing with multiple columns and you want to delete based on zeroes in multiple columns; let's assume you just mean Zero in a particular column (you can always repeat the procedure for other columns).

* Click Data, Filter, AutoFilter.

* Click on the new Down Arrow at the top of the column.

* Select 0 from the choices. Now, only the rows with a value of 0 will be displayed.

* Select all of the displayed rows.

* Click Edit, Delete Row.

* Turn off Auto Filter.

That really wasn't too tough.

by discussion

Many of the Office suite TechMail tips (including most of the tips from the 6/5 edition) apply to all Office versions. When in doubt, give the tip a try!

by firstpeter

This macro should handle it:

Sub Remove_Zeroes()
' Define the counter.
Dim i As Long

' This constant is the first row of the table you want it to search.
Const START_ROW = 1

' Lets us define where it should start looking for the table toremove zeroes from
i = START_ROW

' This assumes column A is the "trigger" column - that if it finds a blank row it
' signals the end of the table.
' It also assumes the "zero" column is B - if it finds a zero there it removes the entire line.' Change these as necessary.

Do While Range("A" & i).Value <> ""
If Range("B" & i).Value = 0 Then
Rows(i).Delete
i = i - 1
End If

i = i + 1
Loop

End Sub

by queryeverything

You don't say what type of server you are using ... or what the actual problem is you are seeing. However, we use a Novell Server and that had multiple problems with the MSOffice Apps; couldn't open very large files, took ages (10 mins) to open some files, did not save recovery information etc.

The latest update to the Novell Client (SP2 to Client 4.83 on Win2K) seems to have fixed all our ills.

by jredmon

Maybe I am wrong but 8.3 filename limits are not a issue with windows 2000. I don't get the concern about the filename.

However, your thought about excel creating a copy of a file when you open it is true. The file is created in your temp path. Check you temp path in the environment variables and see where your temp path is set, then open the folder and then open an excel file and refresh the temp location and you will see a temp file appear. Mine are in the 8.3 filename format and the first letter in the filename is a tilde. ("~er34d.tmp"). Since you cannot open the excel file, check the ntfs permissions on the temp location and make sure users have all but full access on that folder. Most likely SP3 changed permissions or changed thetemp location. Try this suggestion and see how far you get with it.

Good luck.

by pptmagic

This isn't a bug. PowerPoint uses placeholders for "standard" text and objects and to facilitate uniformity throughout a presentation. The content of these placeholders is the only thing that will show up in the outline view. To learn more aboutPowerPoint Masters and Placeholders, check the on-line help file. If you use PowerPoint, it'll be worth your while to learn about them.

Ms G

by lfj

I'm not sure if you're aware, but to use this feature correctly you must set it up in your web browser. Not so in XP but for previous versions of Windows using IE as the web browser do the following.

Close Office programs
Open Internet Explorer
Select Tools
Internet Options
Go to the programs tab - select Outlook (if that's what you use) and set (put a check in the box) IE to check to see if it's the default brouser,

Click apply, ok,
then close IE,
reopen it so that the settings take effect.

Then open Word (or whatever other Office program you are running) and then type in the new document the word "test"

Go to File
send to
mail rec.

Your outlook new message window should pop up with the new attachment already in it.

Just fill in the receipants name & addy and click send - this should fix your prob.

by jsarinana

Is there a size limitation on how large your Excel 2000 can get ? if so what is it ?

Thanks

by dewdrop

I would like to use DEC2HEX and HEX2DEC formulas, like the ones available in Excell in Access2K. My attempts have been unsuccessful. Any suggestions?

by dbrodt

Try these functions:

Function Dec2Hex(ByVal x As Double) As String
'
' Converts Decimal value to Hexidecimal string equivalent
'
Dim Result As String, i As Integer, Temp As Integer

Result = Hex(Int(x)) & "."
x = x - Int(x)
For i = 1 To 16
x = x * 16
Result = Result & Hex(x)
x = x - Int(x)
Next i
Dec2Hex = Result
End Function

Function Hex2Dec(strValue As String) As Long
On Error GoTo CnvrtErr
'
' Converts a string of hexadecimal digits into a decimal number.
' Valid input range '0' to '7FFFFFFF'
'
' Check to see if string already begins with &H.
If left(strValue, 2) <> "&H" Then strValue = "&h" & strValue

' Check to see if string contains Decimals and strip them out.
If InStr(1, strValue, ".") Then strValue = left(strValue, (InStr(1, strValue, ".") - 1))

Hex2Dec = CLng(strValue)
Exit Function

CnvrtErr:
Hex2Dec = 0

End Function

by oz_media

Why would I NEED to BUY MS Office?

Why would I WANT to buy MS Office?

Why am I SUPPOSED to buy MS Office?

Why does Microsoft MAKE MS Office? They make games don't they? or is it Operasting systems that don't actually operate? No, on second thought, they make joysticks, or is it... ?????

Is there a Microsoft car yet?

by norm_rr

'Microsoft, help me change the things I can and not worry about the things I can't and grant me the knowledge to know the difference ...' ;-)

by dmhanna

I have been using Office 2003 since it was released. The biggest change I see is in Outlook. As usual, some of the new features are good(the automatic filtering of spam is great)and other features should have been left alone. I am in a unique situation in that I teach the Office package so I am running (and learning the new features of 2003) in my office but using XP in the lab with the students. I have not found any problems at this time with files going between both versions. We will be converting all our staff and the labs over to 2003 within the next month. As a whole, I like the new features. By the way, Fronpage has a separate install and a whole new look as well (I think they are trying to imitate Dreamweaver.)

by jeffdammit

We have a client that was able to export data from their customer database into a csv format. The problem is that all of the names are all capital letters. The client wants to know if he can format the names in a spreasheet to show the first letter as capital and the rest as lower case? There are way too many names to do this manually. Is there a formatting or formula solution that can achieve this relatively easily. Thanks.

by david.hanshumaker

Copy the cells containing the names into a table in Word, then use the format | change case command in Word to change the case to title case. Then copy the Word table right back into the same location in the Excel spreadsheet.

by money

I need info on how to auto insert picture in form by user selecting from either scanner, camera, or file. Using VB6 Enterprise. Thanks

by asilva

We are running Word 2003 on PCs, File Servers are Novell Netware 6.0 and 4.11. Jpeg's with word document files show as a big red x or appear to be corrupted. Any thoughts on this?

by dblayney

My first guess is that it nothing to do with the environment but that the Jpegs are linked to the Word documents and have been deleted, moved or renamed since the links were made. Alternatively, the Word document has been moved and relative links no longer work.

If this is the problem, I hope you know where the files have been moved to or from, orginal names and so on. To find the original paths for linked pictures requires VBasic (ActiveDocument.InlineShapes(x).LinkFormat.SourceFullName or equivalent will get you there)

by steve_whitaker

I need to convert an adobe Acrobat file to MS WORD as a file that can be altered. Any suggestions? All our IT people are stumped.

by tchapaiev

One solution is SCANSOFT CONVERTER (PDF >Word ONLY!)
The other one is to use Ghostscript : not a funny interface but a absolute miracle .You may get the last one for free.(Needs both ; ghostscript and ghostview)

by kathleen.veach

I am creating a form for a document that we use frequently. In the document, an Acronym is used in several places. Is there a way to enter the Acronym only 1 time and have it automatically copy to the other locations in the form where it is required? Thanks!

by janfromct

Is it possible the reader is not using Word, but WordPerfect instead? I have to jump through some hoops to read WordPerfect files in Word. Maybe it's just as difficult going the other way.

by brian158

I switch everyone in my company over to it and it made a lot of things easier. I now swear by it. This is one of the things that M$ came out with that is worth the upgrade to. The features and other options is very nice. The owner ( lets say did not like computers at all ) loves to get on the computer now and work with Office items. The VP here loves it also. We are running on a SMB 2003 server and the sharepoint services and office 2003 makes his job and my job a whole lot easier. I would say it is worth the money to do the upgrade.

by brian158

Front page and One Note is a very nice feature. The only thing I do not like about one note is they do not have this feature for PDAs. Then the One Note Application would be and might go behind other applications. But again if M$ does make it available for PDAs then they will be cornering the market (from what some people say). When I say PDA I am talking about palmpilots. Not the PocketPC with M$ OS on it.

by olddognonewtrix

Hello,
I've also used the methods described to pass a parameter to a query from an unbound form - This method also works running a report from an unbound form that requires dates etc, and having these entered dates print in the header of the report (quite useful). However, the only little thing I don't like about that is the unbound form apparently has to stay open behind the report for the correct data to actually print on the report. The dates show on the report in preview, but won't print iff the user closed the entry unbound form just before printing. This isn't a big deal, but just thought it was worth noting.
I'm still barely between an Access beginner & intermediate myself...

by neil.mclean

If youre using Outlook 2003 you will have this problem as it initially couldn't handle them however if you add a Service Pack 1 to the Outlook it should work. In the meantime use Insert File (Attach) from Outlook

This discussion is closed to new replies.