Cut down your excel time by macro

Copy your code to the module & call the macro as user defined function in any other file.

hello

please help in this matter

in word text file having 100 pages there are nearly 500 email ids here and then

i want to collect these email ids from the ms word file

is it possible to collect these emails id in a separate file

if so please help in this matter

thanks in advance

Siva your query is not elaborate. If the word data is in a table format then you can try simple copy paste in text format. If you want it as a list in a column of an excel file you may have to use text to column wizard from data menu. While doing so use delimited format & tickbox in comma/space as appropriate. Hope this will work.

How to convert a word doc into an excel doc and vice versa, keeping all the formatting intact??

I havenot heard about any such conversion software. But why you require conversion. Just copy paste will work both are products of microsoft, so excel allows you the option to paste as MS word object select that box & vice versa Word keeps same format whenc copy paste anything from excel.

I tried copy, paste special. by doing so

1. either I couldn't get the doc with same formatting... or
2. if i get it with all the formats intact, i could VIEW only one page 'iam not able to see all the pages unless i get into the Object which is pasted.'

Reg. my necessity for this - i hav some of the reports in word format & some in xcel, so while uploading for MCA purpose the size is more if seperate docs are attached to the forms to be uploaded.

so if i could get the word docs in the same xcel work book , then  maybe the size of the form to be uploaded is less.

Great Yaar,

I need your help, i am totally unknown about micro, how it works? and how its works?

Please let me know how can i make micro.

Thanks

Ajeet

Its esy to start. Think which are daily things you do daily when you work with excel file. Now write your first macro. Open a blank file. Select excel>tools>macro>record new macro. Its like recording your voice. There is no retake. If you sing bogus you will listen bogus. To start do something very little like select a range change the format etc. After you finish stop macro button. Now right click on the sheet tab & press view code. Whatever you have done it will recorded in vb commands. Test the command by Run/paly button on the menu bar. If your recording was perfect all the action you did will be repeated in fraction of second. Save this macro. Now your macro is ready Copy this code to any file & put a button/picture on the sheet Right click on it select assign macro & assign the macro you created. Next time you can run the macro just by clicking on the picture/macro button.