I believe that someone showed me once that you could view the same workbook on two monitors with the vien arrange all mode, you could make changes on both screens and the changes would be saved to the same file similar to arranging two views. I cannot rememebr how to do this or even if it is possible.
View 5 RepliesI want VBA to open two separate sessions of IE on two separate displays.
I have not been able get the display part to work and not finding anything so i am not sure if i need separate sessions but would like to do so to be safe (doing it manually on the computers using i have to have separate sessions of IE to do full screen on the two monitors).
current code: (this opens two IE windows on full screen on the default monitor)
Code:
Sub Test()
Dim objIE As Object
Set objIE = CreateObject("InternetExplorer.Application")
objIE.Visible = True
[Code] .........
I am trying to create a macro that checks and displays the screen resolution for both the Main monitor and the secondary monitor.
Currently I have this code that displays the resolution on the main screen only:
Declare PtrSafe Function GetSystemMetrics32 Lib "User32" _
Alias "GetSystemMetrics" (ByVal nIndex As Long) As Long
Sub ScreenRes()
Dim lResWidth As Long
Dim lResHeight As Long
Dim sRes As String
lResWidth = GetSystemMetrics32(0)
lResHeight = GetSystemMetrics32(1)
sRes = lResWidth & "x" & lResHeight
MsgBox sRes
End Sub
However I want to then display another message with the secondary display's resolution (or on the same message box).
I know what i need to do to get it to open the file I want. I dont know how I set the position of a file that i am opening. In this case a .pdf file.
I have searched and came up with a lot of info for userforms, but I am not working with a userform in this case.
I have a splash page I created and I work on dual screen monitors. Typically I have Excel open on the left monitor and my VBA window (alt-F11) open on the right. If I close my Excel workbook and reopen it, the splash page will always open on the screen that had the VBA window on last. In my case Excel opens on the left monitor and the splash page shows up on the right window. I would like to have the splash page open on the side that Excel opens on (in my case the left side). Wondering if there is some VBA code I can add in my splash page code that would allow me to override this default setting?
View 2 Replies View RelatedI have MS Office 2010 Home Edition. Is there a way to make 2 different Excel docs show up on 2 different monitors at the same time (one on each, of course)? (I have a PC and 2 displays total.)
View 3 Replies View RelatedI'm used to work with the Excel 2003 edition, however I just changed the version to 2010. As result of that I do have the following question:
How can you view the source data of a pivot table in Excel 2010?
I'm using Excel 2010. I have a workbook with only 1 worksheet in it and it will be sent to several people. I want that excel file to open in Full View when the end user opens it. Is this possible without any VBA codes?
View 2 Replies View RelatedI'm using Excel 2010. I have a spread sheet with sales data covering 3 years and multiple customers. I was able to create formulas such as this to calculate the figures for the entire sheet (all customers) by year.
=SUMIFS(J2:J12904,E2:E12904,">12/31/11",E2:E12904,"<1/1/13").
I believe that in order to use filters that show this date for a specific customer I need to convert this to a SUMPRODUCT formula, I've tried this multiple times and had no luck.
I have hide workbook in view and hide option, when i unhide the same it should ask password. Is it possible.
View 1 Replies View RelatedI run two monitors and am able to open different files on each monitor which is very handy.
This doesn't seem to work with Excel. If I have two different Excel files open I can only view one at a time. I can move across to the other monitor, but then can only view one at a time on that monitor - very frustrating.
When I was using Excel 2010 on my last job I was shown a clunky, round-about way of being able to open two Excel files, one on each monitor. (By opening one file, opening a new Excel document from there, and then opening the other Excel file from the new document, minimizing that file and dragging it to the other screen).
Now I am using Excel 2007 and am not able to view two different Excel files, one on each screen. how I can do this in Excel 2007?
I cannot make this work in XL2010.
I am opening a second workbook in ReadOnly in the Workbook Open and Closing it in the Workbook BeforeClose.
I don't EVER want to save changes on either workbook.
I need to leave excel open as the macro created a 3rd workbook which the user will need.
[Code]....
Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
View 3 Replies View RelatedUsing Excel 2010. I have 2 worksheets, saved in same folder (if that matters).
Worksheet 1=Master_List.xlsx
Column1
Column2
Column3
Column4
PartNumber
1002
Sony
Playstation
4D
W74859
Worksheet 2=Sample_List.xlsx
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Column1
Column2
Column3
PartNumber
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
1002
Sony
Playstation
Basically, I'm looking to populate the blank cells in the PartNumber column (Sample_List) by looking at the data in Column1, Column2, Column3 then going to the Master_List, matching up Column1, Column2, Column3. The PartNumber value in the row with the matching values would then be copied to the Sample_List.
I've created a chart in sheet 1 in a workbook. I want to copy and paste that chart into another sheet (lets take sheet 2) of the same workbook. I am using Excel 2010 version.
Whenever, I try to copy a graph and want to do "Paste Special as Link picture". The problem I am facing as "Paste Link" option is inactive.
I am attaching the Excel for your reference.
I used the button in Excel 2010 to record a macro that allows me to format a workbook font and stuff because i do that many times a day for several workbooks. However I want to be able to just push a button and have all open workbooks run the macro I recorded.
I am able to make a button- thats easy, but how do I get it to run for ANY workbook? My problem is that apparently it only runs the workbook that is named a certain way. should i post the code here?
In order to unfilter a workbook before saving, that is often left by the users with filters on, I use the following code:
[Code].....
The code works just perfect for a workbook that has a table in a normal range of cells.
If I insert a table (using Office 2010 and later option), the code simply doesn't work.
How to compare two spreadsheets in the same workbook in Excel 2010.
View 4 Replies View RelatedWe have recently converted to Office 2010 from 2007 I have now got a name conflict with some macros on my templates
I have some code which will open up the affected templates delete the required modules & import the amended modules, this is working OK.
I now have to re assign the new macro to each button on all pages on all my templates., I started of by recording the actions to achieve this (see part of the code), but unfortunately the recorded code will not work, it runs but when I test the buttons I get the message that "this macro does not exist in this work book".
Code:
Sheets("page 2").Select
ActiveSheet.Shapes.Range(Array("Button 255")).Select
Selection.OnAction = "DIAM01"
ActiveSheet.Shapes.Range(Array("Button 1549")).Select
Selection.OnAction = "DIAM02"
[Code] ...........
Excel 2010
My macro cleans up data in worksheet "Chalkboard".
After cleanup, I'd like to copy data and select the last sheet in the workbook (the one on the far right) and paste the data.
The last worksheet changes monthly: Jan Feb Mar Apr, etc.... Meaning each month, I'll add a new worksheet for the given month.
I need code that will select the last worksheet in the workbook.
Windows 8.1 Excel 2010, I open a Template, make some changes in the template then I want to save the modified template as a Template ".xltm" under a new name. I'm using the following code for the new workbook name (which works except for the file extension);
ActiveWorkbook.SaveAs Filename:=ChkLst_TEXT_path & Application.PathSeparator _
& "NewChkLsts" & Application.PathSeparator & ShtNm
By default it saves the workbook as ".xlsm". How can I get it to save it as ".xltm"?
I have a workbook with a tab for each day of the month. This workbook is placed in a shared file and used by various yards in different locations. A new yard beginning the process is refusing to use it because due to formulas we must lock the workbook (contains many formulas and a live clock macro to track trip time) and they cannot sort A-Z. The sheets are labeled 1,2,3,4,5,6,7,8,9 and so on to 31. I know that you can write a Macro to allow sorting, but I cannot get it to work. the users CANNOT know the password due to hidden revenue etc. and formulas.
View 6 Replies View RelatedHow do you import a color scheme from another workbook in Excel 2010? I could do it in previous versions....now I don't know what to do.
View 3 Replies View RelatedI have three workbooks. Every workbook has 50 persons IT information. Those are CPU list, Monitor list, UPS list. I would like to create another workbook. Where all user's IT information will be available. Like X user's information required, under x information his CPU, monitor and UPS information link will be available. How to create link of the CPU, UPS monitor sheets with new workbook?
View 4 Replies View RelatedUsing Excel 2010.
I have a formula in a workbook that links to another workbook and returns a #VALUE! error. The formula is:
=OFFSET(INDEX('\srvrdatakenny cantrell$Kenny''s FolderPayroll[DI Staff List.xls]Sheet1'!$D$6:$D$60,MATCH(TRUE,'\srvrdatakenny cantrell$Kenny''s FolderPayroll[DI Staff List.xls]Sheet1'!$D$6:$D$60=B3,0)),0,2)
However, when I open the source workbook, the cell updates correctly. How can I get the cell's formula to update when the source data workbook is closed?
We have an Excel file that 20+ Users update daily. Every time we share the workbook, it corrupts the file within days.
We are using Excel 2010. We go to Review tab, Share Workbook, and check the Allow Changes box.
I have a workbook that contains two sheets with two separate queries. On the first sheet I have two cells designated to accept the values for the parameters. The first sheet accepts the values and populates the table correctly. The second sheet doesn't seem to accept the values and just returns blank rows.
View 9 Replies View RelatedI am having a workbook (say a.xlsm) which has value entry fields and some values are given to another workbook (say b.xlsm) which has some sort of calculations and the result is projected back to the book a. most of the time book b will be closed. I am using Excel 2010.
I opened and saw that the result which is calculated and projected from workbook b is not getting updated. I opened the workbook b and saw that the values I have entered in a has not been updated in b. note that I am opening one book at a time and I do click on update links when I am asked.
I am running a macro-enabled Excel 2010 file, and there is a link to another workbook that pops up every time I open it asking if I want to update. I have searched formulas and pages, and can't find where it's linking from. I searched the VBA module I've been working in, and I can't find the link. When I click Data->Edit Links->Break Links and confirm, nothing happens. It still shows up as linked, and still prompts me to update next time I open it. I'd really like to get this data link severed.
View 3 Replies View RelatedIm using Excel 2010 and have a data connection that I want to use. I added it to a regular workbook and it updates perfectly as-designed. However, I need this feature to work in a shared workbook, but it doesn't.
View 2 Replies View Related