I wish to send a workbook but need to ensure that this workbook stays on the computer it is destined for. I understand that for ultimate security excel may not be the best option, however im using excel and with that need to look at the best options available to me.
My thoughts were along the lines of sending a simple application for better words in excel, and having the user fill in a few details, this would trigger a events macro recording A the machine id ( which i have forgotten how to do any any help would be great with that ) or B the user ID to a hidden cell, then on receiving this back be able to use that as a key in the application before sending it out.
Then if the user was to pass this to another person it would not work as the code would not match. Does this seem like a best approach or is there a better way that a similar effect could be had?
I've a workbook (XL 2003) test-1.xls, and I need to restrict it to a specific computer with ID: my-a1234567k
(shown under ControlPanel::System::Computer Name::Full computer name).
Is it possible to code such restriction in the w/b Open() event to prevent opening the w/b on a different computer?
My computers each has a different OS (Win 2000, Win XP Home, Win XP Prof ), different Excel version (XL 2000, 2003, 2007), etc., and the majority of my workbooks have been developed and would work only in certain environment (e.g.; in XL 2003 only, or XL 2007 only, ... ).
I have an excel workbook that lists the number of mailboxes on several exchange servers. Because this info is put in manually by several people throughout the day there is a chance for mistakes. I can use remote desktop to get into these servers and check all these but when you have over a hundred (Enterprise Level) of these different mailbox stores to check, it takes a while and just isn't fun. I have a friend who made a vbscript file that can check them all but I don't have that code but now I know that it is possible...well with vbscript anyhow.
is it possible for excel to access a remote computer? and how would this be done? If needed to we can be already remoted into it I just need help with the Syntax of how to then access it via some VBA.
I am creating a spreadsheet for work - I have a column that is all the formulas projected sales minus actual sales.
I need to lock this column so that no one BUT MYSELF can change the codes. In other words "idiot proof" the worksheet. there are only 18 sections that I want anyone else to be able to type in.
is there a way to do this without adding users? half the ppl have personal emails and half have company emails.
I have a workbook with 6 tabs. The workbook is designed to be shared but I want to password protect the last 4 sheets so that they can only be accessed by certain people. The people who have access need to be able to edit the sheet.
I am looking at a way to create a dsitributable excel spreadsheet (.xlsx), which contains non-sensitive, yet restrictied organisational information segmented by regional department for NCSA, EMEA for APAC respectively.
By design, all data has been collected in a datatable on a password protected "data" sheet - and - presented on an "executive summary" sheet. T
The "executive summary" sheet contains a privottable with select "multiple options" to allow for aggregated dataviews on executive level. However, on a regional department level, the users must only see their own regions, hence the filtering mechanims on the pivottable should be restricted.
Currently, the restrictions on the pivot tables are made in VBA, using the following script. However, it still allows people to change the "multiple options" filter in the pivot. How can I restrcit this option
Sub RestrictPivotTable() Dim pf As PivotField With ActiveSheet.PivotTables(1) .EnableWizard = False .EnableDrilldown = True .EnableFieldList = True .EnableFieldDialog = False .PivotCache.EnableRefresh = False For Each pf In .PageFields
[code].....
As a sidenote; the above design requires that a spreadsheet is compiled for each region each month. Ideally, the ability of filtering, could be password restricted - or - filteren. So only one selection would be presented for the NCSA, EMEA and APAC respectively, while Executives could view across one-or-many regions? However, as Pivot tables are used by design, I cannot see how this could efficiently be achieved?
I have an Add-In installed on multiple computers. When I update it I update them all at the same time so that everyone is on the same page. The Add-In is always in the same location for all computers.
C:- Global FilesVF MacroVF Macro Add-In.xlam
I use the Add-In to format a sheet and one of the formats is to display the "last author" & "Last Save Time" This is the code used:
Code: Function DocProps(prop As String) Application.Volatile On Error GoTo err_value
[Code]....
The same situation occurs with cell Z8 as well. It appears it is looking in the wrong location. If I change the E to a C in the formula bar it fixes the issue but I cannot rely on my users to do this every time. We keep the WB's in question on an external drive and pass it around as needed. So they will run into this problem on a regular basis.
I also get a "Security Warning - Automatic update of Links has been disabled" message only when run from the USB drive.
Worksheet1 is modified on computer A. Worksheet1 is open on computer B. The instant something changes on Worksheet1 on computer A, Worksheet1 on computer B is updated.
Idea 1:Maybe worksheet1 on computer B could be opened read-only and then the notify feature could be used to trigger a macro in worsheet1 on computer B. By notify I am talking about the box that pops up when a user has finished modifying a worksheet to let you know you have read/write access.
Idea 2: Could all cells in worksheet1 on computer B be linked to all cells in worksheet1 on computer A and automate the updating somehow this way?
I have a condition setup (under "This Workbook") upon opening a spreadsheet to verify a computer's predetermined motherboard serial number that will shut the Excel workbook down if the numbers do not match. This works fine. What I'd like to do is to add a second condition that will allow a password to be entered in a textbox if the numbers do not match so that the serial number condition could be manually overridden, if necessary. If the serial number and the password are incorrect the workbook automatically closes.
Here is the code that works:
Private Sub Workbook_Open() If CreateObject("Scripting.FileSystemObject").GetDrive("C:").SerialNumber "-XXXXXXX" Then ActiveWorkbook.Close False End Sub
Here is what I am attempting to do that is not functioning properly - need to add a textbox to enter a password to override an incorrect serial number
Private Sub Workbook_Open() If CreateObject("Scripting.FileSystemObject").GetDrive("C:").SerialNumber "-XXXXXXX" Then Dim Rng Rng = InputBox("aaaaaa") If Rng "aaaaaa" Then ActiveWorkbook.Close False End Sub
I have the following code linked to a drop down list in my workbook.
[Code].....
It populates textboxes on the sheet with a lookup value result, the lookup value is taken from the dropdown box. The problem I have is any other excel workbooks that are open at the same time, the code is trying to run against those workbooks when I edit them, I can't seem to restrict the code to run only against the workbook in which the dropdown box which the code is linked to, exists in. I have tried moving the code to a module in the workbook but then the code does not seem to work as it does know which workbook the combo box and text boxes which should be filled with the lookuip result belong in
While in a workbook called "Main_Workbook.xls", I use a sub to open another workbook called "SecondWorbook.xls". Here's the code to do that:
Sub OpenWorkbook() ExcelFile = Application. GetOpenFilename(FileFilter:="Microsoft Excel Files(*.xls),*.xls", Title:="Choose an Excel file To open...") Workbooks.Open FileName:=ExcelFile End Sub
This works fine. When you view the workbooks in the Project Explorer you will see:
I need to know that how can we share excel workbook. Is it possible over LAN? Also how many users can access the shared workbook. If 50 users are accessing shared workbook and each one working on different workbook. Is this scenario feasible? Will there be any issue if 50 users working on 50 different worksheets of same workbook?
I have a problem with the Excel UserName & opening of a second xls File. Info: The first file macro, looks as to the Excel UserName, and sets which worksheets from a second file in the network the person can see. then changes the Excel UserName to "helpdl", this is done because only 4 people have access to the Workbook on a network drive, see Code below (only the interesting part of the macro)
'Set the Excel UserName to "helpdl" '(from Sub Change_UserName) MyName = Application.UserName OName = MyName NewName = "HelpDL" UserName = NewName 'Set the name of the Active File To "Slave" Set wbSlave = ActiveWorkbook 'Open the Master from the Network (Wiesbaden server sv030100) Workbooks.Open "\sv030100GruppenDL60116_MEWA Car Policy_Neukonzeption.xls" 'Set the name of the Active File to "Master" Set wbMaster = ActiveWorkbook...........................
I have a workbook which will open another workbook on a server, but i see it on the open and close on the task bar. Because I have 4 pc's with the main workbook open as single applications and one book on the server which collects info everytime a button is pressed, I would like it not to show on the on the task bar, needs to be invisable, is there any way of this?
Also
Can i see if a workbook is open, regardless of which PC (out of 4), which may not be the one i am using. So a way to see if a workbook is open anywhere else?
I have created a workbook which both imports data from an access database and exports data to same. Some of the data I need to access is dependent on parameters which the user will change in excel e.g. I need to extract PeriodID (ID for a month end date) based on a date in a speified cell in excel.
MS Query is a very handy way to achieve this as the wizards automate almost everything. However, this workbook will be shared on a common drive on a server (as will the database). Initial testing suggests that the connection and queries I'm making on my machine do not work on other people's machines.
What is the best way to achieve the queries in excel which query data from an Access Database, but will work on all machines accessing the sheet from a shared drive? Is there any way I can avoid writing complex VBA code for this? I have an awful lot of specific queries like the one I mentioned above to perform.
I have two workbooks wkA and wkB. I have a named range in wkB called BName.. can someone tell me whether it is possible to set a range variable (say, raA) from wkA to this named range in wkB. I have tried something to the effect of set raA = wkB.range("BName") but this doesn't work.. I've also tried set raA = [wkB.name].range("BName") to no avail. I'm wondering whether named ranges can actually be read from other workbooks.
I want to write some code that runs everytime the workbook is initialized. I found out that the code should be placed in the following "Private Sub":
Private Sub Workbook_Open() 'My code End Sub
I know that this code should be placed in the Private Module of the Workbook! I just can not find where is the Private Module of the Workbook in Excel 2007... =/
I've created Keyboard Shortcuts to run Macros in "Workbook A". Problem is, if I have "Workbook B" open in the same Excel instance/process as "Workbook A" the Keyboard Shortcuts will run the Macros in "Workbook A".
Is there a way to restrict the Keyboard Shortcuts to only run the Macro if Workbook A is active?
Or is there a way to code the Macro to run its procedures only if Workbook A is active?
Using Microsoft ® Office Excel 2003 (11.8220.8221) SP3, I started with a sheet, Sheet7, that pulled the first non-blank error message found in a common cell (i.e., A7) in Sheet3.1, Sheet3.2, ... , Sheet3.15, Sheet3.16. All of these sheets resided in a single workbook, and worked correctly using the following VBA code snippet:
I would like to know how to migrate an Access database to a spreadsheet, I do not mean Exporting.
More specifically, the migration is conditional. The spreadsheet only needs a few fields from specific tables in the database. It is basically a data dump, however, the magnitude of the amount of information that I will be handling will be far too time consuming and not within the scope of the budget to do this all by-- Exporting-->Copy-->Paste method.
Also, changes often need to be made "The night before..." so the macro will need to be able to ran possibly a number of times to update the additional data or changes in data.
In my research I have found a few snipets of VBA code from the MSDN website as well as some other websites, however none of it seems to be consistent with one another and ultimately results in it not working.
For my project , I am using Excel as a frontend and Access as a backend. Now, I want to write the code in workbook_Open event that will copy data in Column L,M,N,O from Access table. The query should select data from Access table where Date=Todays Date. All the Queue Names and corresponding Queue Numbers are stored in Sheet2 of the attached workbook. In Access table , there are three fields named as Type,Type1,Type2 which make up Queue numbers.
In Sheet1 , There are Queue Names and we have to store Total Batches,Totl Envelopes,total Documents and total Pages for the corresponding Queue Names in Sheet1. SO for this we need to check the Queue Numbers of the Queue names in SHeet2 but in table Queue Numbers are equal to Type & Type1 & Type2.
I am Generating Excel file with Macro using my asp.net (c#) application.
I am able to generate Excel file in development environment, but in Production it gives following error: "Programmatic access to Visual Basic Project is not trusted Line: Microsoft Office Excel"
I did googling a bit and found that I have to open Excel file physically make few security related changes in macro as below.
1. Open the Office application in question. On the Tools menu, click Macro, and then click Security to open the Macro Security dialog box. 2. On the Trusted Sources tab, click to select the Trust access to Visual Basic Project check box to turn on access. 3. Click OK to apply the setting. You may need to restart the application for the code to run properly if you automate from a Component Object Model (COM) add-in or template.
Can i do above changes at runtime (using some code)?
I have an Excel file ( named "Classes.xsl"), that has a worksheet (named "RawData") that is layed out something like:
Name Dept Class John 0547 Class 1 Jane 0368 Class 1 Jim 0368 Class 2 Sue 1235 Class 2
I am trying to get an Access-Like report without utilizing Access. Is there a way to generate a report similar to below using Excel as the data source (could be mail merge, perhaps a macro with a printout) I am not sure which way to try and was hoping someone could point me in the right direction...and possibly provide an example.
Class EnrollmentClass 1John 0547 Jane 0368Class 2Jim 0368 Sue 1235
Is there a code available that can be used to get the user's computer ID number (Not Computer Name)? I'm using a password generator to randomly generate a password and I would like to use this unique password with the user's Computer ID.
I have a problem running an excel macro on different laptops because the IP needs to be known (my program links to databases that are installed on a "server" laptop). The IP can be sourced by using the "Start, Run, cmd, ipconfig" but my users can have problems with process.
Does anyone know of a vb function that will display the ip of the computer that the code is run on?
i am experiencing runtime error '6': overflow on one computer but not on another computer when it is the exact same file running on two different computers.
