windows 7

  1. montecarlo2012

    VBA Sort two columns

    Hi. Column B there are a bin of numbers, column C the frequency of this numbers. In order for me to RANK them, I have to Editing with sort & filter I want to find a real short way to code this, example: So the macro I got is: //////////////////////////////////////////////----COPY AND PASTE...
  2. D

    Save a range to a new workbook and save as a specific title?

    HI All, bit of a strange one, i have been researching and cannot find anything relating to this. but i want to save a range in a workbook to a new workbook in a specific location under a new name. so i have workbook 1 with 4 sheets i want to save sheet 1 range A2:R10000 as a new workbook as...
  3. B

    Programmatically opening Excel followed by Workbooks.Open fails

    Hi, I've been working on some VBA in MS Word to that requires access to information in an Excel workbook. I'm having trouble when Excel is closed before my procedure is called. I'd like to avoid dependence on the user opening Excel before the application is used; consequently, Excel may or may...
  4. Hobolord

    VBA Change Event Code?

    <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">Hello, I am using Excel 2013 on Windows 7 (PC). I have a workbook with...
  5. T

    How to use VBA to Copy Files

    Dear All - I have a clients folder on Drive "D" and there are 2522 XL file numbered from 10001 to 12522 - each month i do a backup for the clients active that month - there is a file named "LIST" that have all active clients ID - So what i wanted to do is a way that i can copy the files that...
  6. Hobolord

    Copying and Pasting Values Based on Other Cell Contents

    Hello Friends! To start this off, I have Windows 7 with Excel 2010. I am working on a project in which I need a macro to assist me with this copying and pasting. For easier explanation, I have recreated some of the spreadsheet below: <tbody> A B C D E F G H I J K L M 1 Type Ref # Terms...
  7. Hobolord

    Allow Editing during macro running

    Hello, I have Windows 7 and Excel 2010. I am attempting to develop a macro for a report, but I need to be able to dump data into the report in the middle of the macro. It isn't possible for the macro to retrieve the data for me because it is on Remote Desktop. I've tried using a msgbox, but I...
  8. J

    Keyboard Is Typing Wrong Characters ONLY In Excel

    Hi all, I was typing along normally when suddenly my keyboard started typing the wrong characters. This is happening ONLY in Excel. I'm working with Excel 2010 on a Windows 7 machine. I may have fat-fingered something at the lower left of the keyboard (CTRL, SHIFT, ALT, Caps Lock and Windows...
  9. D

    Need to install Power Query with Internet Explorer 8

    Hello, could someone please help me? I need to install Microsoft Power Query to allow me to easily merge excel tables from different worksheets (files). The problem is that I am restricted to Internet Explorer 8. Here are my specs, I cannot change these: Windows 7, 64-bit operating system...
  10. O

    Same VBA code in the same workbook works on one computer but not the next.

    Hi Guys. I have two computers at home. One is my every day workhorse. One is for 'automation' tasks. I have a macro I've written which opens internet explorer to a url then brings the innerhtml content into a sheet separated by < so that I may process each tag. On my workhorse PC everything...
  11. T

    Inserting templates with ref. to destination workbook = #REF!

    I have made several report templates, each with different cells linking to a 'Project Data' source sheet. Within the templates themselves I haven't included the source sheet. So obviously: I end up with a lot of #REF! errors in this first step, though that isn't a problem by itself. I'm...
  12. J

    Weird VBA Bug - Workbook.Open & For/Next Loop

    Today, I ran into the weirdest bug I have ever seen in VBA, and I thought you all might find it interesting. I'll post the workbook on Monday, but here's what I can tell you for now. The code goes something like this: Sub Example() dim arrNames() as variant dim intLoop as integer dim intSize...
  13. M

    Print to PDF issues

    Hi all, I'm having issues with printing to PDF since half of my team were upgraded to Windows 7. The code below used to work on XP Pro with Office 2007 or Office 2010 but since the upgrade to Windows 7 with Office 2010, it no longer works. Sub saveaspdf_click() 'prints to pdf 'tells excel...
  14. M

    I am getting confused with Multi nesting could do with some pointers please.

    Good morning people, i working for a company where i work flexi time, I have over the years used many spreadsheets to try and track my time. I am now trying to create a unique spreadsheet for me to use in the several situations that i come across during the working week. Now to my problem. in...
  15. E

    Downloading a CSV file from Website using VBA

    I'm looking to download a file from the site: "", with the file address being "". When I use the code...
  16. P

    Window 7 - Excel 2010 setting? VBA ActiveSheet.SaveAs Filename not posting name to dialog box

    I recently changed over from a Windows XP box running Excel 2010 to a 64 bit Window 7 box running Excel 2010. One of my macros would bring up a save box upon opening, making the user save the template. I would populate the filename with a new name and allow the user to select the directory. On...
  17. S

    ActiveX Component Can't Create Object: EXCEL6 Error

    Hi All, I am having the "Run Time Error 429: ActiveX Componenet Can't Create Object" occur at this line of code: Set OutApp = CreateObject("Outlook.Application") This use to be a working auto emailer macro till I was moved to Windows 7. Apparently what I noticed is that I can get it to work...
  18. B

    Auto fill group data using info from another worksheet? - Formula Needed.

    Microsoft Excel 2010, Windows 7 Hi all, Looking for some help with a formula to auto fill data from one worksheet to another by using a formula: On our first worksheet we have sales data with codes The sales data is per a row and in that row is a code such as (A32) (C32) depending on...
  19. K

    Excel 2010 locking up in Windows 7 when 'file open' icon clicked - pdf filemaker add on

    I just got a new laptop with windows 7 and when I click the file open icon in excel 2010, the entire spreadsheet locks up. It sounds like this could be an add-on issue. The only add-on I have is pdf filemaker. Once I am locked up, I have to kill excel through the task manager. Has anyone...
  20. C

    Set acApp = CreateObject("Access.Application") Window 7 - XL2010

    Hello, I am trying to work with a VBA macro which loads data from a microsoft excel file onto an Access database. This previously worked under our old systems (which also had Excel 97-03 and a previous version of Windows). This last week we were upgraded to Microsoft Office 2010 and Windows...

We've detected that you are using an adblocker.

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
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 "".
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.
Go back