A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
File cannot be accessed by [email protected]
Hi I have a macro that sequentially opens data files (csv data in .rnd files), copies data to the main workbook, then closes the file. This normally works well...
(Multi-page thread 1 2)
11 1,342
Claus by Paul Doucette
Happy Birthday!!! :-)
December 17th 16 04:34 PM
by Paul Doucette Go to last post
2 581
select case help by Matthew Dyer
in this case my case is a string (see what I did there???) I want to test if case contains substrings but am coming up blank. logic im trying to...
December 14th 16 06:26 PM
by Claus Busch Go to last post
2 452
FreezePanes is a window property by Walter Briscoe
I run Excel 2003. I have a particular workbook, consisting of 3 sheets. Sometimes, I save it with one displayed sheet and sometimes with more than one. Each...
December 11th 16 12:42 AM
by GS[_6_] Go to last post
9 572
close a pdf file opened via shellexecute by Matthew Dyer
I am using the following code to open a pdf file. Private Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hwnd As Long,...
December 10th 16 06:07 AM
by GS[_6_] Go to last post
4 436
data connection table date help by Matthew Dyer
I have data connection pulling a SQL query, I am using: CONVERT(VARCHAR(10), TASK_DATE_CREATED, 101) AS to create the Task Orig Date field. However, this is...
December 8th 16 09:32 AM
by Sandytran144 Go to last post
2 482
SQL help? group? anything? by Matthew Dyer
So I'm starting to expand my 'data' knowledge into relational databases and wondering if there's a google group out there similar to you'se guys. the ones I've...
December 7th 16 08:26 AM
by Luannguyen992 Go to last post
4 455
User-defined type not defined by Walter Briscoe
In another thread, today, I mentioned Regular Expressions. The subject of my posting is an XL 2003 Compile error. I regularly find people mention user-defined...
December 1st 16 12:07 AM
by Peter T[_7_] Go to last post
5 560
replace() funciton with multiple tests.... by Matthew Dyer
so basically I'm looking to do the following, which obv doesn't work... Replace(string, Or("purge_", "dealdrop_"), "cor010_wcout") I've tried Replace(string,...
November 29th 16 03:35 PM
by Walter Briscoe Go to last post
3 544
Insert 5 Row if a Certain Value in Column A Q by [email protected]
I want to insert 5 blank rows, above the first time 10000 appears in Column A Then Subtotal Column E & F (from Row 9 down) on the 2nd Row of the inserted...
(Multi-page thread 1 2)
November 29th 16 05:50 AM
by Tvlebung396 Go to last post
12 995
Generating a list of all possible number/letter combinations by orion
I have to generate a list of all possible letter/number combinations of the form _ _ _. There are no restrictions, it can start with a letter, or a number,...
November 27th 16 10:36 PM
by clemmi Go to last post
4 1,779
Out of Memory by Walter Briscoe
I have just worked around a problem. It seems friendly to report my experience. I use Excel 2003 and most of my code is in PERSONAL.XLS. I had created a new...
(Multi-page thread 1 2)
November 27th 16 03:00 AM
by PhunuSEO Go to last post
12 1,005
Select rows that are 'blinking' by [email protected]
Hello, Small question :). As part of a module some field/records are 'selected' and they are 'blinking' (flashing) because they are not realy selected as...
November 26th 16 08:01 PM
by Claus Busch Go to last post
6 586
MsgBox if within selected rows a specific column is not filled in by [email protected]
Hello, If somebody can help me :) In a sheet several rows are selected. It could be rows near eachother (like row 5 till 15) or even rows that are not near...
4 556
sheet specific desktop shortcut by Paul Doucette
G\Is it possible to have a desktop shortcut open an excel file and go to a specific worksheet, even if the file was saved with a different sheet selected? I...
November 25th 16 05:44 PM
by Paul Doucette Go to last post
4 576
posting this here cuz the outlook programing group is very inactive... by Matthew Dyer
hopefully with how active you guys are you can help! I apologize in advance for posting an outlook vba question in an excel vba group. I've got this loop...
(Multi-page thread 1 2)
November 24th 16 06:05 AM
by PhunuSEO Go to last post
13 922
Compare 2 Lists and Take an Action Q by [email protected]
I have 2 Lists of Data on the same sheet List A is detailed in Columns A-D List B is detailed in Column G-K What I want to do is compare certain...
(Multi-page thread 1 2 3 ... Last Page)
November 22nd 16 09:36 PM
by Claus Busch Go to last post
31 1,536
Count and report the number of red colored cells in a row by [email protected]
Hello, I like to get a module which gives me the number of background red colored cells within each row (a loop) Row 2 till last The number of red colored...
3 647
Sheet names in a drop down by L. Howard
With sheet names in a drop down in Cell A2 what is the generic With Sheets("Sheet name in Drop Down") 'Do stuff End With and Set Rng = Sheets("Sheet name...
November 19th 16 09:33 AM
by bulong Go to last post
5 619
Fill Cell with Colour if Q by [email protected]
Is there VBA code that will fill a cell with a certain colour, say yellow, if another cell = value of any one of 5,6,100,175,101 etc I have the array list in...
November 19th 16 09:32 AM
by bulong Go to last post
6 619
Post New Thread


Display Options
Showing threads 61 to 80 of 174039
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.