I received an email with a WORDPERFECT attachment. I couldn't open so I downloaded application (COREL)from Internet. I finally got to read my WORDPERFECT file but found out that COREL had changed all my EXCEL files to WORDPERFECT. How do I change them back to EXCEL flies?
View 4 Repliesprovide some code which lists all today changed Excel files on the C drive and hyperlink them.
View 3 Replies View RelatedI currently have a spreadsheet with the following. I would like to convert the GL Date to just pick up the month. I have tried =mid(cell,4,2) but because this is a excel date it will not pick up 01 as the excel number for this date is 410001
GL DateMonth
01/01/2014
01/01/2014
01/01/2014
01/01/2014
01/01/2014
01/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
In the spreadsheet attached, i have a formula now() which will update the current time in column B if i select opted from column A and similarly in column D the current time will get updated when i select option in column C.
However when i first select the option in column B the current time gets updated but after a while if i select the option in column C the time in the column B is also getting changed.
May be there is a different formula, Not sure what is the trick ?
Time sheet.xlsx
I have an the excel book with sheets that are password protected so that the users cannot delete rows or columns.
In each sheet I gave permissions for certain ranges that need to be filled out only to specific users that need to fill out those cells.
The users are located and managed in the Active Directory.
The point is that each user can only update his/her sheet within the Excel book.
It was working for a day or two and then all of a sudden without any changes all the permissions were gone and every user was able to edit every sheet.
This is the user form:
Dibujo.JPG
All the labels and cells in the original file are in dollars.
When I send it to some computers it changes to euros, like so:
Dibujo 2.JPG
I created the file in Excel 2003, and it changes to euros in both Excel 2003 and 2007.
Step by step process to format back to dollars?
When I combine 3 reports (which we get out of a system) into 1 big file, the date format remains the same (mm/dd/yyyy and right alligned). Same happens for most of my colleagues.
When 1 particular colleague goes and combine these reports, I've noticed that some of the dates are showing as text? (dd/mm/yyyy and left alligned).
I am trying to set up an holiday card on excel which I have the template for but I need an email sent to me, the manager, each time it is updated by my staff requesting Annual Leave. Each member of staff will have a program each.
View 1 Replies View RelatedI have a lot of formulas that I don't want to be changed or deleted, but I still want the user to be able to enter data into the cells.
If I use "Protect sheet" I can't select a cell or enter something into it. I sure there is some setting I have to change, but I'm not sure what to select.
I'm using excel 2007
Iv changed the security settings to my name (along with admin) and removed 'everyone'.now when i go into my folder, everyone else's excel sheet is there but mine has gone.
is there a way i can get it back?
We have 3 PCs, all running MS Office 2013. On 1 of these machines, it is doing strange things with formatting. If you open a document or try to paste anything into certain documents, it decides everything is currency format and assigns all sorts of wrong formatting to the entire sheet, or the entire document. There may be some cells in the doc that are indeed currency, but only a small proprtion. If I open a new, fresh document and paste into that document, it does not do this, it seems to work normally, only applying currency formatting where it might be applicable. On some larger docs that have this issue, no matter what I do, it just continues to apply these strange settings.
View 2 Replies View RelatedI is it possible to convert all comma separated text files in a single folder in to excel files. But the requirement is to have 2 sheets in each new file. first to be the full file - with all columns, and in the second sheet to keep only colum A B D G H K L M O P R S T V W from the first sheet. The second sheet name must be the same as the first one but without the first "wlist_" in the name.
One more thing. The third column in the second is called "COUL". there are short letters for colors in french
can they be converted with the sort in English like it goes:
NO = B
BA = W
RG = R
SO = P
JA = Y
BE = L
VE = GY
GR = G
VI = V
MA = BR
BJ = TA
OR = O
Here is a link to the both CSV and an example excel file with the end result. In this example i haven`t change the shorts for the colors. It takes me too much time with the find and replace function. And at the moment i`m really pushed from time.
[URL]
I have some daily text files in a folder (so about 30 of them each month), which in the end of month, I need to open them up in excel, format them so that I can use the information for my analysis.
I would like to create a macro, to quickly open them all up at once and save them each individually in .xls or .xlsm format.
I am new to VBA and after some research online, I was able to have the files open with the following code. but now I don't know how to proceed further to save them one by one with the same name but in .xls or .xlsm format.
Sub Opentxtfiles()
Dim MyFolder As String
Dim myfile As String
[Code].....
I receive excel reports every day. But the last couple of days when downloading the reports I get them as csv. Also older reports I have saved on the hard disk open as csv.
Well, the ones I have saved have are now csv files and I haven't done anything (knowingly) to change them to csv.
I use Excel 2007 which is creating a whole load of tmp files of the spreadsheet that I work on.
Is there a way tostop Excel from creating and saving the tmp files?
I Use the Quickbook 2009 for accounting. I need to convert CSV files over to QBO files. Any Software are not to Convert CSV files to QBO files.
It's Possible to Convert the CSV files to QBO Files via Excel.
I have two separate excel worksheets from which i want to merge two columns from each worksheet into a new sheet. from the first sheet column A & E and from second worksheet column B & D. The values of second worksheets need to start where the value of first sheet ends. Want a macro to run this automatically every time.
Have tried to merge and consolidate but macro does not work.
I want to send via FTP to a linux server the following.
1- All files that are named checked.XXX.YY.mtc to path /var/docs
2- All files where the name begins with checked.conf to path /etc
PD: I have the IP address, user and password of the server.
I have a spreadsheet with sales information contained in Sheet1. There are a number of columns including the Region column. I would like a bit of code that exports sales information to a number of Excel files dependent upon the region column. In other words the Region column can contain either North, East, South or West. I would like a different Excel file per region and I'd also like the file names to contain the name of the region + the month and year of the previous month ie if i was exporting today then the North Excel file would be called: "North Sales - Jan 2013".
View 9 Replies View RelatedI have a number of files organised in a number of folders on Dropbox. I create a macro to enable me to be able to navigate to a particular folder and then get a list of all the files in that folder to be placed within certain cells on the spreadsheet I'm working with in Excel.
View 2 Replies View RelatedWhen I open more than one Excel file, it used to display them as separate icons on my task bar. But for some reason, now I only get one one icon, and I have to go to Windows on the Menu Bar to switch between them. I can't use Alt/Tab anymore. It only affects Excel.
View 4 Replies View RelatedWe use wk3 files a lot at work, but since switching to Excel 2010 I can't seem to read them anymore. Used to work fine with 2003.
View 1 Replies View RelatedI am trying to do a comparison of numbers from two excel files (one with data from Google Analytics and one with data from Ad-words).
I would like to compare data in the two files, and when there is a match (of keywords), the data from google analytics excel file should be copied into the correct row in the spreadsheet with data from google ad-words.
Does it make sense? and is it possible?
I have Mac 2008 Excel. For my work, I download .asp files and open them in Excel. No problem. The problem is... I'm wanting to use another computer at work that has Mac 2011. When I open the exact same .asp files, they show coding (html?). I can fix this by changing the name of the file extension from ".asp" to ".xls." But I convert these files a lot during the day and this is an extra step I don't want to take. And it works fine in version 2008. So what can I do in version 2011 to make it open the files without all the coding?
View 2 Replies View RelatedSo i have working printing macro code in excel that sends files to selected printer based on last 3 characters, when i click a button only 1 file per click is send to printer but i want to send more files (quantity is listed in row D). I think i need to add quantity row to shell command for printing so it will send not only name of pdf file but quaintity too:
[Code]....
Here is a rough look in excel and rows : PDF.jpg
And here is whole code:
[Code] ......
I've been given the assignment to replace an old company name with the new one in an excessive amount of excel files. All the excel files seem to be some kinds of forms with fancy buttons and such. I've been trying to research this quite a bit but only found some shady programs which I'm not installing on company computers so I decided to write a batch script to try and accomplish this, if you have any other ways to do this do let me know. So far I've only got a basic skeleton of the batch script, like looping through all the excel files in a directory and then loop through all the worksheets within the file. Here's how it looks
[Code] .....
I just want some confirmation that this would actually work and how to replace all occurrences of a string in a workspace.
I would like to be able to open multiple .txt files into one excel document. I had been using a code that opened all the files I wanted into a NEW excel document. I have a template that I use and I want the files to open in sheets following the main template sheet. This is what I have been using:
Sub CombineTextFiles()
Dim FilesToOpen
Dim x As Integer
[Code]...
And it worked just fine for that purpose but how could I edit this?
how I could use VBA to make a table out of data that would be cool too.
I am absolutely new to VBA and trying to create a macro for work. We get daily files with almost the same headers that needs to be consolidated at the end of every month. The headers on the files are usually the same, except at times an extra column may be added at the beginning.
I need a macro to do the following-
Prompt to select the desired files.
Read the headers and append only the desired header columns from these files to a master file(these are Account, User, Modified By, Version). The headers are present in row A. Also, the master file should select the header from the first file only and hence take only the data (row B) from the second file onwards so that the headers are not repeated in the middle in the master file.
In the master table, add a new column at the end which will be the name of the file.
In the master file generated, filter on the column "Version" and delete all the rows except Version="1.0"
Lastly, there are certain values in the excel files that need to be changed. So I need a replace function to change those values.
I need to get a word cound from 140 excel files.
I don't want to calculate cells with just numbers and they have to be words.
Better still If I could get all the text into one word document, that would be even better.
I want to open files from an excel list.
Sub Openfile()
Dim wkbOne as Workbook
Set wkbOne = Application.Workbooks.Open(Filename:=Worksheets("Sheet1").Range("A1") & Worksheets("Sheet1").Range("B1")
'where "A1" is the path where the file located and "B1" is the file name.'
End Sub
When I run this it will work, but if I change to below it won't open all file in range, what's wrong with this?
Sub Openfile()
Dim wkbOne as Workbook
Set wkbOne = Application.Workbooks.Open(Filename:=Worksheets("Sheet1").Range("A1:A10") & Worksheets("Sheet1").Range("B1:B10")
End Sub