- Subscribe to this page:
- RSS
- Email Alert
vba
(535 results)-
Discussion Threads
An Access query that returns every nth record
August 10, 2010 7:52am PDT
An Access query that returns every nth record article root VBA module The VBA code works very well but stops short of my needs. I randomly select different records each quarter for a quality...
2 Started by Vicki.Pemberton@... | Latest comment by ssharkins@...
-
Q&A
Need help to embed a whole excel worksheet in Powerpoint
August 6, 2010 12:11pm PDT
Need help to embed a whole excel worksheet in Powerpoint Hi friends. I need to embed/insert a whole excel sheet into a powerpoint presentation as an object. I have to use VBA to pull details from...
2 Started by download2live | Latest comment by TobiF
-
Q&A
Access VBA code combo box
July 29, 2010 5:37pm PDT
Access VBA code combo box Hi. I have the next code on my form: "Private Sub Year_AfterUpdate() Dim year_filter As Double year_filter = "SELECT [Books].[Book ID], [Books].[Title],...
1 Latest comment by LordMaster10
-
Q&A
Excel - Copying more than 255 characters!
July 15, 2010 4:54am PDT
Excel - Copying more than 255 characters! Hi, I am doing a daily synchronisation(copying from source to destination) of 2 excel files using VBA code.But I recently noticed that cells having more...
1 Latest comment by Sumitha Mani
-
Case Studies
ABB Switzerland Improves IT Process Documentation and Publication in EPC Notation
July 1, 2010 12:00am PDT
ABB, based in over 100 countries, is a global leader in power and automation technologies that enable utility and industry customers to improve their performance while lowering environmental...
Provided by: Microsoft
-
-
Q&A
How to use a string to reference a variable in VBA
May 27, 2010 3:11pm PDT
How to use a string to reference a variable in VBA I have a series of variables, MCHandlesOriginal1, MCHandlesOriginal2, and so forth, which I create in a loop. I want to assign each variable a...
8 Started by johnhurgeton | Latest comment by Slayer_
-
Discussion Threads
10 steps to building a custom toolbar in Word
May 5, 2010 6:02am PDT
10 steps to building a custom toolbar in Word article root VBA method is a nice option I suppose I've known customizing toolbars was possible, but I've not explored it much, and certainly never...
6 Started by jody.burton@... | Latest comment by leonvictor
-
White Papers
Integrating the Use of Spreadsheet Software and VBA in Inventory Simulation
May 5, 2010 12:00am PDT
This paper reviews the advantages and disadvantages of computer programming and spreadsheet modeling in logistics education and inventory control, and describes using Microsoft Excel and VBA in...
Provided by: Academy Publisher
-
Q&A
Excel VBA copy formulas to new Workbook without links
April 29, 2010 1:07pm PDT
Excel VBA copy formulas to new Workbook without links When copying a worksheet to another workbook, the range names append the fullname (link) of the source worksheet into the RefersTo property....
1 Latest comment by rgExcelHelp
-
Q&A
vbs scripting and export to excel file
April 6, 2010 6:58pm PDT
vbs scripting and export to excel file Hi there, kinda a scripting newbie, i would like a script to pull information from another txt file on a server that gets updated every 2 mins... what i...
3 Started by Pommyboy_FearFactory@... | Latest comment by neilb@...
-
Q&A
Rapid Application Development - HELP!
March 25, 2010 1:57pm PDT
Rapid Application Development - HELP! I'll try to get to the point quickly here. I appreciate any and all information I can get! I manager a small team developing applications for internal...
8 Started by cg7780_123 | Latest comment by cg7780_1234
-
Discussion Threads
Render an Excel Defined Name invisible to users
March 23, 2010 5:52am PDT
Render an Excel Defined Name invisible to users article root Great tip! Thanks - this is one that I will use. Can Be Done to Existing Names In the Immediate pane, a command like...
6 Started by bkfriesen | Latest comment by basil.cinnamon
-
Q&A
Help convert excel formula to VBA
March 22, 2010 1:37pm PDT
Help convert excel formula to VBA I need help converting an excel formula to VBA. In just I cannot get the wildcard to work in VBA code (tried find, instr, match) but wildcards do not work. Can...
1 Latest comment by BigRoscoe
-
Blog Post
Render an Excel Defined Name invisible to users
March 22, 2010 9:50am PDT
Defined Names don't have to be visible to everyone, if you use VBA to create them.
6 Latest comment by basil.cinnamon
-
White Papers
Generating Reports With DDE and VBA, the Concept - Alternative to ODS to Produce Complex Reports
March 19, 2010 12:00am PDT
As a SAS programmer, one might have experience of spending hours modifying the thickness/colors of a bar chart, fitting an image into the corner of the page, or putting multiple charts/tables side...
Provided by: HAVI Group
-
White Papers
Using SAS Software and Visual Basic for Application to Dynamically Manipulate SAS List Files
March 19, 2010 12:00am PDT
This paper demonstrates how to apply Visual Basic for Application (VBA) procedures in the Microsoft Word to dynamically manipulate SAS output list files. In the paper, the author shall show how to...
Provided by: Forest Laboratories
-
Q&A
vba programming help
March 15, 2010 9:26pm PDT
vba programming help i have >100 .csv files from which i need to extract some data and write the data from each into a separate .xlsx spreadsheet. I know almost nothing about vba. can someone...
2 Started by vba_newbie | Latest comment by ComputerCookie
-
Discussion Threads
Add a Total row to your Access 2007 table
March 15, 2010 2:41am PDT
Add a Total row to your Access 2007 table article root Reference a field from total row using VBA Is this possible? I've tried AvgOf and it doesn't work. I can't see how you can reference this...
1 Started by csryan |
-
Q&A
VBA Code to search PDF file in a webpage.....
March 9, 2010 5:48am PST
VBA Code to search PDF file in a webpage..... I have a list of document number eg 581225AF6 and want to search a pdf file in a website...
2 Started by raj5912 | Latest comment by cmatthews@...
-
Downloads
P-S Cycles System 1.0 (Windows)
February 9, 2010 12:00am PST
A free Excel based Integrated Planning and Scheduling System with the following features: Inventory replenishment and distribution planning across multiple depots; Make-to-order and make-to-stock;...
Provided by: Production-Scheduling
