$$Excel-Macros$$ change keyboard language

2010-09-21 Thread عمر
I have textbox on form How can I change keyboard language to Arabic automatically Instead of pressing Alt + Shift keys -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ VBA code required for Folder activity

2010-09-21 Thread Paul Schreiner
How often do you have to do this? does it HAVE to be done in VBA? It's fairly simple to do it manually: In Windows File Manager (explorer), simply search the top-level folder for * then, select all of the files and drag them to the master folder. If you still want it to be done with VBA, it's

$$Excel-Macros$$ Re: CONFIRMATION PROBLEM IN EXCEL 2007

2010-09-21 Thread JsinSk
Not sure how the computer program works, but you can use the below code to suppress errors if using a macro. Application.DisplayAlerts = False Be sure to use this at the end. Application.DisplayAlerts = True On Sep 21, 5:27 am, vikas gupta vikas.63...@gmail.com wrote: DEAR ALL SOME DAYS

Re: $$Excel-Macros$$ Random Numbers generation

2010-09-21 Thread Giorgio
Thanks, it works. How can I make sure that if I repeat the command for x rows I will not get twice the same string (being same numbers, even if different order)? Thank you! On Sep 20, 9:19 am, Aindril De aind...@gmail.com wrote: Hi Giorgio, Looks like the issue was here: *Function

$$Excel-Macros$$ VBA and macro for importing data into separate worksheets with appropriate titles

2010-09-21 Thread Fred
I have one Workbook with one worksheet. I want to create a macro that imports data from 4 different Visual FoxPro data tables. For each external file I want to create a separate worksheet and rename it appropriately. I am getting an error in the macro for creating the second datasource. The

$$Excel-Macros$$ Using Web Services with Excel 2010

2010-09-21 Thread David
At my company many of our customers us Excel Spreadsheets to load data into the software system we sell. These spreadsheets were initially developed using Excel 2003. Then used the Office Web Services Toolkit for 2003 to access an assortment of Web Services to load their data into our system.

$$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

2010-09-21 Thread Abhidha Dixit
Dear ALL Please help how can i transpose the data from notepad to excel with the similar colomn gap so that when we copy this again to notebook i shall get the data with the samilar spaces thanks -- -- Some