I want to calculate 48 working hours from a start date taking into consideration
that my workday starts at 9.30 am ,there is a break of 1hr and ends at 6.00 pm .SUnday is the only weekend
Hi,
I know there are different ways to split up addresses but I'm not sure how this one works exactly. I have an address in the following format:
111 Main St: Rogers AR: 72756
I just ne...
I use excel 2007.
I can do it an a single cell but I can't seem to apply to the four that I want. Do I have to create a rule for each cell? Can I drag the formula..
I am looking to res...
Hello!
I have the effect, that Excel crashes, when I use the scroll function of the mouse in a list field in designer mode.
It's Excel 2003, SP3.
Has anyone an idea about this effect? O...
Hi X-perts,
I am building an installation package for a VBA and VB.NET linked application.
1) My VBA code includes a reference to a test.xla file located in the same dir as the main wor...
using Excel VBA, and the InternetExplorer.Application object, keeping ie invisible, I can navigate to a page and access the text on the page. But there's a button on the page that I need to p...
Hi Experts,
Ok, I'm going a little nuts here. I've got code that pulls data from several closed workbooks in a designated folder off the C:\ drive and have all that working well. Where I'...
Dear experts,
I have the following VBA code, which tests the connection to an Essbase server, after asking the user for input on server name, database name, username and password. I want to...
I have an Excel workbook with a worksheet called AllWells, where column B is WellNumbers & column D is WellNames. There are multiple records for each well. I am developing a Form for the user ...
i am creating a text file, extracting data from a database using SQL. Each "record" created in the extract becomes several lines in Excel and Access when importing the data. My question is, ...
I am trying to have a macro that prepares an email with the active excel sheet as the message body and have the email addressed as well. Any idea on how to do this?
Hi EE,
In the event a particular cell is blank. Can we make it blink in a specific color? Can you please provide an excel File?
Thanks,
JP
Hello guys!
I need your help with this one ASAP. I wrote an Excel macro that pulls data from a bunch of files in one directory into one new file. The data I am pulling is from specific c...
need to create a macro that will allow me to 1) unprotect a worksheet; 2) choose a specific cell (different each time) and then choose a range of rows; 3) delete the rows; 4) reprotect the wor...
Hello, I have a shipping table that I export from Mysql which has the data encapsulated in quotes, I then open it in excel change the values and save it as a csv but I lose the quotes and i ca...
This is a tough question but I am a premium member and will give max points for a solution.
Can anyone tell me how to insert an Excel sreadsheet into a Powerpoint slide.
I have Just ha...
Hi,
I have an excel file that won't open on a particular machine.When I try to open it I get the message File Error: Data may be lost and Excel crashes.
I can open the file on another ma...
Hi,
I have the attached spreadsheet that contains data in columns B to K Merged depending on how many products a customer has buyed.
I.E. Mr John has purchased three different products.....
I have two workbooks - which (for some worksheets) share the same worksheet names.
For simplicity I will call the sheets - sheet1, sheet2 etc.
Within workbook1 - sheet1 has formulas that inv...
=COUNT(N16:N153)
is it possible to adapt this formula so that it ignors cells that are blank, but contain a formula?
pete
I am downloading Bloomberg static (not real-time) data into a Sheet in a workbook; also in the workbook is VBA Code in: 'ThisWorkbook' module; a regular module; and a class module (contains a...
Hi EE,
a) Rory generously gave me code in this recent post and that WarCrimes has been a big help in understanding the code....
=========================================================
htt...
I just need to compare 2 rows in excel.
Basically, if the current row is the same as the row above it, then delete it.
Then move on to the next row.
I have over 10,000 rows to go through.
Hi,
In my excel file, one could see that there are separate sheets that can compute for the gross profit of the items. I have a friend who made a vba code that automatically computes the c...
The code below puts the tabs the but have no Value to each tab, any idea...
