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
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...
2 37
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...
February 22nd 17 12:05 AM
by GS[_6_] Go to last post
2 62
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 06:03 AM
by isabelle Go to last post
1 40
Create an array based on the subroutines in a module by Matthew Dyer
here's an interesting thing... I have multiple closely related but specifically individual subroutines clustered in one module (Verbiage). I know that there is...
February 16th 17 04:25 PM
by GS[_6_] Go to last post
5 136
Controlling xlTiled windows arrangement by Walter Briscoe
I have a new machine using xl2007 on Windows 10. I believe what I have observed also applies to xl2003 on Vista, but have not tested it I have windows with...
February 14th 17 01:15 PM
by Walter Briscoe Go to last post
0 83
Several issues by [email protected]
All, I want to create a macro that first opens a dialog box where the user can select a worksheet to open from their documents. To be more specific, I want...
February 11th 17 04:08 PM
by gioinguyen372 Go to last post
4 171
2 Attachment(s) Formula to extract certain texts by ecdlc888
Good day.I need help to extract certain texts in column A to place to columns B,C and D as in the attached file. Those are the ID, azimuth and distance...
February 8th 17 12:05 AM
by ecdlc888 Go to last post
3 192
Simple alpha numeric sorting by [email protected]
Hi all, I have absolutely NO experience with excel, and I am trying to sort lot numbers which are followed by a letter; eg: 1B 5B 19B 45B 190B 247B 560B
February 6th 17 01:15 AM
by Claus Busch Go to last post
1 131
Comparing two columns in different sheets by [email protected]
In Sheet1 I have peoples names and addresses. Names in column A, and addresses in B-column like this: Mystreet 23, 2.th. Your Street 5, aptm. 345 Carl Bark...
9 229
Change event for all sheets in WBook by L. Howard
This works to hide/unhide for only the activesheet. I need if I enter CS or SA on ANY sheet cell H8, then ALL sheets hide for that case, regardless what the...
February 3rd 17 10:02 AM
by L. Howard Go to last post
5 103
Populating Publisher document from Excel using VBA by Junk Yard
I was asked to use Excel to collect data for our team and then create a summary report in Publisher using VBA and I would love some help. Basically, I need...
February 2nd 17 12:07 AM
by GS[_6_] Go to last post
7 210
close adobe reader window by Matthew Dyer
I'm running the following script to combine multiple pdf files into one using PDFCreator. The problem is when you get to the part where the files are loaded...
January 30th 17 11:09 PM
by GS[_6_] Go to last post
2 145
Running Word to Save as PDF by Matthew Dyer
I am obviously doing something wrong... I am trying desperately to avoid having to activate the Microsoft Word XXXX Object Library as this may possibly be used...
(Multi-page thread 1 2)
January 27th 17 12:25 AM
by GS[_6_] Go to last post
13 252
Change the Values in a Column to 'Minus' If Q by Sean[_17_]
I have 8 columns. My values are in Column 7. These are all 'Positive' values, but the detail in Column D indicates if these values are actually negative or...
2 118
Split data in one cell like ALT-Enter by [email protected]
If somebody can help me out :) I have a sheet with several rows. In column D a lot of text is included with separator slash. I need a macro that produce the...
January 22nd 17 03:54 AM
by isabelle Go to last post
3 262
Excel 2007 VBA: Convert laaaaarge number to Hex by nj
Hi, folks, We're trying to get a subroutine working for converting numbers like 37719831058777893 83881713106708998 37156879353577176 37719831058778503 to...
(Multi-page thread 1 2 3 ... Last Page)
January 19th 17 09:38 PM
by Auric__ Go to last post
33 2,121
Can protect worksheet then workbook but not Protect and Share in code by [email protected]
Hi, I am trying to pw-protect the sheet, the pw-protect workbook and the pw-protect sharing in code. I can do this manually in Excel but not in Excel VBA or...
7 392
Web reads - synchronous and asynchronous - long by Walter Briscoe
Last year, Garry pointed me at synchronous XML HTTP read techniques. They are faster than calling Internet Explorer from Excel. Asynchronous access has...
January 11th 17 06:36 PM
by GS[_6_] Go to last post
1 248
grouping cells within a column for a chart by [email protected]
I have many cells in one column that I would like to chart. I would like to group them to make the chart more readable. 49-55 is one group 78-84 is...
0 208
conditional formatting, bleh by Matthew Dyer
trying to use this formula for conditional formatting in column D: =NOT(ISNA(VLOOKUP(D1, SLS_Holidays, 1, FALSE))) where any value in D that is found in...
January 6th 17 02:52 PM
by Matthew Dyer Go to last post
7 227
Post New Thread


Display Options
Showing threads 1 to 20 of 174009
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 01:46 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.