|
More site info...
General Excel Discussion & Other Questions | Forum profile
|
|
Forum profile page for General Excel Discussion & Other Questions on http://www.mrexcel.com.
This report page is the aggregated overview from a single forum: General Excel Discussion & Other Questions, located on the Message Board at http://www.mrexcel.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "General Excel Discussion & Other Questions" on the Message Board at http://www.mrexcel.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on General Excel Discussion & Other Questions:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
12
|
63
|
215
|
|
Post:
|
24
|
177
|
541
|
|
|
General Excel Discussion & Other Questions Posting activity graph:
|
Top authors during last week:
user's latest post:
budget planning software
Published (2009-12-18 03:16:00)
Quote: Originally Posted by faanalyst does anyone have any suggestions for budget planning software? I use Excel. What you do will depend on complexity; if multiple people will be submitting budgets for their sections I generally push the data up to Access, where I slice and dice it and push consolidated data to another workbook, and/or upload to another system (such as TM1). If you don't need to go that far, you can do the whole thing...
user's latest post:
USB memory stick
Published (2009-12-25 23:51:00)
I buy mine from Amazon - you can get a waterproof Voyager 16Gb for your budget or less.
user's latest post:
Olap
Published (2009-12-20 21:47:00)
What is OLAP in Pivot table. How I can use it?
user's latest post:
HTML Maker
Published (2009-12-21 06:59:00)
How do I downloads & install Colo's HTML maker?
user's latest post:
count table numbers
Published (2009-12-23 02:01:00)
To include nested tables: Code: Sub Test() Dim oTbl As Table, oCell As Cell, i As Integer With ActiveDocument i = .Tables.Count For Each oTbl In .Tables For Each oCell In oTbl.Range.Cells i = i + oCell.Tables.Count Next Next End With MsgBox "This document contains " & i & " Table(s)." End Sub Note: this code will not find tables in headers, footers, shapes (eg text boxes), etc. For that, you...
user's latest post:
Question on VBA products
Published (2009-12-23 06:36:00)
Hello Excel Team, I am interested in self teaching VBA. I am looking to buy some kind of visual CD/DVD which can help me learn VBA for Excel from the start to finish. I am looking for a method of learning which should be very visual, simple and have easy to follow instructions because I have no prior knowledge of programming. Could you please help me with the following.. (1) With a background like mine is there is somthing that you can...
user's latest post:
What is the best way to do this...
Published (2009-12-23 15:47:00)
I have been slowly learning a lot of things from this website, and now I am creating a game simulator program in Excel 2003. I would like to keep this "game" device small as possible and also have a touchscreen. Is there anyone that has any suggestions as to what PDA, Laptop, Touchscreen, CPU, or other possiblities I might research for use? I just started looking at an NEC 880 Professional Laptop that has Pocket Excel v3.01,...
user's latest post:
Reflections import to Excel
Published (2009-12-26 12:17:00)
Just kill the file if it exists... I'm assuming that the file is created if it does not exist to begin with... Sub logs() CR = Chr$(rcCR) on error resume next kill "C:\EVDO Test Logs.xls" on error goto 0 Session.PrintToFile = "C:\EVDO Test Logs.xls"
user's latest post:
count table numbers
Published (2009-12-22 20:14:00)
Maybe try: activedocument.Tables.Count But if you have a table inside of a table, I don't believe it will count that as 2. Not sure what you need? Hope that helps.
user's latest post:
Reflections import to Excel
Published (2009-12-23 22:46:00)
I have a program called Reflections WRQ that I need to run a command and have the results dump into an Excel worksheet. I am using the below code and its working, but here's the problem I'm having. When I run the command a second time, it does not overwrite the data from the first time I ran it. Instead it adds to it. I need it to overwrite every time. Thanks in advance. Sub logs() CR = Chr$(rcCR) Session.PrintToFile =...
|
|
|
|
Latest active threads on General Excel Discussion & Other Questions::
Started 6 days, 12 hours ago (2009-12-23 06:36:00)
by irfananeeza
Question on VBA products
Hello Excel Team,
I am interested in self teaching VBA. I am looking to buy some kind of visual CD/DVD which can help me learn VBA for Excel from the start to finish. I am looking for a method of learning which should be very visual, simple and have easy to follow instructions because I have no prior ...
Started 1 day, 8 hours ago (2009-12-28 10:14:00)
by teylyn
Hi,
insert a section break (next page) at the end of page 3, then a section break (next page) at the end of page 4.
Now you can format the section on page 4 separate from the rest of the document.
does that help?
Started 3 days, 21 hours ago (2009-12-25 21:28:00)
by Greg Truby
If you're talking about what we call a "thumb drive" over here, though I think the proper term is " USB Flash Drive" (a "memory stick" is actually a Sony product) - at least here thumb drives are everywhere. Any office supply store has them, as would any electronics retailer. Street price for 8 GB drives is about $20, most of your 16 GB drives are a little under US$40. Though, AFAIK, none are beer...
Started 3 days, 6 hours ago (2009-12-26 12:17:00)
by Tom Schreiner
Just kill the file if it exists... I'm assuming that the file is created if it does not exist to begin with...
Sub logs()
CR = Chr$(rcCR)
on error resume next
kill "C:\ EVDO Test Logs.xls"
on error goto 0
Session.PrintToFile = "C:\EVDO Test Logs.xls"
Started 6 days, 3 hours ago (2009-12-23 15:47:00)
by ronbowalker
What is the best way to do this project?
I have been slowly learning a lot of things from this website, and now I am creating a game simulator program in Excel 2003. I would like to keep this "game" device small as possible and also have a touchscreen. Is there anyone that has any suggestions as to what PDA, Laptop, Touchscreen, CPU...
Started 6 days, 16 hours ago (2009-12-23 02:01:00)
by Macropod
To include nested tables:
Code:
Sub Test()
Dim oTbl As Table, oCell As Cell, i As Integer
With ActiveDocument
i = .Tables.Count
For Each oTbl In .Tables
For Each oCell In oTbl.Range.Cells
i = i + oCell.Tables.Count
Next
Next
End With
MsgBox "This document contains " & i & " Table(s)."
End Sub
Note: this code will not find tables in headers, footers, ...
Started 1 week, 1 day ago (2009-12-21 06:59:00)
by chequer
HTML Maker
How do I downloads & install Colo's HTML maker?
__________________
chequer
When the game is over. the King and the pawn share the same box.
Started 1 week, 1 day ago (2009-12-20 21:47:00)
by haider378
Olap
What is OLAP in Pivot table.
How I can use it?
Started 1 week, 4 days ago (2009-12-18 03:16:00)
by SydneyGeek
Quote:
Originally Posted by faanalyst
does anyone have any suggestions for budget planning software?
I use Excel. What you do will depend on complexity; if multiple people will be submitting budgets for their sections I generally push the data up to Access, where I slice and dice it and push consolidated...
|
|
Hot threads for last week on General Excel Discussion & Other Questions::
Started 6 days, 12 hours ago (2009-12-23 06:36:00)
by irfananeeza
Question on VBA products
Hello Excel Team,
I am interested in self teaching VBA. I am looking to buy some kind of visual CD/DVD which can help me learn VBA for Excel from the start to finish. I am looking for a method of learning which should be very visual, simple and have easy to follow instructions because I have no prior ...
Started 1 day, 8 hours ago (2009-12-28 10:14:00)
by teylyn
Hi,
insert a section break (next page) at the end of page 3, then a section break (next page) at the end of page 4.
Now you can format the section on page 4 separate from the rest of the document.
does that help?
Started 3 days, 21 hours ago (2009-12-25 21:28:00)
by Greg Truby
If you're talking about what we call a "thumb drive" over here, though I think the proper term is " USB Flash Drive" (a "memory stick" is actually a Sony product) - at least here thumb drives are everywhere. Any office supply store has them, as would any electronics retailer. Street price for 8 GB drives is about $20, most of your 16 GB drives are a little under US$40. Though, AFAIK, none are beer...
Started 1 week, 1 day ago (2009-12-21 06:59:00)
by chequer
HTML Maker
How do I downloads & install Colo's HTML maker?
__________________
chequer
When the game is over. the King and the pawn share the same box.
Started 6 days, 16 hours ago (2009-12-23 02:01:00)
by Macropod
To include nested tables:
Code:
Sub Test()
Dim oTbl As Table, oCell As Cell, i As Integer
With ActiveDocument
i = .Tables.Count
For Each oTbl In .Tables
For Each oCell In oTbl.Range.Cells
i = i + oCell.Tables.Count
Next
Next
End With
MsgBox "This document contains " & i & " Table(s)."
End Sub
Note: this code will not find tables in headers, footers, ...
Started 3 days, 6 hours ago (2009-12-26 12:17:00)
by Tom Schreiner
Just kill the file if it exists... I'm assuming that the file is created if it does not exist to begin with...
Sub logs()
CR = Chr$(rcCR)
on error resume next
kill "C:\ EVDO Test Logs.xls"
on error goto 0
Session.PrintToFile = "C:\EVDO Test Logs.xls"
Started 1 week, 1 day ago (2009-12-20 21:47:00)
by haider378
Olap
What is OLAP in Pivot table.
How I can use it?
Started 6 days, 3 hours ago (2009-12-23 15:47:00)
by ronbowalker
What is the best way to do this project?
I have been slowly learning a lot of things from this website, and now I am creating a game simulator program in Excel 2003. I would like to keep this "game" device small as possible and also have a touchscreen. Is there anyone that has any suggestions as to what PDA, Laptop, Touchscreen, CPU...
|
|
Size: 1,664 bytes
