Custom Format Code Injected On Document Open
Nov 19, 2012
I am experiencing odd behavior with Excel (v. 14). When a spreadsheet is opened, format setting of almost all cells in the workbook have changed to a custom code that reads "[$-409]0%". AFAIK the first part is not even a valid tag.
Because the underlying data is not changed, I can just select cells and reset formatting to "Number" or "General" and everything's fine. However, I'd like to get to to the root of the problem.
The problem occurs with only some workbooks. I should mention that the workbooks are circulated in different language versions of Excel, which may contribute to the problem.
View 2 Replies
ADVERTISEMENT
Jun 10, 2013
I'm a fan of the Excel 2010 table styles, but can't figure one thing out. When I create a table in excel (Ctrl+T), I like to reformat it with a new defined style. When I save the style, I can use it while I'm in that instance of excel, but when I close and reopen excel, the style is gone. How to save the custom formats to they are always available?
View 3 Replies
View Related
Jan 19, 2009
I'm trying to open a word document from excel using VBA. Here is my code.
View 5 Replies
View Related
Jun 12, 2013
I'm running on Ubuntu 13.04 and have a problem with libreoffice and openoffice alike. With libreoffice the problem occured, then I removed libreoffice and installed openoffice, on which the same problem occured.
Sometimes, when I open a writer document, it doesn't open. When I look into 'system-monitor' I do see the process is started, but it won't open. It doesn't do anything. No error message, nothing!
And when I try to 'end' or 'kill' the process in system monitor, it just doesn't. Then I log out and log in again, and then when I open a document, it brings my to the recovery window.
Then everything is fine, till it happens again. The same problem occurs on another pc with 13.04 also.
Side notes
Memory: 3.9 GiB
Processor: Intel® Pentium(R) CPU G630 @ 2.70GHz × 2
Graphics: Gallium 0.4 on NVA8
OS type: 32-bit
Disk: 487.9 GB
Used pre-installed libreoffice
Installed openoffice from .deb package openoffice.org
View 2 Replies
View Related
Oct 1, 2007
I'm trying to write an Excel VBA macro that opens a .csv file, selects a range of cells, opens a new, blank Word document, and then pastes the cells into the Word document.
I can open .csv file.
I can open MS Word.
I can select and copy the cells in the .csv file.
I cannot figure out how to paste those cells into Word.
View 3 Replies
View Related
Apr 24, 2007
I have created simple buttons on my spreadsheet to do most everything that is needed, except to display a "Help" file. The "Help" file can be a pdf document or any other document format that will work. I don't think I need any user forms or ActiveX controls. But, then again, I am a relative newbie to VB. Is there a simple way to have a button control on an Excel spreadsheet open and display a pdf file or other document? Or is there a better way to do what I'd like?
View 8 Replies
View Related
Oct 22, 2013
I am trying to open an .xls excel file within a non-email lotus notes database with vba code in excel.
View 3 Replies
View Related
Mar 5, 2007
I want to set up a one step button in an Excel workbook to open up a Word Mailmerge Document that I have already set up complete with Excel data source. I have used this code so far but it's not working. What else do I have to do?
Sub OpenWordMailmergeMasterB()
Set appWD = CreateObject("Word.Application")
appWD.Visible = True
appWD.Documents.Open Filename:="X:Detention filesMail MergeLesley's MailmergeMASTER Interim Report.doc"
'To Run the Mail Merge
'Data source is a range name in Excel workbook called "MailmergeReport":.....................
View 4 Replies
View Related
Dec 20, 2007
I am recording a macro to help me with formatting a document. I know do this manually, but realized that if I record a macro and run it the process would be faster. I have tried this and it works really well. However the problem is that although the columns are always the same, the rows increase and decrease everytime I download the raw report.
When I record the macro and then run it, it only selects the number of rows that I choose when I record the macro. I am sure there is a way to have the macro look for date and then stop after there is no more rows, but I can't find it in help.
I have tried selecting the whole document, but that slows the automated formatting down significantly.
View 9 Replies
View Related
Feb 21, 2014
I have a column in excel which gets populated in the format "2/1/1980" when copied from a different source. I want a macro to run on this column and convert this in the below format. Required format: '02-01-80 (note the ' symbol before 02 which will keep it as text)
Existing ----> Required
2/1/1980 --> '02-01-80
2/1/1970 --> '02-01-70
2/1/1983 --> '02-01-83
I need this macro to run on two columns and replace them with the required format. I can do a find and replace either in the sheet or through hard coding the VBA, but as the date format keeps growing, I would need to do this via code and hence requesting the same.
View 4 Replies
View Related
Oct 25, 2012
Is there a way to scan a document into excel 2003 and be able to keep the current format ? or some way to be able to get it into excel and the easliy put it back to the format I need?
View 2 Replies
View Related
Jul 8, 2009
I have my VBA Code set up to open a specific file and copy paste that information into this open spreadsheet in a particular sheet.
The only problem I have is that I don't know how to close the document once its opened.
I know that I can manually close it, but I want my macro to take care of it for me.
If anybody has suggestions, they would be greatly appreciated.
Here is my code so far to help out.
Sheets("Ann Ret Data").Select
Range("A1").Select
Workbooks.Open Filename:="P:InvINVpubAndrew EdgarMarket Value Projectperformance_data.xlsx"
Columns("A:G").Select
Selection.Copy
Windows("Qtr-End Market Value Project2.xlsm").Activate
Range("A1").Select
ActiveSheet.Paste
Also the file I want to close is the Performance_Data.xlsx file.
View 9 Replies
View Related
Jan 27, 2009
I use excel 2002 but some of my office are on 97, i want to add a small workbook open event code which works for me but debugs for the others?? The code is basically, go to a tab, on that tab and that range sort..
View 2 Replies
View Related
Dec 18, 2012
I currently have a code that searches a folder, opens a spreadsheet, and then copies over the "Status" tab to the Master document.
New spreadsheets will be created a couple times a week, so I would like the code to be able to search this folder for the most recently modified document and then open THAT document.
So, if my folder has..
Report 10May11
Report 05May11
Report 17May11
Then, I would want a code to search in this folder for the most recently updated document (in this case "Report 17May11.xlsx) and then go through the step I have above where it copies over the various tab.
Basically, this code would I guess replace the example code I have below.
Sub WorkbookOpen()
....
End Sub
View 8 Replies
View Related
Jun 14, 2007
I have a two documents whose names contain periods out of 70. Example is St._Paul and St._Louis_Park. When I run through the code it stops it with the error that the name cannot be found. My list looks like this..
Club Name
Eagan
Apple_Valley
St._Paul
etc.
When I remove the period it works. Is there a way to make it work with the period in there so I don't have to change a bunch of files and documents? Here is the code...
Sub OpenUp()
Dim wb As Workbook
Dim ws As Worksheet
Set wb = Workbooks(ThisWorkbook.Name)
Set ws = wb.Worksheets(1)
With ws
TotalRow = .Cells(1, 255).End(xlDown).Row
Finalrow = .Cells(TotalRow, 1).End(xlUp).Row
End With
For i = 2 To Finalrow
clb = ws.Cells(i, 2)
psw = ws.Cells(i, 3)
psw2 = ws.Cells(i, 4)
mnth = ws.Cells(i, 5).........................
View 5 Replies
View Related
May 6, 2007
I wish to use the custom option on autofilter several times. The problem is it closes every time I enter a new filter criteria. Is there a way to force it to stay open until I choose to close it? That way I don't have to use the pull down list to choose custom every time.
View 3 Replies
View Related
Mar 17, 2014
I have been automating reports that will be generated in word documents for every company. The baseline is that I have a excel sheet which contain the data inputs and a word template document (template with bookmarks). I have written a macro that generate the reports when the user clicks the button but found that there some reports that generates empty bookmarks since there is no data for the corresponding bookmark. I have uploaded the excel sheets that has the full data and the setup sheets. The setup sheet has the Column Number, Bookmark Name, Description. The data sheet has the data values and the code info sheet has the name of the template doc and the name of the destination folder where the reports will be generated and stored. My requirement is to delete the empty bookmark from the report named "Blackberry". where to write the macro for deleting the empty bookmarks and its sentences (whether its in excel book or word template doc)?
View 3 Replies
View Related
Apr 8, 2009
If possible could someone please tell me why the below code is not calling the normal.doc macro "testy" and any solutions.
The code opens a new document, pastes the text from the clipboard and then fails to run the wanted macro.
View 6 Replies
View Related
Jul 15, 2014
I created a custom tab withthe UI editor into my personal sheet which is set as startup and I want to have this tab automaticly shown when it is opened.
So when the workbook is opened I would like the show the tab Andre rather than the home tab.
View 4 Replies
View Related
Mar 2, 2009
I have a 9 digit number that I want to format as 999.9999.99 Can anyone tall me how? Does anyone know a good link with pointers on custom formats?
View 9 Replies
View Related
Jul 17, 2014
I'm trying to get certain Excel cells (varies by column and row) to populate different areas in a Word document. I've tried using both Word bookmarks and form fields and have defined the Excel names with the Word bookmark names as well as using Word's generic terms (Field1, Field2, etc.) with no luck. The VBA code I'm using now is for word forms and will open the Word document but seems to delete the form fields. I don't know if I'm not coding the cells correctly or what.
Sub CreateProposal()
Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Set wdApp = CreateObject("Word.Application")
' Open word document
[Code] ........
View 3 Replies
View Related
Nov 9, 2009
I currently have this code that allows me to print a word document on one of my drives with the click of a button in excel. I need to modify it because one of the files I want to print as well is a pdf file. how to modify it so I can do that?
Set appWrd = CreateObject("Word.Application")
Set docOpen = appWrd.Documents.Open("F:groupsdeptservCDTISA.doc")
docOpen.PrintOut
docOpen.Close
appWrd.Quit
View 9 Replies
View Related
Oct 5, 2012
I am working on building a custom menu and I am looking for the code that would open a specific workbook execute a macro when I select the tab, can this be done????
View 1 Replies
View Related
Sep 20, 2006
I created a custom toolbar button which works perfectly.
Because I needed to save each workbook as a specific workbook this is taken care of by the vb code.
I would like when the button is pressed for the original workbook template to be opened.
At this moment if I have a blank workbook or no workbook open and I press the button the programme opens a version of the workbook but not the template version how do I point Excel at the templates.
View 3 Replies
View Related
Apr 22, 2009
If I have the following info:
A1 = 5
A2 = -4
A3 = 0
How can I use Format Cells > Custom to have them display as:
A1 = 5 up
A2 = 4 dn
A3 = Level
I've been trying and trying but keep getting a message that I should use one of Excel's pre-defined formats.
View 3 Replies
View Related
Aug 30, 2009
I'm working on a workshet where ppl fill in vehicle numbers, but they all find their own unique ways to fill them up. Some of the examples are below:
MH 04TN 2315
HR 38G 9605
9605G
H9425
TN04A8451
GJ04 GA5142
KA 0072
3,4,7 are incomplete nos. while 1,2,5,6 are all complete nos. I want the format of these above nos. to look like this:
2315TN/MH04
9605G/HR38
9605G
9425H
8451A/TN04
5142GA/GJ04
0072KA
Can this be done automatically in a worksheet using the custom cell format function??.... because then it wud get formatted as necessary whenever someone enters a vehicle no. in that particular column.
View 4 Replies
View Related
Mar 6, 2014
I have a sheet which uses a 'Custom Format' in column A, '00000' to give each row a unique reference. Is there any way to do a 'Find' using this format, e.g. 00012, rather than just 12. Searching using '00012' doesn't find the appropriate cell, whereas using '12' does?
View 4 Replies
View Related
Feb 8, 2013
custom formatting a cell for accommodate a Canadian postal code. The postal code looks like this
v9s 2k5. 7 charactors l#l #l#. I would like to quickly enter the data and have excel capitalize the letters and add the space for me.
View 1 Replies
View Related
Mar 25, 2014
Looking for a custom number format which will show numbers as follows:
0 = -
1234.89 = 1,235
-1234.43 = (1,234)
View 5 Replies
View Related
Nov 22, 2006
How do you make custom date format to a cell in such a way that it appears e.g. "Jan-06"?
I tried custom format "Mmm-yy" but it still resulted to "jan-06".
I want the "J" here to be in the upper case.
View 9 Replies
View Related
