My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead in a leading IT Firm for over 6 years now.
For the last 1 year I am settled in Amsterdam, Netherlands & still hold my passion in Excels & Macros 😉 😉 Isn’t it an achievement ??
Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it
I am very much passionate about travelling & quite recently discovered that I am a good photographer too.. 😛 I love listening to music & my roommates say that I am great chef too. So, don’t be surprised if you suddenly start finding some exciting recipes on my blog
Excel Books I recommend..
Recommended Articles and Pages:
AND GET A FREE!
E-BOOK FOR EXCEL VBA BEGINNERS
DON’T MISS ANY EXCEL UPDATE !
Get your FREE! E-Book & Have Every New Article Delivered Straight To Your Email-box
Coming back to the Blog, it was started in October 2011 with an intention of just accumulating my articles & few of my friends wanted me to share my knowledge. But today as I look back my journey & it gives me immense joy that there are now 130+ articles, 10+ Excel Tools and Add-ins, 1mn+ visitors and 1000+ Google Feed subscribers.
I have designed this blog keeping in mind all kind of readers – Advanced, Medium and Beginners in Excel.
Here are few commitments to my readers:
- Reply to the queries asked here as soon as possible.
- Provide useful articles in a very easy way with Examples, Code Snippets, Images and Videos wherever possible.
- Articles can be published based on reader’s requirement. If you want a specific article to be published here, kindly use the Contact Page and type your requirement and send it to me. I appreciate this personally:)
- Open to hear feedback/suggestions any time.
What my readers says About me?
Converting visible sheets in a WB into PDF
I am working on an executive dashboard, have multiple supporting sheets in an excel workbook. I want to provide a button with macro code to convert all the visible sheets in the workbook into pdf. Hoping you could help define a code for this.
Thanks in advance!
Your File Manager excel file is excellent
Is it possible to give password for each excel file after listing out from Folder and Sub-folder, if so, please let us know.
Converting PDF document to excel
Hi, do we have any way to convert pdf document to excel sheet using VBA macros.
or using any programming language, kindly help me on this.
thanks in advance
how do we change the interface of the menu bars using macros in excel??
This site is very useful for very basics as well as advanced level & useful in simple doubt , Thank you very much.
Need a macro which can make me work easer
take a tab and search that particular item in the PDF file and return that particular item from PDF to excel
I want to use your File Manager on my work share drive. The main folder has about 12 pages of sub folder and files. When I copy and paste the address of Share Drive Folder in the Browser, it says the address not valid address.
Can you please advise me to resolve this issue.
Compare two columns in different sheet1 and aheet2 and retrive corrsponding value in sheet2
The current sheet name is (Book1)
The ID and some more information is typed as a brief description of the (ID)
Save bottom is available
Small code is required to do the following when the (Save) bottom is clicked:
1- Save this sheet as ID (123456.xlsx)
2- Close the sheet
need a macro to check multiple doc on that the ph no are unique or not
Want a regular update on Excel and Excel Macro?
I post interesting Articles, Tips and Tricks regarding Excel frequently here. If you do not want to miss any of them then subscribe to your email so that new articles will be directly delivered to your mailbox.