$$Excel-Macros$$ Re: Excel Group Survey : Please participate.

2010-06-22 Thread Ayush
Dear Group, The survey has not received many responses. I have published the link of survey form on home page of this group. Anytime you have any inputs , Please do not hesitate to share with us through this survey form. Thanks to all for keeping this group alive. :) Here is the link again for y

$$Excel-Macros$$ Solver - Can I run VBA code between iterations within solver

2010-06-22 Thread RBachman
I have successfully been programming with the solver for years and am very familar with it. I typically use it to solve a non-linear equation at one point in time and then advance the solution in time. In this approach one has a cell given by a formula that one is typically driving down to zero by

$$Excel-Macros$$ Re: linking between autocad and excel file

2010-06-22 Thread sudhir
Dear ,i m still wating , there is no reply... On Jun 16, 9:36 pm, sudhir wrote: > hi friends, > i have an unique and different problem..., i want to updates my > excel file automatically as soon i'll update my autocad file. > > i'll explain in detail, > i have an autocad drawing which r

$$Excel-Macros$$ Re: VBA Help for comparing two lists

2010-06-22 Thread who
Hello, I have a file that aligns a trial balance by branch, which I think will come very close to what you want. I think it can be adapted so the missing account could be inserted into the right place, so you don't need to create a list or find what is missing, just complete the list. I do not kno

Re: $$Excel-Macros$$ Re: Convert excel into pdf

2010-06-22 Thread vikas gupta
On 6/22/10, Jagjeet Singh wrote: > Hi Ashish > > You can download pdf/xps converter from microsoft site for excel > 2007.After installing that you can save the file in pdf format from > excel/word/ppt itself. > > Just click saveas and then select pdf format > > > Hope it will help > > Regards > >

$$Excel-Macros$$ Re: Convert excel into pdf

2010-06-22 Thread Jagjeet Singh
Hi Ashish You can download pdf/xps converter from microsoft site for excel 2007.After installing that you can save the file in pdf format from excel/word/ppt itself. Just click saveas and then select pdf format Hope it will help Regards Jagjeet Singh On Jun 22, 10:25 am, Ashish Khandelwal <4

$$Excel-Macros$$ Re: VBA code Help to move the sheets based on condition.

2010-06-22 Thread Jagjeet Singh
Dear Veenu, Find attached the required macro. Copy and paste following code in your MVB Editor. -- ' Macro for Auto filtering the contents of a workbook

Re: $$Excel-Macros$$ Help

2010-06-22 Thread Regina Medhanie
I am using the MID function for two columns which contains times and moslty it works EgEg. the first column contains 111030, ie , 9 o'clock 10 minute and 30 second , and the second column 112930 that is 11 o'clock 29 minute and 30 second. I want to reduce the data and show only hour and minute

$$Excel-Macros$$ Convert excel into pdf

2010-06-22 Thread Ashish Khandelwal
Hi, How to convert excel file into PDF. Please help. Ashish. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

$$Excel-Macros$$ VBA Help for comparing two lists

2010-06-22 Thread Jagjeet Singh
Dear All, I am having two lists, which contains trial balances. Every month one or two codes are getting added in the TB which i have to identify. Now to identify the new codes we use vlookup function on both the sheets and where #N/A Error comes we come to know that these are the newly added c

$$Excel-Macros$$ macro to move excel files to share point.

2010-06-22 Thread vinu
Hello Group, Does any one have vba code which move excel files from one folder to share point folder. I have 40 files and which i need to export to sharepoint 40 different folders. Is there any way to do in VBA. Regards, Vinu. --

$$Excel-Macros$$ VBA code Help to move the sheets based on condition.

2010-06-22 Thread Vinu
Hello Friends, Need VB code to perform the below process. Ideally my workbook contains many sheets. I listed all sheet names (in A1 cell) in the first page by using datavalidation. In B1 cell I used the data validation for the condition like weekly, yearly and monthly - each sheet in column O h

$$Excel-Macros$$ inserting text to change contents off a cell

2010-06-22 Thread Alexander Cargill
Hi all I was wondering if you could help, if you look at the following work book and the sheet that is called Bogy sets to attack there is co-ordinates in them, what I would like to do is select the contents off the column in a box (so I can selectively change them) and change the entry from XXX|X

$$Excel-Macros$$ Re: breaking links

2010-06-22 Thread Jagjeet Singh
Dear Sunny, You should copy the file to new location and then breaklink the new file.Don't breaklink the original file as it you would end up having the original file without links. For the warning message the "the links couldnot be updated , you should set parameter updatelinks to 0 this will n