Take two separate excel files and convert into another format. I know it sounds crazy, but I will post a screen shot of before and after.
Input file called 2-qip-dnsdomain.csv which has several rows that look like: ...
I would like to create a formula that would break a number into seperate currencies as follows:
Any amount that is >0 would be flagged as "gp"
Any amount that is .1 would be flagged as "sp"
Any amount that is
I want a macro that will open a without fiile in a folder and convert without format file whose name is like
"cognos.701Z%27%5d&SA=propEnum,properties&ITEM=data&EA=&SS
=queryOptions,options&dataEncoding=MIME&ES=&EM=" to Excel (.xlsx).
Save excel file in same folder and delete above file.
I need to rename some jpg's in the c: emp directory ( about 600 ! )
In Col A starting at A1 I have the following:-
DFCF0156
DFCF0157
DFCF0159
DFCF0161
DFCF0164
etc
In Col B starting at B1 I have the following:-
ID3425
ID5823
ID427
ID7272
ID8875
etc
In c: emp is have:-
DFCF0156.JPG
DFCF0157.JPG
DFCF0159.JPG
DFCF0161.JPG
DFCF0164.JPG
etc
What I want to end with in C:TEMP is:-
ID3425.JPG
ID5823.JPG
ID427.JPG
ID7272.JPG
ID8875.JPG
Is there a way to put vba code to a standard alone exe file? This way, I don't have to keep update the code on different excel files.
I'll get straight to the point. I have a file with an (.ASC) extension that has information that I need in my workbook. The first problem is that in the .ASC file ...
a) there are french characters that don't translate into excel when I open it up
b) the date format is dd/mm/yy and excel doesn't seem to like this and only converts it as mm/dd/yy for those it can and the rest it leaves as text.
When I manual open the file problem b) disappears but if I use a macro problem b) pops up.
Right now I'm using this code to open the file
I have a few hundred work orders done in Excel. Each spread sheet is a seperate file but all are identical in structure (basic order form). I need to change the value in the same cell on all the forms (manager's name needs to be changed on all our forms).
Question: How do I do this without having to open and edit all five thousand forms?
I need a VBA code to create a Text file which should be in the form of DML (my scenario is to get Insert Statements for the Data available in the Excel) from Excel Sheet. And this has to be done by assigning a macro to command button where by clicking on it the DML text file should be generated. Even the syntax for the scenario will do.
View 1 Replies View RelatedI have wrote a few macros before which involved searching, copy pasting and comparing.
I now need a macro that can first open a text file, in this text file will be 6 section separated by 6 different titles so it will look something like this
title1
467575
56
56745
547
575
title2
65ryret
ryr534............
Attached file where i m not able to split data in seperate seperate coloumn
View 3 Replies View RelatedI want is a constant separation of two lists by 3 rows, one above another in one sheet. I have illustrated my desired change-and-results through the following images and hopefully they are self-explanatory.
I think its important to explain that I want the macro activated by the change of results in Column A in sheet2.
Current Sheet1
Current Sheet2
Current Sheet1 with Formulas
Current Sheet2 with Formulas
Sheet2's 1st Change (Time)
Sheet1 Response to Sheet2's 1st Change (Time)
Sheet2's 2nd Change (Replace)
Sheet1 Response to Sheet2's 2nd Change (Replace)
I copy a workbook from a master workbook once copied the modules are not copied but sheet modules exist after copying.
Can I have in a sheet module that will prompt a message box to open and ask to copy the amount of worksheets from the number in cell M5 in Sheet 1 Sheet 2 cell M5 will also contain a number also the other sheets will to Print that qty. of sheets from the workbook. these sheets are name sheet1, sheet2, sheet3 and etc.
But, there are other sheets I would only need 1 or 2 print outs these sheets have names in the tabs.
I want macro which export each excel column to new text file. The data in excel file is number. The column has only 5 rows that means each new text file should contain five lines of one column. It looks simple but couldn't manage to do macro for it. I have very big data set in one excel file, and have to be splitted into text files. The file name in new text files can be any kind as long as it can be in some sort of order for each export.
View 2 Replies View RelatedI have a program that has all Excel Workbooks in seperate instances of Excel. There is a very sound reason for doing this.
The user has maybe 3 to 10 workbooks open. There are times when a workbook is active and has a Macro Link to open one of the already open workbooks.
When the user clicks the link, they naturally get an error message stating that the workbook is already open. Then they have to close the error msg and click on the Macrosoft Tab and look thru the list of open workbooks and then click the one they are looking for. Additionally, in this Menu Program the user really doesn't even have to know the name of the various workbooks.
I hope everyone will believe me when I state that this program works berautifully.
Right now I am simply cleaning up and making a few little things work better.
QUESTION When the user clicks on a macro link that is to open a workbook that is already open, how - On error - can I have the macro continue on and activate the requested workbook - - - Please remember they are all in separate instances of Excel.
Since the code I'm using can determine if the requested workbook is already open, I think there has to be a way to activate that workbook.
I am trying to create code for a Macro that will compare items in two seperate lists in a spreadsheet, and eliminate all entries that do not appear in both lists.
I have cells in a column that record time in date. Unformatted it would appear as 19789.51407 but formatted to show time and date it would as appear as 3/6/54 12:20 PM. I am making graphs with the data and I want the title of my x axis to read "GMT Time (mm/dd/yyyy - mm/dd/yyyy)" or "GMT Time (mm/dd/yyyy)" depending on if the event spans more then one day. Using the following code, it almost accomplishes this.
Dim strDate As String
Range("CO3").Value = Range("A3").Value
Range("CP3").Value = Range("A" & Drag).Value
Range("CO3:CP3").NumberFormat = "m/d/yyyy"
If Range("CO3").Value = Range("CP3").Value Then
strDate = "GMT Time (" & Range("CO3") & ")"
Else
If Range("CO3").Value < Range("CP3").Value Then
strDate = "GMT Time (" & Range("CO3") & " - " & Range("CP3") & ")"
End If
End If
Where "Drag" is a variable that signifies the total number of cells in the column; ie the first and last dates. It compares the values and saves the results as a string. The problem is that when the string is saved it saves the date in mm/dd/yyyy hh/mm/ss. How can i separate the date from the time so I can have the title of my x axis appear as i need them?
I have attached the xls. I have an input sheet with 3 columns to enter data. Each column is linked to a separate worksheet with a formula (Carrys 1000 rows long). I need to be able to pull the populated data from those 3 worksheets and paste into 1 column continuously on another worksheet so all data is on top of another without any spaces.
I made an if statement so that if there isn't data pulling from the input sheet the a blank cell is left to indicate the last row to copy data from and paste on the final sheet.
how to word it but if someone understands then please help. I have two excel data files namely Book1.xls & Book2.xls. Both files have different data in it. Both files contain macros. When these macros run the files become **FINALIZED** version.
Originally, I get the above files in my email as txt. attachments. I then move these two txt files to my desktop in a folder called Folder-1. Then I open these files as an Excel and save them.
Basically, I need to know if two txt files are sitting in a folder-1 on my desktop. What can I do or what can I clik that....those two text files get converted into excel automatically, including running that macro I talked about in the above paragrah.
To put it differently, if I have two txt files Book1.txt, Book2.txt in a folder, how can I automatically create an excel **FINALIZED**version which sits right next to their txt version.
I tried many ways to convert a CSV file into a formatted Excel (.xls) file via VBA. I have a file with 5 lines (header included) and about 10 columns (delimited by commas).
How can I format it via vba on button click action?
Is there a way to convert a csv file to an xls file without using any software.
View 4 Replies View RelatedI have a spreadsheet with thousands of lines of code. Each row contains a complete code that needs to either be converted/pasted to a new .txt or .xml. Until now, just copying and pasting each line into a .txt file was necessary but there has to be a way to automate this. I would love to know if it's possible to extract each row(technically it is only a single cell per row, so its just a really large single cell) and add it to a .txt or .xml file?
View 12 Replies View RelatedI'm trying to convert a csv file but after conversion not everything is in place.
View 3 Replies View Related>I am trying to convert a Lotus file over to Excel, and am having some trouble
>converting an error handling dget function.
>
>=IF(ISERR(DGET(Databaseread,"Name","GROUP
>ID"=GroupNumber)),VLOOKUP(GroupNumber,Databaseread,4,FALSE),DGET(Databaseread,"NAME","GROUP ID"=GroupNumber))
>
>This is the function that was used in Lotus; it returns the name of a
>company by looking at the ID number. I need to keep it as pure as possible to
>the Lotus file.
....
Lotus 123's @DGET (and other database functions) are much more
sophisticated than Excel's counterpart functions. 123's can use
criteria expressions in the function calls. Excel's require criteria
ranges.
In this particular case, there's no need to use DGET at all. There's a
single criterion term, so VLOOKUP is sufficient. If the "Name" column
were the 4th column in Databaseread, then try
=VLOOKUP(GroupNumber,Databaseread,4,0)
Explanation: it appears you're just trying to find a particular group
number. DGET (and @DGET in 123) returns an error if there's more than
one entry. VLOOKUP returns the first matching entry. You're formula
makes it clear you want either the only matching entry or the first
matching entry. However, when there's only one matching entry it's also
the first matching entry, so VLOOKUP alone would have returned the
desired result.
I suspect you have other formulas that are more complicated, but you
believed the formula above would be a reasonable sample to provide. Not
so. If you have more complicated D-function calls, show them, not the
simple ones.
Is there a free program available to convert PDF files to an excel file.
View 1 Replies View RelatedConverting excel files into fully functional standalone and interactive web applications/dashboards? I have only worked with spreadhseetconverter before it converts excel files into interactive calculators but lacks the features which are available in the standard dashboards like gauges and widgets and the rest because it only converts the standard excel charts. I wonder if you have encountered a product which can converts excel files into fully functional interactive dashboards?
View 1 Replies View Relatedconvert all spreadsheet in a workbook to one pdf file. I use PrimoPDF to convert, then I only convert 1 sheet to PDF even that I have select all sheets. My be it is a better PDF converter for free you use or other ways to do it.
View 4 Replies View RelatedI am finishing up a program using excel that does a lot of nice things, and seems to be working. I want it to be used by anyone, even if they do not have Excel. I want it to be *my* program completely, w/o Excel being a part of it anymore. Is there a way to compile an excel file and turn it into an EXE file so there is no need for an excel program to run it?
View 5 Replies View RelatedSomeone sent me a pdf file. It contains a list of items but the problem is I need to be able to copy and paste each item individually. I tried doing a google search to find a way to convert the PDF to a word doc but did not have any luck. So I think my only other alternative is to convert it to an excel (XLS) file.
Does anyone know of a way to do this so that I can successfully copy and paste words from the document individually and not just wind up with an excel file with a picture of the PDF file in it?
I am having trouble converting file formats. I would like to convert a.xlsx file to a .xls file. It is password protected and everything I have tried to use to convert the file has failed.
View 5 Replies View Related I have the following code (borrowed) which converts the current .xls worksheet to a tab-delimited .txt file. The problem is that i need to add a PIPE to the end of each row/record as well, so that the records would look something like this:
A|123|
B|456|
currently there is no PIPE following the last character (3 or 6) and i am getting this:
A|123
B|456
I was hoping there would be a way to revise the VBA to add a PIPE at the end of each row/record.
Here's the code:
[Code] ......