Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
question about FindWindow API call30 Mar 2008 15:55 GMT2
Is FindWindow a reliable way to determine if a particular application
is currently running?
I had been using Tasklist.exe to do this, but this program does not
appear to be present on Windows XP Home systems.
Pause Printing in VBA30 Mar 2008 10:48 GMT2
:) Hello!!
                I have written a Macro in VBA to print Invoices with data
from an Excel Worksheet. But I have about 250 Bills to print. Could someone
tell me how I can include a few more lines of code in my Macro  that will
Autoreference Code30 Mar 2008 08:49 GMT2
I have a sheet with a code. I would like to make multiple copies of
this sheet, Is there a way to make the code change references
automatically?
for example:
Help with the report needed30 Mar 2008 08:39 GMT1
I've got to get an urgent report ready for my teaching and I'm stuck.
Here's what I have to do:
Report sheet
1. create a combo box displaying subjects listed A1:A150 on the "my data
What can inhibit an event handler?30 Mar 2008 01:32 GMT3
XL2003 on XP
In one instance of Excel, I had two files open and then opened a third file
that has a macro that should fire on workbook_open.  For some reason, this
macro did not run.  I closed the third file and tried this twice more with no
"ComboBox1.ListIndex = 0" Doesn't seem to always work.30 Mar 2008 01:28 GMT2
I have "ComboBox1" on a UserForm. In the Sub Form Initialize procedure, I  
have "ComboBox1.ListIndex = 0" hoping to set the ComboBox to Index 0 every
time the Form is loaded. The problem is that maybe 50% of the time it loads
up with the last selection instead. Am I doing ...
Help with Calender Day colour30 Mar 2008 01:00 GMT2
Hi, I have an activeX calender embedded in my worksheet what I am trying to
acheive is to get each wednesday of the month to shade to a different colour
so that they standout.  
If you can help I would be grateful many thanks Joel
Excel automation: Why my code is hijacked?30 Mar 2008 00:24 GMT12
I have this routine to disconnect from Excel:
Public Sub XLDisconnectFromExcel()
   If Not moExcelWS Is Nothing Then Set moExcelWS = Nothing
   If Not moExcelApp Is Nothing Then Set moExcelApp = Nothing
Excel columns: Converting numbers to letters and vice versa29 Mar 2008 22:17 GMT15
         My app is using Excel spreadsheet.
User has a choice of preselecting some of the sheet's columns.
Now:
Excel is using letters as the visual  indexing, of the columns but when
Variable within a formula29 Mar 2008 21:55 GMT9
I would like to set a formala in a cell that would vary based on the value
of an another cell.
The end result should look like: ='040208'!A1+C4 with 040208 being the value
of the cell in question.
vba; copy row, paste at offset29 Mar 2008 20:44 GMT2
I have a row copied to the clipboard, and I want to paste it into
sheetB at rowR, colC.
I can do the paste if I select the entire row, but that's now what I
want.  Thank you.
Invoice Numbering29 Mar 2008 19:01 GMT8
I am creating a template for invoices. I want it to automatically fill
in the invoice number in cell C5 each time I open it, just one number
higher than the last one. I also want it to automatically save to a
folder on my desktop called "Invoices". How can I do this with VB?
Excel 2003 automated instead of Excel 200729 Mar 2008 16:57 GMT3
I have Excel 2003 and 2007 installed on the same machine.
I'm trying to automate Excel 2007, but everything I seem to do ends up in
Excel 2003.
I have a file (XLSX) which was made in Excel 2007 and I'm trying to open it
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht29 Mar 2008 16:25 GMT11
Sorry, I'm posting this query again as there was an OE error received just
now
----------------
In a sheet: Z
Query with Excel VBA Find Method29 Mar 2008 13:35 GMT5
I have the following code that searches for a particular string in
column K and repeats the process until all have been found (or that's
what I intended).
In one workbook, the first instance is found at K330 with the next 8
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.