Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

macro for converting notepad to excel.

Hi team,

Could someone please suggest how can i convert all the text which is not in format in a squential format.

Iam attaching an sample of it.

It would be an real help if someone does it for me.

Many Thanks in Advance.

Regards,
Shekar.


Post your answer or comment

comments powered by Disqus
I am trying to convert a report in notepad to excel. I have attached the actual report and a sample of the excel file format that it needs to be in. If anyone can guide me through this I would really appreciate it.

Thanks

Given:Have existing Excel 2003 files with macrosCompany is migrating to Office 2010, but will take minimum 1 year to complete entire rollout, therefore files will need to be able to be shared across versions.Office Migration Planning Manager (OMPM – free tool from Microsoft) scan indicates 5% of Excel files will have macros issues.Interviews with business to identify business critical files indicate ~20% of business critical Excel files have macro issues that cannot convert/upgrade without issue.
Request:
Can Excel 2003 files with macros be “updated” (whatever that may look like) such that upon opening the file a prompt will appear (or possible auto-detect) to determine the version of Excel being using, then only use macros compatible with that version?

An example might help clarify the request:
Person in HR using Excel 2003 opens a file Team_Expense_Report.xls (corporate template) and the macros within the file determine the person is using E2003 and run the applicable code. All existing buttons and calculations continue to work as they do today.

Person in Engineering using Excel 2010 opens a file Team_Expense_Report.xls (corporate template) and the macros within the file determine the person is using E2010 and run the applicable code. All existing buttons and calculations continue to work as they do today.*We know the corporate template has macros that fail when using E2010. Can we now embed macros for each version of Excel within these templates that will function properly for each group?

We have 15+ million Office files and ~100K files with macro issues so not everything can be fixed this way. But if we know we have a small group of files (I.E. corporate templates, budget forecasting worksheets) that we can apply this sort of “compatibility fix” to we would like to investigate the option.

I would appreciate some comments or feedback.
Greg

Hi Team,

I just wanted to know do we have a macro which can convert PDF to excel......?

Any help Would be greatly appreciated.

Thanks & regards,
Shekar Goud.

Hi friends,

I need some urgent help.
I need to import data from notepad to excel and filter the data
according to certain conditions.

I know how to import notepad file to excel, but how to filter the data
is not known.
Could you guys help me out.

thanks in advance.

Hi

Was wondering if there is a way to convert XML to excel format. I want to do this using VBA as I have data supplied to me in XML format and want to place it in a spreadsheet.

If anyone knows of a good source of information on this or a good book that explains this kind of thing it would certainly be useful.

Thanks in advance.

find the formula for converting Binary to Hexadicimal

Hi,
I'm wondering if anyone can help me with making a macro for adding BBcode to text(web-address)?
I want to add this [url= The Topic-adress] The name of the Topic [/url]

In column "A" Is the name of the topics
In column "B" Is the web-addresses

And i tried with:

In column "C" The target for the BBcode
In column "D" ]
In column "E" [/url]

But + and summer do only take values....

Any ideas?

Hi All,

I have a macro for embedding every cell in double quotes and then converting Excel to CSV.
The CSV file should have the same name as the excel file.
However since my excel file name contains "." in between,
ex : Test1.Test2.xlsx , i am not getting the CSV file to have the same name as excel

My objective is if the excel name is Test1.Test2.xlsx then the CSV file name should be Test1.Test2.csv

here is the macro,

Sub WrapInQuotes()
Dim TheFileSaveName As String, vFileNum As Integer, qcq As String, tempStr As String
Dim tempStr2 As String
Dim i As Long, j As Integer
Dim TheFileName As String
Dim InitFileName As String

TryAgain:
TheFileName = ActiveWorkbook.Name
If InStr(TheFileName, ".") = 0 Then TheFileName = TheFileName & ".csv"

InitFileName = Left(TheFileName, InStr(TheFileName, ".") - 1) _
& "D" & Format(Date, "yyyymmdd") & "T" & Format(Time, "hhmmss")

TheFileSaveName = Application.GetSaveAsFilename(InitialFileName:=InitFileName, _
Filefilter:="CSV (Comma delimited) (*.csv), *.csv", _
Title:="Please enter filename to export to")

If TheFileSaveName = "False" Then End

vFileNum = FreeFile()
On Error Resume Next
Open TheFileSaveName For Output As #vFileNum
If Err <> 0 Then MsgBox "Cannot save to filename " & TheFileSaveName: End
On Error GoTo 0

qcq = Chr(34) & Chr(44) & Chr(34)

For i = 1 To [a1].SpecialCells(xlLastCell).Row
For j = 1 To Cells(i, 256).End(xlToLeft).Column
tempStr2 = Cells(i, j).Text
If j = 1 Then
tempStr = RTrim(tempStr2)
Else
tempStr = tempStr & qcq & RTrim(tempStr2)
End If
Next j
Print #vFileNum, Chr(34) & tempStr & Chr(34)
Next i

Close #vFileNum

End Sub

Can anyone please help me on this ?

Hi,

I have a user who is using Lotus 1-2-3 for last 20 years. His file extension is .wk1 so I am assuming thats Lotus version 1. The Lotus version is ancient to say the least.

His manager has been asking him to move over to Excel as other users in his dept has done so long time ago.

This user does not want to learn excel and he has two macros in Lotus which nobody else knows how to convert in excel.

The question is how can I convert macros from Lotus 123 .wk1 files to Excel. We are currently using Excel 2003 but I can get Excel 2000 or 2007 if that helps in converting the macros. Is there a tool/utility available that can help me?

Your help will be appreciated.

MA1 4.056 5/26/2011 9:53:51 AM
Pressure 0.03 FALSE 5/26/2011 9:53:52 AM
MA2 4.056 5/26/2011 9:53:52 AM
4.056 5/26/2011 9:53:52 AM
0.18 FALSE 5/26/2011 9:53:54 AM
4.056 5/26/2011 9:53:54 AM
4.056 5/26/2011 9:53:54 AM
0.03 FALSE 5/26/2011 9:53:55 AM
4.056 5/26/2011 9:53:56 AM
4.055 5/26/2011 9:53:56 AM
0.34 FALSE 5/26/2011 9:53:57 AM
4.054 5/26/2011 9:53:57 AM
4.054 5/26/2011 9:53:57 AM
1.77 FALSE 5/26/2011 9:53:59 AM
4.055 5/26/2011 9:53:59 AM
4.054 5/26/2011 9:53:59 AM
2.48 FALSE 5/26/2011 9:54:01 AM
4.055 5/26/2011 9:54:01 AM
4.055 5/26/2011 9:54:01 AM
3.78 FALSE 5/26/2011 9:54:02 AM
4.056 5/26/2011 9:54:02 AM
4.057 5/26/2011 9:54:02 AM
6.1 FALSE 5/26/2011 9:54:04 AM
4.058 5/26/2011 9:54:04 AM

Hi, My data is in the above mentioned format(notepad). I have imported this notepad file to excel. I need this data converted into a particular format. For example, considering the first six lines the required format to be as follows:

Pressure/MA1/MA2/Time
0.03/4.056/4.056/9:53:52AM
0.18/4.056/4.056/9:53:54AM

Please help me with this as I have about 1500 files to be converted and each file has 1500 lines.

Thank you,

Mowlik Sridharan

NOTE: If it is difficult to explain over typing please let me know so that I can give you a call and figure it out.

Hi Excel Team,

Could someone please help i have a problem as of notepad to excel conversion.could someone can solve it would be great

Iam unable to run macro thorws an error.

Please help me.

Regards,
Shekar.

I'm struggling to convert my aggregate data into case level data. I want to create a macro that inserts duplicate rows based on the number of cases listed in the case count column (column E).
i.e. if I have an entry that says on October 25, 2010 (date variable, column A) there were 15 cases (case count, column E), then I would like to insert 14 additional rows that are duplicate entries for the reference date. Eventually I will delete the case count column and insert a case ID value (i.e. 1 to 15) for each of the cases on each particular date.

I'm completely stumped on how to do this and would really appreciate your input!

Hi,
I am working on some automation and wanted to know whether it is possible to make webpage TO a excel sheet.

I am attaching a screen shot for the same. Everyday morning I used to log on to this intranet site and run the webquery to generate the report and later I export (Website has a link to convert the report to excel) to Excel report. I am trying this to automate as run a macro to get the report on to my computer and later I send the report to large team everyday morning.

Is there a way to convert Notepad (columns and rows) data into mutliple Excel columns and rows within one worksheet?

When I copied and pasted, all of the information from the columns in the Notepad were pasted into one long Excel cell (instead of many), as I figured they might be.

I don't think there is a way around this, but I would greatly appreciate it if someone has a suggestion!

Hi guys, please could you help save me some time.

This is basically what i have:

250 folders (I folder per customer), each with 27 (months of info) notepad files, I need to write a macro which can open each notepad file for each customer then copy and paste the data into a different worksheet in a spreadsheet.

Does anyone have any ideas?

Cheers guys

Nick

Hi,

Sometimes i need to check the data from text file in notepad with my data in excel.

The text file is very difficult to read. I wonder is there a way to convert it to excel so that i can compare like to like.

Thanks

Hi. I am looking to convert a crostab file into a flat table.

I did use the search function and came across this
I feel my query is the same. But, I am struggling with how to adapt macro for my query.

CrosstabtoFlat.xls

If anyone can help that would be great.
In particular with explanation as I know the macro would solve many queries.

Thanks again for any kind of help offered. I know it is holiday season so people may be busy.
Happy holidays.

I want to convert code below to excell formula , can anyone help me?

	VB:
	
 Fonksyon171819() 
    Dim total As Double, i As Integer 
    total = 0 
    For i = 1 To 50 
         
        Cells(i, 1).Select 
         
         
         
        If Cells(i, 1).Value = 17 Then total = total + Cells(i, 11).Value 
        If Cells(i, 1).Value = 18 Then total = total + Cells(i, 11).Value 
        If Cells(i, 1).Value = 19 Then total = total + Cells(i, 11).Value 
         
         
    Next i 
     
     
    Cells(1, 12).Value = total / Range("K21").Value 
     
     
End Sub 
[COLOR=#3E3E3E][B][/B][/COLOR] 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I'm working to convert political expenditure reports from PDF to Excel, and I've tried most if not all of the "free trial" PDF conversion software packages. Does anyone have recommendations about dependable software in this area?

Many thanks in advance -

Jon

Hi i would like to know if its possible to automatically
convert .pdb to excel and then to access using the
macros. if possible, are there any codings for it?
..

Is anyone familiar enough with EasyLanguage to convert the following to
Excel:

Period = 0;
Value = 0;
For count = 0 to 50 begin
Value = Value + Interest[count];
If Value > 100 and Period = 0 then begin
Period = count;
end;
end;

I'm not familiar with EasyLanguage and I'm not sure about the direct
translation. Thanks for the assist!

Dear Sir,

May I know how to convert formulas to values under Excel 2002 and Excel 2007 ?
Is Copy and Paste Special is the only way ? Any keyboard short cut or
single button for this ?

Is there any short cut way of filling up the blank cells with the reference
just above it ?

Eg.

Before
AFD220
BLANK
BLANK
BLANK
AFD221
BLANK
BLANK
AFD222
BLANK
BLANK ….

After
AFD220
AFD220
AFD220
AFD220
AFD221
AFD221
AFD221
AFD222
AFD222
AFD222

Thanks

Low

--
A36B58K641

Hey guy's

I've been searching the web for quite some time now, but i cant find it.

First off:
My skills: Limited ( first time using vba,, but search the web for hours, so i know some basic stuff what i've read)
My programs: Office 2010
My question:

I have an map full with .doc files and want to convert them to excel files.

The word file has an table in it with data, This data is from machine specs, and i want to import them in to an excel database.
I thought the best thing is save / export the word table to an excel file.
And later on make an (master) excel file and link the seperate files to this master file.

I've got an working macro to import table dat from word in to an excel spreadsheet (found it on the web)
But it is limited to one file ( i've got 200/300 files so it would be easy i've vba can do it for me )

Code:
New Text Document (6).txt

I want to automate the proces and let it save the workbook automaticly
And this code only get cells 3,2 and 4,2
I want many more ranges and data cells, these i've already got sorted in another excel file so i can copy them real quick
But it needs an additional bit that overrules the empty cells ( i've pasted my ranges and cells in the macro ) and that works, but i get an error on every empty cell ( i dont have that basic knowledge )

I think you guy's can help me!
So please do so.

Edit:
To make the macro working i've changed Dim wdDoc As Word.Document
the Word.Document to Object.

I am using Excel 2004 (Mac) to create an Excel template for charts to be
copied into PPT and Word - all to be used on Windows.

I have created a macro which reformats a chart (removes the unwanted black
border which Excel automatically imposes upon user-defined charts), then I
resize the chart to the size I want (a choice of three sizes which the user
selects using a userform). This means I have to deselect the chart, hold the
shift key down to make the chart an object that can be resized.

The problem is that the recorded macro refers specifically to a worksheet
and a chart and in my recording I had to deselect the chart in order to hold
the shift key down.

I want the macro to work on any selected chart created in a
workbook based on this template. I also want it to go back to ordinary
selection again so I can copy the chart as a picture.

I have very rarely used macros in Excel, and so I know very little about the
process - except that recorded macros are quite difficult to use globally.

So I¹d very much appreciate any help on this problem.

Sol

PS Would it help if I provided the VB text I have created already?


No luck finding an answer? You could always try Google.