Using VS 2005 and Excel 2007.
I'm building an application that compares the cell values in two separate Excel workbooks. The purpose of the application is to determine if two excel workboo...
I am looking for a VBA snippet that will calculate the number of weeks per month.
If Friday is in the week it counts for that month. Thereby it will always give an answer for a week count of...
I have an escel file I am trying to link into Powerpoint where, once you click the link(which looks like an excel link), the Excel document opens up. Does anyone have any clue on how to do this?
I have a workbook I wrote to assist the sales department in calculating quotes. I was having problems calculating manufacturing times with nested IF statements due to all of the possible comb...
Hi Experts- I need your help again.
I need to know if there's a way to retain filters using vba code after executing a vba query refresh command (MyQuery.Refresh).
I have some MS Excel VBA c...
I need to trim all characters following the "-" in the text in column A, including the space after the "-" if one is present.
For example:
12461 - Dixon would return "Dixon"
2431 ...
I am writing a macro that needs to pull email addresses out of a email hyperlink embedded in one of the workbook's worksheets. I need help writing code that will extract the email addresses ou...
I would like to get the culumative time lapse for running date and time fields in an excel file. The file is a dump of a problem log that contains a cell with the date and another cell with t...
I have a macro which tries to open an excel file from a URL. But before it will load, I need to enter my name and password. The site remembers those, but I still get a popup where I need to ...
Here is the number that I would like to remove the last 4 digits of.
001009348.JTE
I want the cell to be 001009348
Hello,
I have created this workbook for our organization that has all of the data in a sheet called All Data. the first sheet i started creating a look up where they can select the company ...
In column A I have a list of records that are as such,
1A
2A
100A
200A
I would like to add a "K" in front of all the values in column A could you please help me do this with a macro.
Hello -
I have some named ranges that represent business segments which will feed a chart (names A,B,C,and D). There is also a YTD range for the same groups (A_YTD, B_YTD, C_YTD, and D_YTD).
...
I have an application developed in Excel 2003 and when users run it in Excel 2007 the format function is giving an error. Here is the format funtion I used.
format_type = "$###,###,###,##...
I have an Excel Spreadsheet that has columns going across (horizontal). Is there a way to convert these columns to go down the side (vertical)
I have: A B C D E F G H
I ...
Here is a sample of column data from an excel spreadsheet
101298
31098
3398
These are all date fields but have leading zeroes omitted
I'm trying to display them in mm/dd/yy forma...
Hi:
I have a ComboBox, from Control Toolbox, on a worksheet. From a module, I'd like to set the ComboBox to select a default item, which is whatever item on the top of the list. How do I do...
On file open of a *.wk4 file in Excel 2003 I receive :
Run-time error '1004':
You are attempting to open a file type that is blocked by your registry
policy setting
Hello Experts -
I have a spreadsheet that has errors per fiscal week. From this data some stats were derived to make a control chart, mainly Average, Standard Deviation, Upper Control Limit...
Hi Experts,
I have a macro that copies all files in one folder into different sheets in another file. I have used it in various situations and it works great.
Now I am dealing with a ne...
If the active cell in col B is not blank then calculate the concat formula in the corresponding cell in col C.
If the active cell in col B = blank, then stop filling down the formula in col ...
I make monthly line graphs of business activity going back about 6 years. I want to have vertical grids only every year on January. I am unable to figure out what they mean by major and minor ...
Desperately seeking a piece of VBA to do the following (tried looking for the answer but don't understand VBA so not sure if any similar examples found on this site would do what I need).
O...
Hi there,
Wonder if anyone can help me. I trying to do a calculation on SLA date and time. I have the following coloumns: Start Date, Start Time, End Date, End Time. I need to find out t...
I have a form that has 3 option groups on a page labeled 1 (combo), 2 (seats only) and 3 (backs only). Each group has multiple option buttons and only one button can only select in each group....
