saved

So i'm at work and we have a spreadsheet where every price in cell A is 15% off. we did the right formula in the box (=A1*.85) everything was looking good so we saved it. when i went to open it this morning it hasn't saved the formula the prices are not 15% off. I tired entering the formula...

Hi can you help on how to create connection between excel file and access database both saved in sharepoint. i have code to connect them on shared drive but not able to do so in sharepoint. Appreciate your help ) Vineet

Hi All, I work work with a lot of excel files and when closing and saving those files I want to back them up to folder of the same name as the file; and the folder saved to another folder called "Excel Backups" on the desktop. I'm not good with VBA and would appreciate someones help. Regards...

I have an issue where a report shows time in the format hh:mm:ss but has been saved in general format and I can't sum these, how can I resolve to get a sum of time? Thanks

hi, I need to refresh Query (PQ) after file saving. Is there any way to check if is fully saved before executing next line? In below code if any user would switch sheets very quickly I get run-time error. Private Sub Worksheet_Activate() ActiveWorkbook.Save ActiveWorkbook.Connections("Query...

Hi all, Sorry if this is not in the right place. Does anyone know if a workbook which has been saved to a SharePoint library can populate a column in the library using a cell in the workbook? I have a simple test for interviewees to complete, and there is a hidden 'results' tab with $T$10...

I really don't know how to ask this question, but I'll try... I have a userform that has severl textboxes for a user to input parameters to calculate production output. Everything else is working perfectly so far, except the [Save] function. This is what I need: When a user clicks the [Save]...

Hi guys, I'm new to macros and I'm enhancing this report of mine for efficiency. I was able to create the 1st two modules (for formatting and some computations). This is for the 3rd module and for the final step. The scenario goes like this: 1. I have a source file (Working file.xlsx). This...

Hi, We have macros saved in a shared excel document. The majority of these macros open other docs saved in the network drive however currently the macros can only be used on my machine because of the path name i'm using. For example: ("C:\Users\HarryKane\Folders\Itscominghome.xlsx") So...

Hey all I'm sorry if this question has been asked before, but I'm trying to sort a mega spreadsheet to make something at work much easier and simplier Basically every day, someone has to give me a number which I then add to the spread sheet. If this number is '4' I would like the value to be...

I seem to be experiencing an odd issue when saving a template file with a new name. I have a template file (not saved as a 'template' file though) and I need to run a loop through some names to create a file for each person using the template. I have run this kind process before on SharePoint...

Hello Hello... Is there a reason for this or perhaps I'm missing something in the settings?

I've looked all over but can't really find what I'm looking for. Basically I'm trying to build a VERY basic forum within Excel. Someone can post a comment, question, etc. Then other employees/Managers can respond. The problem is that it needs to be saved so that if a manager responds no one...

Hi all, I have a macro that works in printing out the requested fields for all items on a drop down list. It determines if there is any values on the second page then prints out just one or both pages depending on what is returned. I am trying to adjust it so it saves as PDF rather than prints...

RE: VBA Code to hide rows, if column value is a certain value, and then export to new workbook Hi, In a sheet/tab named “Reporting_Interface” I have a drop down box that has a list of the 5 tab names within my workbook. Each of these 5 tabs have different data displayed in a very similar...

I’ve noticed that when some users are entering information into a form that the corresponding table cannot be opened until the other user has saved or exited the form. Is there a way around this? What causes this?

Hi Please can someone assist me, All the answers to this problem pulls the emails directly from outlook, however, I have a folder where an administrator has saved each individual email as a file, I need to extract the data within each of those emails into an excel list which I can then create...

Hello- I have created a spilt DB for users who will be using different forms from the front end database. I have come to find out that when updates are made to the backend database they will not transfer to the front end database unless the backend database is saved on a shared network. The...

Hi Team, In our company we follow a process where in a team saves e-mails in a shared folder from where people from another team are supposed to pick and start processing. As a improvement idea I was looking for a macro which upon triggering can loop through all the saved e-mails in that folder...

Hello, Is there a way to have a saved import run each night - a code that this do thise without opening the database? Thanks!