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
Help condensing 2 step process by Living the Dream
Hi All I managed to do this in a 2 part code, but was hoping to condense it into 1. Here is my original 2 step process: The following stored the...
Today 04:57 PM
by GS[_6_] Go to last post
6 187
Formatting multiple sheets within workbook. by Living the Dream
Hi Team Workbook has anywhere from 30 to 40 sheets at any given time, of which approx that 25 - 30 require formatting. As there are sheets that cannot be...
Today 04:48 PM
by GS[_6_] Go to last post
6 41
A simple way to crack VBA password in Excel file by [email protected]
Unbelivibale, but I found a very simple way that really works! Do the follwoing: 1. Create a new simple excel file. 2. In the VBA part, set a simple password...
(Multi-page thread 1 2 3)
20 1,015
Array list writing to an Array of 'scattered cells' ? by L. Howard
How to copy F1:F5 values to a range of scattered cells. And, can you copy a range of scattered cells to another unlike range of scattered...
(Multi-page thread 1 2 3)
Yesterday 05:49 PM
by GS[_6_] Go to last post
24 297
Lightbulb
1 Attachment(s) need help with this send email micro by eltyar
Dear All, kindly i need help with my excel sheet attached i made it to send mails directly to my customers but when hit the button it just display to send for...
Yesterday 11:17 AM
by Living the Dream Go to last post
2 95
How can we paste data on Google.com by Vipul Purohit
Hi FOlks I have successfully copied the range and opened the internet explorer and unable to paste it in google.com here is code.. I am quite new with VBA, I...
Yesterday 09:43 AM
by Vipul Purohit Go to last post
0 47
use chrome as ie by sal21
Possible to use Chrome as IE Object? im' usign Chrome (is my default browser) to navigate in inetrnet. With VBA is possible to interact with Chrome, for...
March 22nd 17 07:44 PM
by Adrian Caspersz Go to last post
1 80
Intersect operation by Walter Briscoe
I hope readers here can help. I am having trouble developing an array formula in a worksheet. Once I have the appropriate symbols, I would like to run...
March 22nd 17 11:25 AM
by Walter Briscoe Go to last post
1 59
I need help getting spreadsheet names from closed file using ADODBwith tab order by Ahmed A
I am able to successfully connect and query specific sheets. Some files I am dealing with may have the first spreadsheet name different or changing and...
March 19th 17 11:41 AM
by GS[_6_] Go to last post
2 106
how to use ADO to get sheets from closed file and the excel tab order(figured out with DAO) by Ahmed A
This is what I built the other day with DAO but I still want to figure out ADO... Public Function GetSheets(ByVal FileToOpen As String, ByVal FileExt As...
March 19th 17 10:48 AM
by Ahmed A Go to last post
0 57
help with loop code by eltyar
please how can i say in this code... do it when you see "ok" in cells of column "P" and if any empty cells ignore it and continue? this is the Code: I = I +...
March 16th 17 06:43 AM
by eltyar Go to last post
2 156
Help with Counting Multiple Criterias by Munster
Hello, I am in need of a formula that will count how many times baseball was played and won. I keep Value errors and N/A errors when I try formulas like...
2 92
Rename files with VBA by michelle439731
Afternoon, I want to rename some files in a folder using vba. Preferable what I would like to do is a)find file x in folder a b)rename file x to xy Please...
March 14th 17 02:30 PM
by TIMOTHY Go to last post
9 252
Customized Inventory Software Required in Excel VBA by Hitesh Kr. Aoul
Hello, I need a help to make a customized Inventory software for our newly setup business, In which we required 2 login id's, 1. is for Local User and other...
March 7th 17 11:34 AM
by Auric__ Go to last post
1 235
Syntax for Cell type by Tim Childs[_10_]
Hi In VBA I want to get the cell information on a cell e.g. in the Application itself, I can put: =CELL("type",A1) in Cell B1 However, I would like to...
March 5th 17 09:36 PM
by Peter T[_7_] Go to last post
8 242
VBA- Finding texts built from regex patterns by stainless[_2_]
I need to recognise patterns in text starting with a specific variable text value and ending in 0-3 numeric values. For example:
March 5th 17 06:57 AM
by Claus Busch Go to last post
3 130
Angry
Excel Help!! by hayley_n2008
How would I write an excel formula using the following conditions? I keep getting an error message and I dont know what I am doing wrong Buy if the stock...
March 2nd 17 05:09 AM
by isabelle Go to last post
2 156
Delimiter(?) by GARYWC
How can I separate data preceded by '<<' (without the quotes) into different columns? Here's sample of my text file: << NOT a relative>> << Anyone...
February 26th 17 11:35 PM
by GS[_6_] Go to last post
4 197
Excel export to Outlook:- Missing Microsoft Outlook 16.0 object library by [email protected]
Help please! Using assistance from online resources I have VBA to create an Outlook contact from an Excel spreadsheet. I was told the machines it was to work...
(Multi-page thread 1 2)
February 25th 17 08:30 PM
by GS[_6_] Go to last post
10 263
separating text and numbers into different columns by Paul Doucette
If I have sv14 in a cell, is there a formula I can use to copy the text characters into one column and the number into another? The number of text characters...
February 21st 17 05:03 AM
by isabelle Go to last post
1 139
Post New Thread


Display Options
Showing threads 1 to 20 of 174024
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 09:56 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.