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 / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Simpler Macro17 Apr 2007 20:09 GMT7
Good Morning,
I currently have two separte macros but I'm trying to combine them but it's
going to require some different commands.  What I need it to do is something
like this: start off we are in Summaryworkbook now if there is INV in column
error handling message help17 Apr 2007 20:04 GMT1
I have a macro which enables users to import values into a master log.  Each
row inserted into the master log has a unique date.  
Question:
I'd like to add some code in which Excel loops through the existing rows in
preventing addIn opening in second instance of Excel?17 Apr 2007 19:52 GMT3
I have an AddIn into which are written a few small details before
close (I know this isn't great practice but it saves me having to
setup a log file external to the AddIn and the attendant risk that
this will be deleted)
Protected project17 Apr 2007 19:44 GMT2
Is there a way to unlock a password-protected VBAProject for a lost password?
Automaton error/Unspecified error17 Apr 2007 19:16 GMT1
I am running a program that takes data from excel files found in a specific
folder and uploads certain data to Oracle.  About two thirds of the way
through I get an automation/unspecified error.  Does anyone know possibly
why?  Checked data type and data in the file the error ...
Date Issue17 Apr 2007 18:14 GMT1
I use this formula to pull specific rows out of a master sheet and sum their
totals.  In this instance, all rows for the month of January:
=SUMPRODUCT(--('Daily Reading Master
Log'!B3:B400>=DATEVALUE("01/01")),--('Daily Reading Master
MSXML2.XMLHTTP Works with IE6, IE6 SP 1 but not with IE6 SP 2 - wh17 Apr 2007 18:12 GMT1
i hope someone can give me some much needed insight into this bug. i have
been using:
Set objHTTP = CreateObject("MSXML2.XMLHTTP")
for the longest time and it has never let me down - until recently when i
Putting woirksheet name into a variable17 Apr 2007 18:01 GMT3
I have a form where a new sheet is created in a workbook. Everytime a sheet
is created it incraments up (sheet1, sheet2, sheet3, sheet4). I was tring to
put the active sheet name into a varable but I do not know the syntax.
Open File - Need an warning to appear if file cannnot be found17 Apr 2007 17:56 GMT3
I was wondering how i would go about adding a warning message that says "File
cannot be found" to the following code if the the test.xls file cannot be
found?
Sub filefile
Selecting the first blank cell in a column17 Apr 2007 17:41 GMT1
I am tring to program in excel and I am having a hard time selecting the
first blank cell in a column. There is data throughout and i want the first
blank cell to be slected. I have tried using the Ctrl down... Can someone
help me out... I know its simple but I am just getting ...
excel formula and vba17 Apr 2007 17:28 GMT4
I have this formula in cell:
=SUM(C12:L12)/((COUNTIF(C12:L12,">=0"))*24)
I need to be able to "convert" this to vba code.  
??
function tweak?17 Apr 2007 17:18 GMT5
I use the following SumProduct formula to search for all values in a
specified date range, in this case, for all values in january, then sum those
values which fall into that date range:
=SUMPRODUCT(--('Daily Reading Master
Hide Cell contents17 Apr 2007 16:37 GMT1
Is there any way to hide / protect  the contents of a cell so a user cannot
see it at all.  I need to enter a file path into a cell (for later use in
another macro).  We need to hide the path from users so they can't navigate
to this path.  
Run Time Error 1004: Application-Defined or Object-Defined Error17 Apr 2007 16:21 GMT6
Hello again! Here is my beautiful code revisited, hoping to get a
touch of assistance from one of you wonderful Excel VBA experts! I'm
getting the error at the "Set oQt" line. Thanks in advance for any
help!
FTP a file to UNIX server using Excel Macro17 Apr 2007 16:12 GMT1
i have a requirement where in i have to code a macro in excel which
will FTP a file to UNIX server.
i am new to working in excel macro's. Could anyone please tell me how
do i approach it and if possible possible solution
 
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.