Get sheet name in any workbook
I would like to get the name of the first sheet in any workbook that an user
Is this possible?
I've tried wb.sheets(1).name. Doesn't work.
Here is one way right out of VBA help file.
For Each sh In Workbooks("BOOK1.XLS").Windows(1).SelectedSheets
If sh.Name = "Sheet1" Then
MsgBox "Sheet1 is selected"
You can also try: ActiveSheet.Name
"OffDev" <OffDev@discussions.microsoft.com> wrote in message
news:FD3B763A-B020-48BB-A6CA...where can I get a template for excel to track vending machine tak.
where can I get a template for excel to track vending machine tak...
...Make a living taking surveys. Absolutely free list of paid online surveys.
No sign up or fee required. These paid survey and secret shopper lists
are free! Stop paying $35.00 or more for free information. Start
earning money for shopping and taking surveys today.
...How to prevent other apps. from getting focus?
The WebICQ applet gains focus everytime a message comes,
it's extremely disturbing expecially when I am typing.
I want to write a VC++ utility to stop any (background)
app from gaining focus. I have no idea on how to do so
yet. Could anyone let me know if there is any online
material about how "Window Focus" work, or give me some
hints on the programming.
Thank you in advance!
...trying to get day/month/year froamt while user enters year only
I am trying to get the end user to enter the year in question and then have
the document return values in column A in dd/mmm/yyyy format and column B
in Day of week format for all days in that year
You would just use something like
copied down, but I am not clear where the year number is stored, and when
the flip to column B happens.
(replace somewhere in email address with gmail if mailing direct)
"RADIOOZ" <RADIOOZ@discussions.microsoft.com> wrote in message
> I ...How do I get the current ROW location.
Trying to find out the current row location.
Tried startRow = cell("row")
Tried startRow = ActiveCell.rows.address() - But this returns the column and
row in $A$1 format.
I just want startRow = CurrentRow (or something like this).
startrow = activecell.row
"Craig & Co." <email@example.com> wrote in message
> Trying to find out the current row location.
> Tried startRow = cell("row")
> Tried startRow = ActiveCell.rows...Getting error with Sample Quote Report in SQL 2000
I have downloaded the "quote, order, Invoice sample report" from
www.gotdotnet.com/codegallery. The reports work fine on my VM (latest
version) with SQL 2005 but it gives a SQL error on another VM with SQL
2000 SP 4. Normal built in reports work fine in this VM. Has anyone
tried these sample reports on SQL 2000. I am desparately trying to
resolve this issue. Our client wants a custom quote in their
application and they are using SBE with SQL 2000.
We have resolved this issue.
We had this problem since we tried to modify the quote report on our
local machine using the ...How to get the Range the Graph builds upon?
I have tried and tried to get the first and last cell from the Range the Graph/Chart is built upon without any luck.
Can I do that from code?
I´m using Excel 2000 Pro
See John Walkenbach's http://j-walk.com/ss/excel/tips/tip83.htm
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <A9F5681D-C6F9-42F8-8BD0-02E090915102@microsoft.com>,=20
> I have tried and tried to get the first an...How to get Bills and Budget to synch?
I have Money '07 and I'm using it to try to set up a budget. Problem is,
it's a little cumbersome to have to go in and retype each category and amount
for things such as rent, gas, cell phone charges, etc. when all of that
information is currently in the Bills section. Is there a way to get the
budget to grab all of those non-variable values and use them so the only
thing I have to manually budget is what's left over?
Also, it doesn't seem like the cash flow forecaster (not sure if that's what
it's called) is considering my budget items - only the items und...Mails doesn't get received into INBOX
A user has several smtp address for his mailbox (6-8).when we send mail to
primary address the user doesnot receive the mail, but when we send mail to
his other SMTP addresses the user receives the mail.
Any troubleshooting tips ???
Thanks in advance.
- What happens to the messages sent to the primary address?
- Check SMTP log and Message Tracking to figure out.
- Does the sender get a NDR?
- Try sending a message (to the user's primary address) by telnetting to
server's SMTP port - does it accept the message?
MVP - Exchange
NEW blog ...Reliable way to get window underneath mine?
What is a reliable way to get the window underneath mine?
Say that my window is "Window A"... "Window A" is being dragged around the
screen by its title bar. The mouse cursor is at x,y. I need to know if I can
drop it on the window thats at x,y (not counting "Window A"). So I need to
get this window handle somehow. WindowFromPoint() obviously gets "Window A".
I'd rather not enumerate all the windows since that seems like a performance
> What is a reliable way to get the window underneath mine?
> Say tha...how do I get the check mark to appear in the box I have placed
How do I get the check mark to appear in the box I have placed on my spread
i.e for reply, urgent, for review
What type of "Box" have you created?
What checkmark is it?
Gord Dibben MS Excel MVP
On Wed, 4 Jun 2008 14:41:19 -0700, Dawn <Dawn@discussions.microsoft.com> wrote:
>How do I get the check mark to appear in the box I have placed on my spread
>i.e for reply, urgent, for review
I would put an X in a cell.
> How do I get the check mark to appear in the box I have placed on my spread
> i.e for reply, urgent...How do I get the printer to start at a spicific page.
Sometimes when printing pages for a 100 page book a page may jam. I try to
start printing from that page to the end. It always wants to start from the
first page instead of the 20th page. How do I get the printer to start
printing from that page that was jammed and continue?
> Sometimes when printing pages for a 100 page book a page may jam. I
> try to start printing from that page to the end. It always wants to
> start from the first page instead of the 20th page. How do I get
> the printer to start printing from that page that was jammed and...Cannot Get Email
I haven't been able to get on my Outlook Express email for weeks.
This keeps popping up in the "send/recieve" bar.
The connection to the server has failed. Account: 'shawmail', Server:
'127.0.0.1', Protocol: SMTP, Port: 5101, Secure(SSL): No, Socket Error:
10061, Error Number: 0x800CCC0E
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.window...Is it possible to get back deleted emails?
A few weeks ago I replied to an email I'd received I then
inadvertently deleted my reply from the Sent Items folder. I also
empty my deleted items folder quite often.
Is there anyway that I can retrieve my reply?
not unless you make the attempt as soon as you emptied the deleted folder.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http...How to get cell value with the ID from a fomula?
How to get the value from cell of colume A and raw "C3+4", and input to B2? I
mean the fomula inputted in cell B2. Thanks.
I am not sure what you mean but maybe this will help
> How to get the value from cell of colume A and raw "C3+4", and input to B2? I
> mean the fomula inputted in cell B2. Thanks.
...can I get my addresses from Hotmail into MSN Outlook w/o retyping
I just found out that I have to use Outlook in my envelope on the toolbar --
can I change this to hotmail and how do I do it -- and can I import my
address book from hotmail somehow??
try using Live mail, & then export, & import in Outlook
"Pat" <Pat@discussions.microsoft.com> wrote in message
> I just found out that I have to use Outlook in my envelope on the
> toolbar --
> can I change this to hotmail and how do I do it -- and can I import my
> address book from hotmail someho...Help! My arrows have fallen and can't get up!
Suddenly, the arrows (either up, down, right or left)
won't move from the cell that's highlighted to another
cell . Now they move the entire worksheet. How can I
reset the arrows to move to adjacent cells? Any help
would be appreciated. Thanks, jan
you probably have clicked the SCROLLLOCK key. Simply click again on
"jan" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Suddenly, the arrows (either up, down, right or left)
> won't move f...How do I get my words to go vertically in Excel?
I am not sure how to get my words to go vertically on top on my spreadsheet
>I am not sure how to get my words to go vertically on top on my spreadsheet
Select all the cells you want to edit, right click and select "Format Cells",
then choose the "Alignment" Tab. from there you can set the orientation of
the text to whatever degree you desire.
Message posted via OfficeKB.com
What do you mean by *go verically* ? do you mean like
If so pr...ver 1.2 is now available at MSDN download site.
Was put up there last night.
Downloaded not working here
"Don" <email@example.com> wrote in message
> Was put up there last night.
It wasn't working at the start but it is working now.
"taja" <firstname.lastname@example.org> wrote in message
> Downloaded not working here
> "Don" <email@example.com> wrote in message
> > Was put up the...MAKE ALL IT CERTIFICATIONS
MAKE ALL IT CERTIFICATIONS - A PIECE OF CAKE
Now all IT Certifications like MCSE, MCTS, MBS, SCJB, A+, CCIE,
CCNA, CCNP, Oracle 10g 9i, IBM, HP, Vmware and many more are made a
Piece of Cake. Visit Now http://www.FreeExamKing.com and become an IT
Certified in first attempt.
...How do I get folders to stay in the favorite folders in outlook?
When I right click on a folder and click on Add to Favorite Folder the folder
gets copied to the Favorite Folders section of the Outlook Mail display.
However everytime I close Outlook and reopen it, the folders I added are gone.
Any ideas how I can make them stay there?
Thanks in advance for any assistance you can provide.
...Hep Requested: Getting Started Again
I've recently had to rebuild my PC as a result of which I've
reinstalled Visual Studio 2008 and finally reinstalled the CRM SDK.
However when I attempt to start a new Workflow project I'm having some
I've added references to Microsoft.Crm.Sdk and
Microsoft.Crm.SdkTypeProxy to my project, however when I attempt to
declare these in my classes:
It's as if I havn't added the references.
Can anyone refresh my memory as to what I need to do in order to get
my environment back up and working because at the moment I'm at a dead
I have cobbled together the following code which is triggered by an incoming e-mail event.
It is supposed to automatically add a category to the e-mail (which is the domain name of the sender e-mail).
The script all executes okay, and it appears to be trying to add the right category.
But no categories actually get added.
Any help gratefully received
Running Outlook 2003, exchange server.
PS. Tried this post on different forum and got no responses at all. Hopefully you lot on here are a bit better!
------------------------------------------------------...Windows Explorer: How to get it to expand like I want?
WinXP Pro SP3
When in Windows Explorer, I expand a folders branch using the + sign
next to the folders name in the Folders pane. Then I do this to
another folders branch using the same technique. I want them both to
remain expanded, but when I click on one of the folders in the branch,
the other branch closes. I want them both to remain open while I
inspect the contents of one of the branch's folders.
Is there a way to make it do what I want?
Question is what caused this to change? What you ask for is normal
behavior. Perhaps you can System Restore to time before it b...