Auto Slate Excel File

I have a program call AutoSlate which tracks car maintenance fuel ect
and for some reason it has  stated putting ####### in the date field
just certain ones not all the date field. If I click on the it will put
the correct date in and when I save it it's fine. Though when I open the
document back open I get the ##### in current date field again. I have
also experience this in Documents to Go if I click on the ###### it will
show in cell information the correct date but will not update it. Here
is what I cut from the cells as you see it give the dates correctly but
if you look at the document you see #########. I have spoke to Auto Slate.

I assume you are talking about using Excel to open the
conduit-generated spreadsheet. I believe your problem is that Excel
is not allocating enough space to print the text in the column. All
you should have to do is select the entire spreadsheet and select
FORMAT->COLUMN->AUTO FIT SELECTION to correct this. I think this is a
problem in your Excel settings, although I am not
sure what the problem is.

Though after everytime I reopen the file in Excel and Documents to Go it 
goes right back with the ########.

Any suggestions.

Thanks
Ron



0
ronb21 (1)
7/3/2004 6:39:28 AM
excel 39879 articles. 2 followers. Follow

1 Replies
319 Views

Similar Articles

[PageSpeed] 55

If the autofitting of columns fixes the problem...

Are you using xl97?

There have been lots of posts complaining that sometimes xl97 won't keep the
columnwidths between closing and reopening.

When you click on Help|about, what version do you see?

If it's not xl97sr2, I'd install it.

the kb article has a link to this:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;151261
OFF97: How to Obtain and Install Office 97 SR-2

Some posters say that works and others post back saying it didn't.

RDBrimmer wrote:
> 
> I have a program call AutoSlate which tracks car maintenance fuel ect
> and for some reason it has  stated putting ####### in the date field
> just certain ones not all the date field. If I click on the it will put
> the correct date in and when I save it it's fine. Though when I open the
> document back open I get the ##### in current date field again. I have
> also experience this in Documents to Go if I click on the ###### it will
> show in cell information the correct date but will not update it. Here
> is what I cut from the cells as you see it give the dates correctly but
> if you look at the document you see #########. I have spoke to Auto Slate.
> 
> I assume you are talking about using Excel to open the
> conduit-generated spreadsheet. I believe your problem is that Excel
> is not allocating enough space to print the text in the column. All
> you should have to do is select the entire spreadsheet and select
> FORMAT->COLUMN->AUTO FIT SELECTION to correct this. I think this is a
> problem in your Excel settings, although I am not
> sure what the problem is.
> 
> Though after everytime I reopen the file in Excel and Documents to Go it
> goes right back with the ########.
> 
> Any suggestions.
> 
> Thanks
> Ron

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
7/3/2004 11:04:21 AM
Reply:

Similar Artilces:

Auto reply to DL ( Bharat ? )
Bharat, How exactly do I save the template on the server properly - I created the rule and have server reply using the message - When I click save and close it saves to to a directory on my computer - I tried save as and saved it on a shared folder on the Exchange Server but that did not work. Please tell me the steps you used to make this work. I am at the end of my rope. Thanks Paul Tested - works. Where did you save your template? Most likely on your workstation. If that's the case, the rule that you created is a client-side rule. That'll only work when you have Outlook runn...

Print an Excel document directly without starting Excel
Hello I like to print an Excel-sheet directly. The sheet is an phone-list, and has to be printed directly, so that bad- schooled users can use that button too. I guess that there are some parameters or so that send a document directly to the default printer. Straingely I can't find them anywhere. Greetings, Pieter Palsma Pieter If you find the file in Windows Explorer, for example, you can right-click on it and print it from there. This opens Excel, loads the workbook, prints it and then closes Excel. Andy "Pieter Palsma" <pieter.palsma@corusgroup.com> wrote in mes...

Embed Excel Spreadsheet in Word ?
I have created a Gantt Chart with Excel. I would like to embed that spreadsheet in Word for a report. I have used "Paste Special" --> "MS Excel Object" However, there is 2 problems 1) Part of the Excel Spreadsheet is not shown in Word (Even though I have chosen A3 as paper size for the Word Document). Is there any way to include the whole spreadsheet ? 2) Is it possible to paste in such a way that the gridlines are shown ? (Like the one that I print with gridline shown) Your advice is sought. Peter It depends on the size of the data that you are pasting. If...

how to properly create new profile to use with existing pst file
OL 2002 SP3 Win XP HE SP1 *Follow-up to: microsoft.public.outlook* hi, it is possible that my current (default) OL profile has become corrupted. i need to create a NEW profile for troubleshooting purposes and see if it resolves current problems. the most important issue is: how do i create this new profile so that it uses my *current* pst file so that i can have a seamless process and continue where i "left off" in terms of all of the items contained in the *current* pst file, emails, appointments, addresses, etc.? do i just create new profile and tell it to "use *curr...

how to store text in a cedit window to file
how do you store the text from a Cedit window, or any CString, to file as text that can be viewable by other applications such as notepad? CString s; c_MyEditControl.GetWindowText(s); CStdioFile f; if(!f.Open(_T("Name.of.your.choice.txt"), CFile::modeCreate | CFile::modeWrite))) return FALSE; // or other appropriate error action f.WriteString(s); f.Close(); return TRUE; // or other appropriate success action joe On Mon, 4 Aug 2008 16:33:30 -0700, "Nick Schultz" <nick.schultz@flir.com> wrote: >how do you store the text from a Cedit window, or any C...

Convert text to number
Hi guys, I receive a workbook that contains unformatted text and need to wor with numbers. I have MS Excel 2000 and can not convert text to number Just do not know how. P.S. Select Range - Format to number does not work. Thanks a lot to everybody who has any advice. Irina -- Irin ----------------------------------------------------------------------- Irina's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=868 View this thread: http://www.excelforum.com/showthread.php?threadid=26345 Hi what type of text does your range contain. Could you post an example? ...

want Know Excel deeply
Hi, I am prince, n i want to know some commend in excel EggHeadCafe - Software Developer Portal of Choice Generic GetXmlReader Data Access Method http://www.eggheadcafe.com/tutorials/aspnet/4b9d6e1c-abe2-4f4d-9abd-b6ebb3575e5e/generic-getxmlreader-data.aspx Here's a few websites that you can work your way through: http://www.cpearson.com/excel/topic.aspx http://www.contextures.com/tiptech.html http://www.datapigtechnologies.com/ExcelMain.htm http://www.xldynamic.com/source/xld.html http://www.mcgimpsey.com/excel/index.html http://www.mvps.org/dmcritchie/excel/excel.htm There are ...

Macros in Excel
I am trying to automate two function for multiple users of a series of microsoft files. While running a macro to create a new file for archiving specific data, I would like the user to be able to assign a filename while running the macro that creates the file. Is this possible? If so, how? Second, for the above mentioned file I would like to create a macro the automatically launches the send to mail recipient function, but allows the user to select the recipients from a corporate mail list while running the macro. Any help would be greatly appreciated! Thanks! Take a look at Appl...

Excel Spreadsheets Reformat Question
I have a disk full of Excel files; I suspect they were created by exporting from an accounting program to Excel to share the financial information with others. Each of these files needs to be PDFd and Bates stamped for production in a legal matter. The problem is this: every single one of these Excel files is not formatted to display all of the information - in order to get a readable page, the columns need to be reformatted to display all of the information contained in each of them, then saved. There are literally hundreds of these files; would there be an easier way of gett...

Excessive Log Files in MDBDATA Folder
New client has: SBS2000 running Exchange 2000 Each day a new .log file is created. The size is 5,120K bytes. They will eventually fill up his hard drive. As I understand it, these are Transaction Log files. Shouldn't they be getting deleted when NTBackup runs? Thanks, Rob "Rob" <spam@spam.spam> wrote: >New client has: > >SBS2000 running Exchange 2000 > >Each day a new .log file is created. The size is 5,120K bytes. They will >eventually fill up his hard drive. > >As I understand it, these are Transaction Log files. Shouldn't they be...

Excel Date
want to be able to have a cell auto fill the first time the sheet i saved so i have the creation date. Then if poss - never let them chang the cell so it keeps record of when the file was first created. Thanks - any help will get some free chocolate! ;-) Arie Astor Chocolate Corp. www.astorchocolate.co -- Message posted from http://www.ExcelForum.com Try some code in the workbook module ; e.g. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Range("Sheet1!A1") = "" Then Range("Sheet1!A1") = Date End If End Sub Then set Sheet1...

Maintaining the size of the excel tables
I have been trying to insert tables from excel into my publisher file. I tried to insert them as an object and they didnt look good. I used pase sepcial and inserted them as enhanced pictures and other time as an excel sheet. However, no matter what I do I cant get these tables to look the same as they are in the excel sheet. They dont maintain the size and neither the look. Either the table looks too loose or the letters and numbers looks bigger than the orginal. Any tips or advices please ? Maybe the solution would be to create a table in Publisher, copy the cells in Excel, p...

After 10.1.5 update, word entoruage ok. Excel and Powerpoint crash
Hello All, Previously running Office v.x 10.1.3 and decided to download and install 10.1.4 and 10.1.5. Things seemed ok but then Excel and PowerPoint will unexpectedly quit after the splash screen and seeing the menu options. Word and Entourage work just fine. I've rebooted and also run First Aid to repair permissions. Still the same. I even reinstalled 10.1.5. Please help! This is driving me crazy! In article <_vubb.122055$mp.62781@rwcrnsc51.ops.asp.att.net>, "Tech Guy" <nospam@nospam.com> wrote: > Hello All, > > Previously running Office v.x 1...

embedded object error (pdf file)
I have two new computers. Dell latitude laptop and dimension desktop. I am converting an excel file to pdf format and trying to insert it as an object in an excel file so people can double click on it and view it. I used to do this with my old laptop (purchased new in 2004 Dell Latitude) It worked fine with that laptop. I am taking an excel file and converting it to pdf format using a program I purchased called personal converter. Then opening the other file and clicking insert, object, create from file (and display as icon). I get the following error on the laptop "cannot insert objec...

# NEW CHALLENGE: HOW TO PRODUCE COMBINATIONS OF DIFFERENT RANDOM NUMBERS AND DO NOT FULLY single repeatable in Excel 2003?
# NEW CHALLENGE: HOW TO PRODUCE combinations of different random numbers AND DO NOT FULLY single repeatable in Excel 2003? Well I found a function that produces random numbers different each other. The only problem is that since they need to apply function repeatedly through a cycle of VBA macro (DO. ... LOOP) it (a function that returns random numbers different from each other) combinations can produce duplicate (eg 1,2,3,4,5) (, (7, 10, 11, 4), [1.2.3.4.5) ...<-- COMBINATION DUPLICATE!) And I would like to know how to do that is avoid this and produze randomly all the different possible ...

How to delete .txt files from \Program+Files\Microsoft+SQL+Server\MSSQL.1\MSSQL\LOG
Hi All, We have SQL 2005 and would like to automate deletion of .txt files from \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder. We have Maintenance plan running which creates .txt files. Any suggestions/ideas? Thanks IA On Aug 12, 10:06=A0am, hayko98 <vardan.hakop...@gmail.com> wrote: > Hi All, > We have SQL 2005 and would like to automate deletion of .txt files > from \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder. We > have Maintenance plan running which =A0creates .txt files. > Any suggestions/ideas? > > Thanks IA ...

Excel Reference?
I get a tooltip telling me that: Name 'EXL' is not declared and EXL has a squiggle line under it. I went to Project > Add Reference > COM > Microsoft 10.0 Object Library and still get that tooltip popping up. Code below: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim WSheet As New Excel.Worksheet() WSheet = EXL.Workbooks.Open("C:\TEST.XLS").Worksheets.Item(1) EXL.Range("A2:E3").Select() Dim CData As Excel.Range CData = EXL.Selection ...

Updating SQL Queries in Excel
Hi, as a newbie I have created queries on several work sheets of a work book. Each one is saved with a different name. This is all working fine. However, when I want to update each query I have to log on individually to each one. I really wanted to log on to the database only once and then have all the queries run and update similtaniously and to avoid have to log on to each one. Can anyone help me with that? You need to create stored procedures. What database is it? HTH Bob "Laura" <lvlandmark@gmail.com> wrote in message news:03c96f3c-8b14-49ef-9ab8-0cf...

QIC Backup File
I just installed Family Tree Maker into my laptop that has Vista. Found a problem when I went to restore from the backup that was created using my desktop which created a .QIC backup file so it's not recognized. What can I do to recover these backups? Thank you for any help you can provide, I don't want to lose all my family history. -- Itsybel The .qic file extension was created by Windows Backup in Windows 98. This is NOT usable from any version of Windows Backup since. See: http://filext.com/file-extension/QIC You will have to find a working computer running...

Slow CRM vs. stage.js file
Hey, as many others i have a slow system, now i maybe have found the solution, i have seen this descriped: In IIS, browse to the file '<crm virtual dir>/_common/scripts/Stage.js', show properties, goto 'HTTP Headers'. Check the 'Enable content expiration' checkbox, and select the 'Expire immediately' option (now this file (5kb) will be retrieved for each request, instead of caching it locally) The thing is, when i browse to the directory, and rightclick "stage.js" choose properties, then i cant see any "http header" ? Is it because ...

Can't seem to read PDF files, keep getting a 1402 error message
Tried loading Adobe reader and keep getting a Error 1402 could not open key message. Here is what the message looks like. HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/WINDOWS/CURRENT VERSION/RUN/OPTIONAL COMPONENTS/MSFS Help! Have you tried completely Uninstalling it and re installing it? Russ -- Russell Grover - SBITS.Biz [SBS-MVP] Microsoft Gold Certified Partner Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Second Opinion $15 - www.PersonalITConsultant.com Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com &q...

Outlook 2003 Auto Capatalize?
For some reason whenever I'm typing an email in outlook 2003, when I wrap a sentance to the next line it will automatically capatalize the first word in the new line and then underlines it showing me its wrong. I've checked my auto format options and they all seem to match the computers that are working properly. Does anyone know how to correct this? Thanks Ken rock_steady111@hotmail.com <rock_steady111@hotmail.com> wrote: > For some reason whenever I'm typing an email in outlook 2003, when I > wrap a sentance to the next line it will automatically capatalize the &...

error code "publisher cannot load files from a different version"
yes a popular error i know. but no i do not have norton basically the computer crashed, i had to reinstall everything, now previously made pub's on office 2k will no longer load on publisher 2k. or on another version of publisher 2k. i looked into the files and they do say publisher 3 embedded in the codes. i am at a loss as to what to do, i have hundreds of files , i havent checked them all of course Do an installer cleanup, Description of the Windows Installer CleanUp Utility http://support.microsoft.com/default.aspx?kbid=290301 -- Mary Sauer MS MVP http://office.microsoft.com/...

howtofix excel 2000 says invalid AddIn for valid excel97 AddIn
how do i repair/fix/load my excel 97 AddIn into excel 2000 e.g. upon load of MYEAD.xlaEx2000 says: c:\Documents and Settings\<user>\.....\AddIn\MYEAD.xla is an invalid AddIn TIA rob ...

Auto Signatures for outgoing e-mail don't appear when sending Acrobat files
I use an auto signature for my outgoing e-mail. If I am on an Acrobat pdf, word doc or excel spreadsheet and click File and then click send to and then click Mail Recipient as Attachment my auto signature does not appear on my e- mail message. Is there a way to have it appear? ...