Office suite Q&A
This is page 2 of the discussion. Read the opening post
Desktop
This is page 2 of the discussion. Read the opening post
by nancyt
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
by jimmyjam
by wolfie x
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 waresfamily
by discussion
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
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 lame duck
by dewdrop
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
by dmhanna
by jeffdammit
by tj23
by money
by asilva
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 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 janfromct
by brian158
by brian158
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
by neil.mclean
You will find all the info you need here:- http://www.microsoft.com/learning/mcp/officespecialist/default.asp
Buy the Microsoft "Step by Step" guides some are aime specifically at the exams and Outlook is harder than the rest as you don't tend to use all the facilities that are tested.
This discussion is closed to new replies.
Sort by Trending