Re: $$Excel-Macros$$ Need to populate the data from Pivot

2011-09-19 Thread anu gomathi
Hi All, Any suggestions? Regards Shiek On Thu, Sep 8, 2011 at 10:46 PM, anu gomathi anugomathi.d...@gmail.comwrote: Hi All, Please help me with macro to populate the data from the the pivot to the specific fields Regards Anu On Wed, Sep 7, 2011 at 3:17 PM, anu gomathi

Re: $$Excel-Macros$$ Power point Query

2011-09-19 Thread Shrinivas Shevde
Dear Alisha Many many thanks for the help Really Good Work and Defenitely It will work. Now Can I copy paste that rotating round in my presentation which is already ready I also Want to change the colour If yes please let me know how to do it Thanks once again Shrinivas On Sat, Sep 17, 2011 at

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-19 Thread johnofeasttex
Can anyone show me how to import the first 2 rows of data from the text file into excel as the following code builds the list? Thank You for ANY help.. John On Sep 16, 2:04 pm, johnofeasttex j...@demco-mfg.com wrote: I searched around and found some code that allows me to create a list of the

Re: $$Excel-Macros$$ userform

2011-09-19 Thread Sam Mathai Chacko
No On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema shankar.n...@gmail.comwrote: Hai Goodmorning all, Is it possible to make an Excel Userform as an executable file ? -- -- Some important links for excel

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-19 Thread ashish koul
hi John can you attach the notepad file and output excel file On Mon, Sep 19, 2011 at 6:40 PM, johnofeasttex j...@demco-mfg.com wrote: Can anyone show me how to import the first 2 rows of data from the text file into excel as the following code builds the list? Thank You for ANY help..

Re: $$Excel-Macros$$ userform

2011-09-19 Thread rajan verma
You can try visual studio , by excel its not possible On 19/09/2011, Sam Mathai Chacko samde...@gmail.com wrote: No On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema shankar.n...@gmail.comwrote: Hai Goodmorning all, Is it possible to make an Excel Userform as an executable file ? --

$$Excel-Macros$$ Importing csv file vba code

2011-09-19 Thread ajjw123
i am very new to vba programming in excel. So pls help me I would like to import a csv file daily into a fixed workbook by asking the name of the csv file from the user. -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Need quick help on macros

2011-09-19 Thread vinod rao
Hi, I need a dynamic macro delete the worksheet based. Should segregate files accordingly, First one should contain Worksheet 1 to 7 and second file should contain 1 to 2 and 8 to 11 and thrid file will be 1 to 2 and 13 14. Worksheet1 *Total* ** *should remain * Worksheet2 *Summary*

Re: $$Excel-Macros$$ Importing csv file vba code

2011-09-19 Thread NOORAIN ANSARI
Dear Ajjw, Please try. and see attached sheet.. *Sub import_csvfile() On Error GoTo abc Dim csvfile csvfile = Application.GetOpenFilename(CSV (*.CSV),*.CSV, , Please select CSV file...) Workbooks.OpenText Filename:=csvfile, Origin:=xlWindows, StartRow:=1 With ActiveWorkbook

Re: $$Excel-Macros$$ Power point Query

2011-09-19 Thread alisha malhotra
Dear Shrinivasan/Umar, From the slide master you can copy paste it in your presentation.You can change the colour as well. After clicking on the custom animation pane, you can see what i have done. Still I am trying to explain you. First take any shape or text box. Then in custom animation (

Re: $$Excel-Macros$$ Need quick help on macros

2011-09-19 Thread vinod rao
Please help, it is very very important to me. On Mon, Sep 19, 2011 at 8:37 PM, vinod rao vinod.ma...@gmail.com wrote: Hi, I need a dynamic macro delete the worksheet based. Should segregate files accordingly, First one should contain Worksheet 1 to 7 and second file should contain 1 to 2

$$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread HarryP Knuckles
Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can open the workbooks (individually) and have a marco to perform three necessary functions on all of these workbooks (each workbook will have a unique name). My objective is to:

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread Paul Schreiner
Are you wanting to disable the macros permanently and save the  file? or are you just needing them disabled so you can extract the information you need? If you just need them deactivated temporarily, you can create a macro that issues: Application.enableevents = false then, open each of the 

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-19 Thread ashish koul
Hi John Try this one you need to have full paths in column f Like below C:\Documents and Settings\achamanlalko\My Documents\Downloads\3004.OUT.txt C:\Documents and Settings\achamanlalko\My Documents\Downloads\7110.txt Sub importnotepaddata() Dim i, j As Long Dim s As String Set objFSO =

Re: $$Excel-Macros$$ userform

2011-09-19 Thread Shankar Bheema
thank you for responce On Mon, Sep 19, 2011 at 7:45 PM, rajan verma rajanverma1...@gmail.comwrote: You can try visual studio , by excel its not possible On 19/09/2011, Sam Mathai Chacko samde...@gmail.com wrote: No On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema

$$Excel-Macros$$ Macro to open file from a location and consolidate data (Please dont consider this as a Duplicate post)

2011-09-19 Thread Ragavan
Hi all, I have an urgent requirement for a macro that can open all the files from a path provided in a cell in excel work book and copy the contents from Columns A to K (consolidated data) in the new workbook. Kindly provide me the code to perform this operation, so that I can modify it according

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread ashish koul
Hi Harry 1 are all the workbooks in xlsm or xls format is it possible for u to share a sample workbook On Tue, Sep 20, 2011 at 1:28 AM, HarryP Knuckles kent.bouc...@tbs-sct.gc.ca wrote: Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a

Re: $$Excel-Macros$$ Power point Query

2011-09-19 Thread Shrinivas Shevde
Dear Alisha Very Very thanks for Help nicely Explained Shrinivas On Mon, Sep 19, 2011 at 10:13 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Dear Shrinivasan/Umar, From the slide master you can copy paste it in your presentation.You can change the colour as well. After clicking

Re: $$Excel-Macros$$ Finding Merged cells in excel

2011-09-19 Thread Amit Gandhi
thanks alot sir. On Thu, Sep 15, 2011 at 5:47 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: To find a merged cell in Excel 2003. 1. Open a Find and Replace Menu. 2. Next to the Find What Field is a Format Box, Click it. 3. This opens the Find Format Menu screen which looks very similar