Hi,
I'm wondering if there's an easier way to do this, which is user friendly and can cope with new accounts being added. Currently I have the below code, which works great. However, I have 100 accounts and the below code is for just 3 accounts. It is going to be very time consuming writing all...
Good Evening Excelers! I need anyone downloading my excel file from email to AUTO DOWNLOAD & SAVE FILE TO CURRENT DESKTOP w/ current file name & OPEN COMMAND? Is this possible? Thanks 4 any help! :confused::confused::confused:
https://drive.google.com/file/d/0B9uhATNT4QB2QkEwSEtrVjFpeHM/view?usp=sharing
Sub SaveIt()
Dim Fnc As String
Dim Coe As String
Dim Dt As String
Dim Path As String
Fnc = ThisWorkbook.Worksheets("COELeadInputs").Range("E4").Value
Coe =...
Guys!!
I do need to save a workbook by only reading a barcode. I mean as I read a barcode it will save automatically the workbook. Is it possible ?
Please help me out .
.. or does somebody has already done it cause I couldn't find a link talking about it.
Hello Everyone,
Did some additional research and got some help on a code to protect my worksheet, as well as autosave, however I seem to keep getting errors.
I have a worksheet/tool called "Save Tool", with multiple tabs. What I want is the code to:
1) Unprotect all tabs
2) Perform the...
Hello,
I've searched the forum for something similar to what I am looking to do. I have a tool, that runs a macro to clean up the data within. What I am looking to do is have it also save a copy of the end result as a unique name on the users desktop (or what ever specified location)...
There is already a "Purchase Order" excel Template worksheet. There are 4-5 people using this document in one office, and they have a shared server where all purchase orders are stored inside a folder that is shared by everyone.
Requirements: Whenever someone opens this Purchase Order document...
Hi I am new to this but am finding my way around using several pieces of code found on the web so I may look more advanced than I am.
Most of the code I have found does an auto save then a close. what I need is to be able to auto save but without the close. possibaly a message box open while...
I am a REAL novice at this and am asking for your kind assistance in getting this going.
I've created a vehicle sign out log (as shown below).
1. Column "B" is where student will select their names (simple drop down menu);
2. Column "C" is where the student will enter their driver's license...
Hi all
I have been suching the net for a VBA code. I have been looking for days and i have found nothing.
I'm working on a workingsheet that need to save before closing with the name reading from 2 cells. Either im Stupid or I haven't found a code for it. I have just start to learn all this...
Hi..
I'm trying to Auto Save my workbook every 60 seconds. I have the following code in ThisWorkbook. When the code pops off the timer, I get a message displayed Cannot run the macro "C:\... shows the path with the path ending in !TheSub. The macro may not be available in the workbook or all...
Hello all, I am new to the forum and this is my first post. I will try to be as specific as possible with the description of my goal. Many thanks in advance! I am trying to contro the daily intake of products at my store. The warehouse receives between 40 and 50 individual pieces of equipment...
Hi All,
I'm new to doing macros but I'm picking up on their usefullness as i go...
I've created a spreadsheet that will be kept on the company server in the templates folder, but to prevent people editing it I would like the "Save As" dialog box to open every time the sheet is opened, that way...
I am a systems person and not a programmer. I need to have an MS EXCEL template that will automatically save itself every 5 minutes.
If I don't get this done today, I am FIRED !
Please assist.
We have two different workstations - one has MS EXCEL 2003 and the other MS EXCEL 2007 - I can...
I seen a macro that if the workbook set idle or was left open for a set amount of time it would save the workbook. I really need that macro or if someone can give me one I would really appreciate it.
Thanks in advance
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.