Microsoft Excel Forum

I have a user who was working on an Excel 2007 file from a thumbdrive.. all of a suddem the file will not open and generates the following error: "Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the...

OK first off hello! I am new to these forums and - though I dabbled a bit in Basic when I was younger - new to programming in general. I have searched using Google rather extensively but cannot figure out how to do what I'm attempting...perhaps because I am having a hard time applying programming principles because I am new to macros and VBA. ...

Hello everybody Is it possible to disable the keys Ctrl + Alt + Delete in excel? I searched a lot but found no results which can do that

Hello everybody I have four cells which I need to navigate through using Enter key My range is ("D10:D13") If I was in D10 and press Enter then go to D11 (That's the deafult)>>>> If I was in D13 and Press Enter key I need to go to D10 again As for other cells no change in using Enter key Hope it is clear

Sub datesexcelvba() Dim mydate1 As Date Dim mydate2 As Long Dim datetoday1 As Date Dim datetoday2 As Long Dim x As Long lastrow = Sheets("inspection & test plans").Cells(Rows.Count, 1).End(xlUp).Row

I have written an Excel Macro that opens a website, adds data to textboxes, and "clicks" to next page. This new page has a "link" that opens a new Form when clicked, I tried to Code the "click" to open the new Form automatically, but get a message that "If you leave this page, you will lose your session and be logged out". Right-clicking...

Hey everyone, I’m hoping someone can help. I’m trying to set up a data import from a table in one workbook to one laid out exactly the same in another. However when I try to set up the link for the first time it’s inserting new cells rather than populating the existing table. I know once the data is in I can choose to format data import and choose...

Hi, I am seeking a help from all excel VBA expert. I have attached the excel file for reference. In the "Input" sheet there is production schedule that will be generated on submit button click. And the same schedule will also have to COPIED in "Output" sheet. But I am not able to paste it in desired location (blue highlighted area). ...

I'm working with some data that I have imported from another system, and it has a very strange date format. It seems like everything after 1/1/2000 has the year formated with a letter. For example, 11/04/A0 or 08/04/B6. I have never seen this format before and I'm not sure how to translate this into a date that I can compare. Has anyone else...

I cannot open a excel file as it is giving an error message: "Microsoft office has identified a potential security concern" When i say enable or Disable the file opens and its blank with no data displayed.

Please help me to correct this formula Column K: List of school names (XX-1, XX-2, XX-3, XX-4, XX-5) Column L: List of school Levels (primary, secondary) Column M: List of staff designations working in school XX Find out the TOTAL number of “Principal” and “Vice Principal” working in ONE particular School =countifs((K4:K30, “School...

I have some data which has three values: Pass/Rejected/On Hold, Now I want to save only pass data in Different sheet, but there is one condition, If There is no pass data, It shows msgbox "there is no Pass data", If only one Pass data found, it would save in 'sheet 2' and if more than one Pass Data found, it would save in 'sheet 2'. Please help...

I have three fields of data: 1. CaseID: need to Group by 2. Side: either L or R 3. AcctNum My main Sub: CaptureGrpMacro determines the start(rowStart) and end(rowEnd) rows of each group. The hasLorR function determines if Side is L or R and if so turns flag to True. The Scenario function takes the Scen variable and places in ScenL or ScenR...

I want to append "0" along with cell value if there is no "0" in beaning of cell value. Range of cells are S3:S100 I tried the following logic but it does not work. For Each cell In If cell.value is not null then if left((cell.Value), 1) <> 0 Then cell.Value = "0" & cell.value

Hi i am trying to open a wizard on an excel file (.xlsm) but it fails to start and gives me this error: Microsoft form could not load some objects because they are not available on this machine. how can I solve it?

Hi all, I know that a #Ref! error occurs when the cell that is being referenced in a formula is no longer valid (e.g. deleted) I am trying to make a spreadsheet for my colleague where every month she copies in data from a monthly generated report and the spreadsheet takes the data and pulls out specific information. However, every month she...

Hello there, I am trying to plot 3 variables on one graph (specifically flow rate, pressure and flow path diameter) with the x-axis being measured in units of time. Since these all have different units of measurement and there is only a primary and secondary axis I don't know how to fit them all on one graph or if it is even possible to do...

Please help I have a worksheet I update monthly using Microsoft query. The information is collated and summarised in the attached worksheet. I need a small VBA code Based on a command button to. 1. Request the Month/Year (APR-15) Then using the user input copy the Total value from F9 and copy it to the Cell in D based on the matching...

I took this function from http://www.rondebruin.nl/win/s1/outlook/bmail2.htm It work verywell until I select range that no formating from filtered pivot table (to ensure when I change filter, every data still copied), the table pasted become no formating. so I decided to modify/upgrade the code to suit new demand, when you want to copy...

Hello everybody I have data in Column A .. Inside most of the cells not all I have slash May be one slash or two or three or four I need to remove any space before and after the slash .. Note that the number of spaces are variable .. Example : Hello / Everybody This is /Just example/ to illustrate / my task .

We have a school project which is to create a VBA through Excel and I have problem about coding attempts in Log in. Everytime I open the file and put some incorrect username and password once the message box appears and say that "You have entered an invalid username/password 3 times already" what would I do to make it 3 attempts? Thanks for the...

Hy guys. I'll explain with an example. If cell D2 has any value then cell D2 fills with green else does nothing. Hope you understand. Thanks in advance ;)

Hi all, I have a spreadsheet which has two data sources on. Table 1 has data relating to patients who have been discharged from the wards at the hospital I work at and Table 2 has the list of all the wards at the hospital. I can make a pivot table from table 1 easily however it will only list the wards present in table 1. Some of the wards may...

I am working on a project to download the full list of domains that my home network has been to in a day (or days) from OpenDNS. I have most of this working, but one piece keeps hounding me. I can't activate the newly downloaded CSV file from OpenDNS to manipulate it. I can get it open, but even when I stop my code after it is open, I can't...

I have a range of cells containing names in A6:A12. I also have corresponding values in columns B,C,D and E. I want to compare the value of C3 to see if it matches in the names then extract the corresponding values in B,C,D,E and placed them in column G,H,I, and J. This is the formula I used...