$$Excel-Macros$$ combine multiple tables

I have a workbook with 12 tables on 12 different sheets. I would like to write a vba to combine these tables into one table. Is this possible. Thanks in advance. Richard Mogy -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

$$Excel-Macros$$ VBA code to display the criteria selected from a filer

I have created a macro that will filter information from a report I generated. I would like to print on the total line the filter selected, such as TOTAL FOR EXPENSE GROUP AB when I select AB from the filter drop down. How could I do this Thanks in advance, Rich -- Are you =EXP(E:RT) or =N

Re: $$Excel-Macros$$ External Query not brining in all data

Sorry. I was saying that the field I'm selecting in my query, called xyz is defined in the SQL table as varchar (max), which means, to me, that the number of characters cab vary to the maximum allowed by SQL. Rich On Sep 19, 2013 10:21 PM, "Anoop K Sharma" wrote: > Hi Richa

$$Excel-Macros$$ External Query not brining in all data

I have created an MS Query using our SQL database. One of the fields, which is a varchar(max) field, will not pull over. Any suggestions would be greatly appreciated. Thanks in Advance. Rich -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

Re: $$Excel-Macros$$ Re: Find negative and terminate

This works perfectly. Thanks, Anoop. Richard -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Re: Find negative and terminate

Here's a simple example attached. On Wednesday, February 20, 2013 7:33:47 PM UTC-5, Richard Bridges wrote: > > Hi guys, > > I'd appreciate help with this one, can't quite figure it out. I need to > search all worksheets in a workbook for a negative number in

$$Excel-Macros$$ Find negative and terminate

e mismatch error 13 in this line (*). Thanks in advance for any help. Richard -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, acc

Re: $$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

That did it. I found out the issue (that user had macros disabled) and made appropriate changes so it will now run. On Monday, January 28, 2013 7:25:04 PM UTC-8, David Grugeon wrote: > > Hi Richard > > I suppose you are trying to say that, although the workbook opens, it does >

Re: $$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

Monday, January 28, 2013 7:25:04 PM UTC-8, David Grugeon wrote: > > Hi Richard > > I suppose you are trying to say that, although the workbook opens, it does > not do whatever the macro should do. Could this be because it is running > in the scheduler's workspace, which does

$$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

I have a workbook which has a VBA script in the thisworkbook called sub workbook_open. When I open the workbook, it runs perfectly, and does exactly what I want it to do. If I try to schedule it to run at 5PM everyday, Windows Scheduler will show that the job is running, and I know that the wor

Re: $$Excel-Macros$$ Need help with a couple subs

Thanks for the help, Ashish. I'll play around with it and see if I can get it to work for me. Richard > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Ple

$$Excel-Macros$$ Need help with a couple subs

d sum the values of their respective 'order this much' cell. I'm not even sure where to start, so any help would be appreciated. Thanks in advance. Richard -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accu

$$Excel-Macros$$ AutoFill/Copy & Paste Across Data Range to Last Row

Hi all this is my issue. I have a spreadsheet which is to form an adjustment tool for a DW, the users need to enter certain info and then the S/S will auto populate the rest. Columns A to G are user populated cells, H to L are auto populated by this macro I hope. The first row contains head

$$Excel-Macros$$ Budgeting Process

I have created a budgeting process as follows: I have a master workbook. My macro creates x workbooks for each of the managers that I want to fill out their part of the budget. Once the managers have filled out their items in their workbook I want to know the best way to update the master work

$$Excel-Macros$$ Re: For Each loop

Thank you both. I'll test it On Tuesday, June 26, 2012 8:23:36 AM UTC-7, Richard wrote: > This one always confuses me, but it is usually simple, so I would > appreciate any help. > > I want to loop through all the rows with data in my worksheet and if the > value

Re: $$Excel-Macros$$ For Each loop

; Set rng=UsedRange.SpecialCells(xlcelltypeblanks) > > Rng.value=”X” > > Rng.entireColumn.Locked=True/False (whatever your want) > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.

$$Excel-Macros$$ For Each loop

This one always confuses me, but it is usually simple, so I would appreciate any help. I want to loop through all the rows with data in my worksheet and if the value in a certain cell is equal to x then I want to unprotect selected columns in that row, otherwise I want to reset the protection

$$Excel-Macros$$ Re: Macro to copy a macro from one workbook to another

Thank you very much On Sunday, June 24, 2012 4:46:35 PM UTC-7, Richard wrote: > > I would like to create a macro to copy a macro from one workbooks module > area to another workbooks "ThisWorkbook" area. > > The first workbook is the master and any other workbook w

Re: $$Excel-Macros$$ Macro to copy a macro from one workbook to another

in code in the "ThisWorkbook" section that with lock selected cells. I know how to write the code to do this, but not how to get it in the "Thisworkbook" section using my macro that creates the child workbooks. On Monday, June 25, 2012 5:55:52 AM UTC-7, Rajan_Verma wrote

$$Excel-Macros$$ Macro to copy a macro from one workbook to another

I would like to create a macro to copy a macro from one workbooks module area to another workbooks "ThisWorkbook" area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub workbook_ope

$$Excel-Macros$$ months and fraction of a month between two days

Hi All, I would appreciate a vba function that will calculation the number of months and fraction of a month between 2 dates. i.e. January 1, 2011 to February 14, 2011 would be 1.5 months January 1, 2011 to February 15, 2011 would be 1.5335714 January 1, 2011 to March 15, 2011 would be 2.483871

$$Excel-Macros$$ List Box

I am trying to populate a list box with the results of a query. I have created the following code, which only populates the first column of a two column listbox. The items in MyArray are present for both bolumns. Dim MyArray() ReDim MyArray(mycount, 1) usrGLDist.lstOutput.ColumnCount = 2 For

$$Excel-Macros$$ Row height

Is there a way to determine what the row height should be since AutoFit doesn't work in a cell with a lot of text? Thanks in advance. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

$$Excel-Macros$$ Sending (POSTing) information to a web-site

I am trying to send information to the referenced website and have it return a pdf file. I have "referenced" WinnHTTPservers, but this code doesn't seem to connect to the website. What am I doing wrong Dim cr As InternetExplorer ' Set cr = New InternetExplorer cr.Visible = True ' Dim http As W

$$Excel-Macros$$ Re: Run a macro every time excel is opened

Create a sub called "sub workbook_open" in "this workbook" and call your macro. On Dec 18, 3:34 am, "C.G.Kumar" wrote: > I want a macro to run every time when an excel file is opened. -- -- Some important links for

$$Excel-Macros$$ Require specific entry in a cell or nothing

Is is possible to require a specific entry in a cell, or nothing? If someone makes an entry in a cell, I want it to be ABC (all upper case) and nothing else. It's OK for the cell to be blank. How can I do it? Thanks in advance. Rich -- -

$$Excel-Macros$$ Command Line

I have a workbook that I would like to have updated nightly by the scheduler. To that end, I have created a sub workbook_open that calls the macro that I need to run. How do I stop the macro from running when I open the workbook manually? I know I can open the workbook holding down the shift key