windows 7

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. E

    Downloading a CSV file from Website using VBA

    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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. J

    Excel Locked by Scheduler,

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top