system

I have code that accesses a file that exists in SharePoint. I am referencing the path as a network path (ie. \\sp5463.xxxxx.net@xxx\xxxxxx\sites\etc) On a fresh reboot of a system, a user will opening the workbook that runs the code will receive an access error, because the system thinks the...

Excel 2007. Columns R5 to R187 contain dates in dd-mm-yyyy format. My requirement: Column R1 should show the next immediate date following the system date. Example: System date in dd-mm-yyyy : 04-05-2019 Column R25 contains 06-05-2019 (next earliest...

Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA code for Auto Filtering System. How Can I do it. Thanks in advanced.

I have a mixture of formulas and text in Col H I would like to set up a formula in Col I, that if there is formula in Col h, then return "on system' , otherwise "not on system" It would be appreciated if someone could assist me

Hi all, i spent a good portion of the day trying to figure this out without any success. I created a macro that uses a system generated report to sort data and transfer it to a separate sheet. The thing is, the report is generated every day with sheet name as "Ledger Account Detail_20190415_"...

Is there a formula that can be used to remove printable hexadecimal characters from a cell? It appears that CLEAN only removes non printable characters. I am trying to load data into a business system from an excel template and it is erroring on Hex characters so I was hoping there was an easy...

hello i am using excel (office 365) and i have a order entry system where i collect details from the user via user forms. this system is used on 2 PCs here in the office both running the same version of office 365 but on the 1 PC everything works perfect but on the other some of my option...

Hi, i really need a help here asap by tomorrow. I would appreciate if someone could send me the VBA codes for this question i have as an assignment. The criteria of the assignment is as below : For this problem you will be provided with your own set of pump and system curves. You must...

Hello everyone, I'm creating an accounting system that includes invoice recording and an inventory system. And I need help finding an automatic way to calculate the inventory stock. Example: Page 1: Contains Invoices Product X | 35$ | 5 Name.....Cash Paid....Quantity Purcahsed. Page 2...

So I have come across a very peculiar situation -- I've developed an Access 2016 DB for my team -- there are about 10 end users -- each of them have their own executable on their respective desktops. The DB is Split -- the executable is the front end, and there is a separate MS Access back...

I have a sort button I want to change the picture on between the embedded images of "Sort Ascending" and "Sort Decsending". Since they're embedded within Access, I'm not sure what I need to do to get to it. I do remember seeing something about resource databases that are kind of like system dbs...

Hi, I am trying to write code which looks to see if a sheet exists called 'Copy of System Sheet' and if it does then delete 'System Sheet' and rename the copy as 'System Sheet'. (Copy of System Sheet may be hidden). If sheet 'Copy of System Sheet' does not exist then display the msgbox. I...

Hi there, Just wondering if there's a possible formula to help with the below. I am after a formula for Column E that returns certain text when a cell/cells are not blank. So for row 2 for example, because there are values in only Column A and D; the result I am looking for would be the names...

Hi everyone! I work in medicine and have a data analysis project I'm trying to work on. The basic premise is that I have an excel workbook that's the output of a database search of our radiology records system (submitted a keyword search to radiology system, it output all results to this...

We have a system that we are using to generate login and logout times throughout the day (that you can export to excel), and we also have a manual excel tracker that we use to input the time we logged out and logged back in and the reason we logged out at that time. Now, the official report is...

Hello, i am not so good with VBA. Can anyone please help me understand how can i get the system current time and keep it as a constant value? Sub Button1_Click() Dim MyTime MyTime = TimeValue(Time) MsgBox (MyTime) ModTime = MyTime + TimeValue("1:12") MsgBox (ModTime) End...

Dear All, Good Day !!! I would like to pull all those email from outlook 2016 in a folder in my system that i had sent email from 01 Dec 2018 to 31 Jan 2019 by Outlook VBA code. some email is not showing in sent items or inbox. When all e mail fetched in a folder in system then i want to...

Hi i have a formula that returns the correct result =IF(ISNUMBER(MATCH(A2,V8:V13,0)),IF(A2=B2,"eombh","bh"),IF(A2=B2,"eom","normal")) A2 = a date V8:V13 is a column of dates however i want to introduce another variable (system)...

Hi I've got this formula which works correctly but is a bit long winded and has a few nested IF statements; =IF(G7="eombh",INDEX(E2:E22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),IF(G7="eom",INDEX(D2:D22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),(INDEX(C2:C22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0))))) G2=...

Hi looking to create a CRM system for our business has anyone got any recommendations? Thanks