windows 7

Morning, Hoping someone can help identify how to work around this. I have the Windows 7 Task Scheduler open an excel file, it runs an on open macro that calls Refresh_all_tables, does what it needs and closes. However, it is now locked, I've tried changing the Application.Quit...

I update and run a weekly report (Excel 2010) and send to another internal department within our company. From that, they make a couple of changes (also in Excel 2010) then click a button to extract a report for our customer. Last week, the person who makes the weekly extracts upgraded to...

Hi All My second ever forum post, exciting times! I am using Excel 2010 in Windows 7 on a new work network and have a personal macro workbook. I mention these points because I have been having issues which are related to them. Firstly I am sometimes forced to open files as read only because...

Hi, I have been given a very strange excel issue that has me stumped I have been sent a file that will not open unless another excel file is opened first. Excel opens but the file does not. I have checked that ignore other applications that use DDE is off Honestly i have just joined this...

Since being updated to Windows 7 on my laptop, I have been having problems when running a VBA macro in Excel 2003 in debug. Pressing F8 to step forward works ok until I reach any file related operation (e.g. Workbooks.open), after which debug mode is forgotten and the macro continues to end (or...

I have MSCAL.ocx installed in SysWoW64 file (for windows 7, 64 bit). I still don't see the Calender option under my Active X options. Can anyone tell me what is going on? The MSCAL.exe file is registered. I'm just trying to put a drop-down calender in my spreadsheet for ease of use regarding...

I have an issue that I constantly get the "macros have been disabled" popup when trying to run my macros and it isn't even constant in the fact that it only stops running macros on one workbook and continues to allow them on others workbooks sometimes. The trust center is still set to allow...

I've recently received an upgraded computer at work. Yay! However, it's running Windows 7 and several of my applications are not working properly anymore. resultsSheet.Rows("11:" & maxrow).Select is the statement that fails. I need to select all of the data from row 11 down and create a...

Very odd issue came up and after searching the web, can't really find an answer. Windows 7 - Just installed Office 2010 Standard. All of the excel files can not be opened directly. If you open Excel and open the file from there, it opens without an issue. I verified the file associations...

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> The following two routines which I got from Ron de Bruin’s site have worked really well on several different machines running Excel 2003 and 2007. These machines have mostly been running...

I have created a company document that pulls data, mainly with vlookup functions, from what i call master files located on a network drive. A new 'component', 'test method', 'customer', ect. could be added to the master file and it would update all documents in circulation (once opened and...

Hi All, I have a few issues within Excel 2010 X64 version. What we have going on is that when EU are using Excel and they open 2 or more spread sheets Excel goes haywire and gives messages like ( Excel cannot complete this task with available resources. Choose less data or close other...

Hi All, Problem Summary : My code runs successfully in Windows XP machine, but the same code gives me Compile Error : Out of memory while running on a Windows 7 machine Purpose of the code : It is sort of a report generation code where the user can export customized data to a new file...

Hello everyone, I am running Windows 7, Excel 2007. I recently installed Internet Explorer 9 beta (which by the way is BEATIFUL!! Death to all taskbars!!!:diablo:). But alas, some code of mine that used to work in Windows XP, Internet Explorer 7 simply does not work. Here is some example of...

Hi all. I have a simple excel file that our sales team is using to report on their meetings (I know that's what CRMs are for...we're working on it. this is a temporary stopgap). I've added a few data validation lists to the file to create consistency for reporting purposes - no formulas, no...

I have a popular fantasy football spreadsheet package which I've sold for years. One of the features (frills) in one of the files is the ability to play "trash talking" sound effects. Someone in your fantasy draft makes a pick you want to laugh at, click the appropriate sound file, and hit play...

I have noticed a few old posts on this, but thought I should start a new one. I have created an excel workbook that uses macros (still not working, but that is another issue!). I made a self certificate, and distributed it among my colleagues. Those on XP were able to accept the...

I have created a VBA form in Excel 2007. It ran perfectly on my computer (running windows 7 home premium 64bit) until I formatted and installed windows 7 ultimate 32 bit. I now get a "type mismatch" error when I try to use the form. The problem is that it seems to run on some computers, but...

I need to disable the three buttons to minimise, restore and close buttons of the Worksheets for the application I am working on in Excel 07. Is there any direct method ( as available for userform) and indirect way to do this? A way to keep the window always maximised would do the trick. Thanks SKM

I’ve made on my computer a dual boot. First: - Windows XP (NLD) - Office 2007 (NLD) - Office 2003 (NLD) Second: - Windows 7 (ENG) - Office 2007 (NLD) If I start with WinXp and run the excel file, in both versions of Excel, then there is no problem. When I start with Windows 7 I get the next...