Ad-Free CAclubindia and Daily Updates on your mobile. Subscribe Now!

Cut down your excel time by macro

Ghosh-giniexmail@gmail.com (ExcelToTally Accountant) (1386 Points)

17 October 2009

A macro is an executable program written in VB which runs backhand with excel/word other office applications. Macro can reduce your repeatative job to one single click. Post me any job you want to do with macro. I may help u out.

Reply
Follow
Share

9 Replies

girish (Practising C.A.) (149 Points)
Replied 17 October 2009

i had created macro for conversion of no. of rupees in to words in rupees. but how to include in other files...

Upgrade to CAclubindia Pro. Subscribe Now!

Ghosh-giniexmail@gmail.com (ExcelToTally Accountant) (1386 Points)
Replied 17 October 2009

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

shivaji (job) (424 Points)
Replied 17 October 2009

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

Ghosh-giniexmail@gmail.com (ExcelToTally Accountant) (1386 Points)
Replied 17 October 2009

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.

Mithreshan (Articled Trainee) (60 Points)
Replied 18 October 2009

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

Upgrade to CAclubindia Pro. Subscribe Now!

Ghosh-giniexmail@gmail.com (ExcelToTally Accountant) (1386 Points)
Replied 18 October 2009

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.

Mithreshan (Articled Trainee) (60 Points)
Replied 18 October 2009

I tried copy, paste special. by doing so

either I couldn't get the doc with same formatting... or
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.

Ajeet Sharma (Service) (25 Points)
Replied 18 October 2009

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

Ghosh-giniexmail@gmail.com (ExcelToTally Accountant) (1386 Points)
Replied 19 October 2009

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.