Search results for query: *

Try Ctrl+` (That is the key above Tab or at the left of 1)

I have set up a switchboard, however whenever some one opens the file, the switchboard prints. How can I stop this?

sorry here is the link http://www.asap-utilities.com/

Why try to re-invent the wheel, down load this add in ( its free)with over 300 tools, one of them is "Delete leading and trailing spaces

Download this utility, its free http://www.asap-utilities.com/ There is a function, Text, remove all leading and trailing spaces, also, remove ending carrage return, and much more

Sub FanOut() Dim ColHead As String Dim ColHeadCell As Range Dim iCol As Integer Dim iRow As Long Dim lRow As Integer Dim NewWB() As Workbook Dim Fsheet As Worksheet Dim Answer As Variant Dim i...

try this site http://www.geocities.com/jonpeltier/Excel/Charts/DummySeries.html#Speedo

Had the same problem with a shared file. I changed the filter options on different columns until I could view the entire sheet. Realized then, some one formatted an entire column (rows 1 to 65536 )in a specific way.

Is it possible to do a mail merge in an Outlok Template? I have the data on a spreadsheet and I need to email the data from the last row of the spreadsheet to a fixed email address.

Ok, I had the same problem, and did a work around. Have the info on a table in MS ACCESS. Paste the Tax forms (PDF) as the background in a report. Import the info from the table ot better still from a Query. Place the data in the corresponding boxes on the PDF. This way you can print an...

Download this tool http://www.asap-utilities.com/ Its frss and got lots of tools, includung what you are looking for

there is an excellent example here http://www.xl-logic.com/

This would import a large tex file into excel Sub LargeFileImport() Dim ResultStr As String Dim FileName As String Dim FileNum As Integer Dim Counter As Double FileName = InputBox("Please enter the Text File's name, e.g. S:\Revenue\Straus\BATCHOCCMUM121002.txt") If FileName = "" Then End...

Try changing the printer from the "PRINT" option

Go to View, then create a SLIDE MASTER, insert this master slide whereever and whenever you want. It will contain the Colour, layout et.

Take this as an example: In the database below, I want to a row to be inserted before every Row where the credit class is "I". Can this be done with the help of a macro? Pls help CR. CLASS A/c No. Amnt Status I 1280021514 2431500 active G 1280035621 3454353 not active G 3580026521 3454387...

I am using MS Access 2000 to produce tax receipts. I pasted a PDF tax Form in the Reports section of Access, with the necessary fields filling the required area on the form. If I print the report it looks good, but if I print to Adobie Distiller ( I need to email the forms) the image of the form...

http://www.baycongroup.com/el0.htm

I have few Inland Revenue PDF forms and I want to automate process of filling them. I know that I can put txtBoxes on them and feed them from txt files (as well as from any other data storage probably) but never done this before and need some help. I know I could recreate them as Access...

P.S. No praises to me it was done by somebody else.