vba

Welcome to the 'vba' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'vba'.

Are you an expert about 'vba'? Do you want to be the Technorati authority on 'vba'? You can write a description that will appear right here: Join Blogcritics!

Latest blogosphere posts tagged “vba”

 

• Excel Links – from USA edition

  
  — Authority:
  Hello there, My travel to US was fantastic and fun. Many thanks to Jocelyn & Rob Collie, who found a nice apartment for us and made sure we are settled down in almost no time. Weather has been excellent so far too with lots of sunshine and blue skies. We went to a nearby park the other day and kids really loved ...
  1 week ago

• Data Extraction Txt To Xls Pt2

  
  — Authority:
  I have some VBA macros in progress that need optimising or completing The following three options exist There are 6 tasks please advise which option you can complete close to the budget range Option1 Tasks 1a 2 3 4 5 Option2 Tasks 1b 2 3 4 5 Option3 Tasks 1b… Required Skills: Other Programming , [...]
  2 weeks ago

• Counting Query Tables in Excel

  
  — Authority:
  A few years ago, Ron Coderre created his PivotPlay PLUS Add-in that you can download from my Contextures site. This free add-in was designed for Excel 2003, and lets you view and edit the connection strings for pivot tables and query tables that are based on external data queries. Testing in Excel 2010 Several ...
  2 weeks ago

• Opportunity For You!!

  
  — Authority:
  We are giving you the opportunity to be a Guest Blogger on our site www.713Bankruptcy.com as well as have your post sent out in the www.713Training.com   newsletter that has several thousand subscribers.  Guest Blogging can help you network with others, help you acquire new clients; help optimize your website and ...
  3 weeks ago

• Post data to Google Universal Analytics using Excel VBA

  
  — Authority:
  Universal Analytics allows you to integrate data from offline sources. This allows you to see if web visits correlate with store visits for example. The below script shows how you can push data from Excel to Google Analytics. The script below pushes a page view into Google Analytics. Sub postData() Dim result As ...
  3 weeks ago

• Click to Move Excel List Items Up or Down

  
  — Authority:
  Your challenge for today is to come up with a real-life use for this nifty (do the kids still say nifty?) Excel scrolling tool. Here’s how the tool works: Click a button to select a group of cells that you want to work with, like this list of months. Then, click the up and down arrows, to scroll the list ...
  4 weeks ago

• Data Extraction From Txt To Xls

  
  — Authority:
  Project Summary Create a program or VBA macro to extract data from a text file report to excel format xls Project instructions 1 Familiarise yourself with the example files provided 2 Create data extraction program or modify VBA example provided to extract all data from… Required Skills: Other Programming , Perl, ...
  4 weeks ago

• Learn Top 10 Excel Features

  
  — Authority:
  Last week, we had a lovely poll on what are your favorite features of Excel? More than 120 people responded to it with various answers. So I did what any data analyst worth his salt would do, I downloaded all the 120+ comments data I home brewed a large cup of coffee and started gulping it. I started ...
  5 weeks ago

• Excel corrupts certain workbooks in migrating from 2003 to 2007

  
  — Authority:
  I got a email from a client asking for help because Excel was “destroying,” to use his terminology, his 2003 workbook after conversion to the 2007 format. And, after analyzing the kind of change Excel made, I had to agree. The following in 2003 Figure 1 becomes, in 2013 (and in 2010), Figure 2 The basic ...
  5 weeks ago

Comments about vba