Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » VBA (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Re: Importing text files, best way? VBA, Access, SQL??

    Hi again This has been working well. However I have been asked to slightly change the columns that come into the spreadsheet. I thought this would be straight forward as I can just adjust this part -- here I have made changes to a couple This is the one i have changed -- all works EXCEPT the last column...
    Posted to Data Exchange (Forum) by cferart on Thu, Jun 24 2010
  • Re: Multiple workbook copy and paste programming help

    It may be better to post the code you have now and we can add somthing to open and paste into another worksheet in another book. Irrespective, I would have a couple of questions Do you want the 'other' workbook to be dynamic or is it the same location and name each time or is it a new workbook...
    Posted to VBA (Forum) by Nick Hodge on Wed, Jun 16 2010
  • 'clear' formatting of text - vbUpperCase etc.

    Hi All, I've been using VBA to play with text in a cell. Basically I needed to change individual characters to be uppercase, lowercase, subscripted etc. I think I have that sorted now but whilst playing around I tried using the StrConv vbUpperCase, vbLowerCase & vbProperCase functions, which...
    Posted to VBA (Forum) by David B on Tue, Jun 15 2010
  • Re: Importing text files, best way? VBA, Access, SQL??

    Hi Nick I have recorded 2 macros. I am very very new at Macros and VBA and would appreciate help in working out how to make it prompt for File 1.Imports text file and gets rid of unnecessary columns Sub importtextfile() ' ' importtextfile Macro ' Macro recorded 10/06/2010 by Catherine '...
    Posted to Data Exchange (Forum) by cferart on Wed, Jun 9 2010
  • Printing PDF and post to Shareware

    Is there anyway I can automate my sheet so it will print in PDF format and either save to my Shareware site or print to a drive and email to my Shareware site? I have tried recording a macro to see if I could find some code but no luck and I cannot find anything in the literature I have.
    Posted to VBA (Forum) by DougJinx on Fri, Apr 9 2010
  • scientific calulations using scattter and trendlines

    Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient...
    Posted to VBA (Forum) by ecellium on Thu, Jan 7 2010
  • Sum last 10 values

    Hi all With the data below :- how can I sum the last 10 cells in the row from 2-11 (row 1=32) and (row 2=25) Data is added to columns 12 to ? at a later time. Derek 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 1 5 0 1 4 1 7 2 4 7 3 5 2 2 2 2 3 2 3 2 2
    Posted to Functions and Formulas (Forum) by Derek McGill on Mon, Dec 21 2009
  • Tab Renaming

    Is it possible to use a formula or VBA to automatically change the name of a tab when I copy from another tab (I'm thinking of it referencing a cell in the sheet - eg. =month(a4) ?
    Posted to Excel 2007 (Forum) by Mike on Fri, Nov 27 2009
  • Re: combo box calculations

    I work on a excel workbook that has 31 worksheet for the days of the month. I need the combo boxex I created to calculate across work sheets So if day 1 it add up cells in there specific range and specific columns. That works fine. Its when I need day 2 to look at the cell that day 1 has populated and...
    Posted to VBA (Forum) by boman on Fri, Nov 20 2009
  • Excel 2003 Excel2007 migration issue with picture.insert

    I use Excel 2003, but some of my workbooks are used by colleagues using Excel2007. One of my workbooks populates cells with photos. I start with a suitably sized grid, select a cell, insert the picture and resize it and adjust its position. The code that does this is as follows: Sub InsertPic(row, col...
    Posted to General (Forum) by PeterG on Thu, Nov 19 2009
Page 1 of 7 (67 items) 1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.