windows 7

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...

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...

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...

<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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

I'm looking to download a file from the site: "http://www.m-x.ca/endOfDayData/", with the file address being "http://www.m-x.ca/endOfDayData/DataBDM2013-11-26.csv". When I use the code...

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...

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...

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...

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...

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...