$$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 importa

$$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. So

$$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 cod

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 wrote: > Hi Giorgio, > > Looks like the issue was here: > > *Function RandLotto(Bottom

$$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 wrote: > DEAR ALL > > SOME DAYS BEFORE I HAVE INSTALL

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$$ 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