|
Is there a clean way to extract the VBA from a spreadsheet and store it in a repository.
The spreadsheets hardly ever change but the VBA does. Storing the whole spreadsheet in the repository makes it difficult to do diffs across the different VBA revisions...
Started by nzpcmad on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
With Documents and VBA Code
Using the Visual SourceSafe Add-In with the Visual Basic EnvironmentPrevious versions of Excel and Access (prior to 2003) supported VBA Source Code Version Control via of similar questions....
|
|
So I was just looking for basic examples of reading xml structure data with visual basic subs/scripts.
specifically, if possible, how can i take structure data of xml, read the data with some vba, and lay it into excel spreadsheets?
or just a learning...
Started by Justin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Http://www.dailydoseofexcel.com/archives/2009/06/16/....
Folder\yourXML.xml")
2) Read the data with XPath or XML navigator
3) Build Excel Spreadsheet Using Microsoft Excel Object Model
w3Schools has a good tutorial on the XML DOM.
|
|
Hi, I don't know much about .net, but I am working on a project where a requirement is to port some Excel VBA code embedded in spreadsheets to standalone C# .
Are they any tools that could automate (or semi-automate) this port or compile? How well do ...
Started by DanSingerman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Converting.
You might try converting the VBA to VB.NET and then use a tool to convert that to C#.
Code from VBA to Visual Basic .NET
Ten Code Conversions for VBA, Visual Basic .NET, and C#
Try using.
|
Ask your Facebook Friends
|
I've been asked to find a way to send an alert to a blackberry when certain conditions are met on an Excel 2007 spreadsheet. The alert can be an SMS (preferred) or an email. The cell values are changing throughout the day from a DDE feed.
What are the...
Started by Guy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Dim oSmtpMailI know next to nothing....
Easily add email support to your Visual Basic 6 (VB6), ASP, ASP.NET, VB.NET, C++ registration system, and it'd be no problem to splice it into a bit of Excel VBA,
....
SMTP/ESMTP protocol.
|
|
Hi everyone,
I'm new to OpenOffice Basic/LibreOffice Basic (I'm using LibreOffice currently), and want to convert a macro for updating stock tickers. There are multiple macros in the workbook, however I'm currently only interested in the main (getData...
Started by PatrickDickey_102 on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at openoffice):
Regarding....
And the good thing with OpenOffice in OpenOffice.
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please that Python is more suited for the job then MS VBA or OOo Basic.
|
|
Hello,
I have requirements from our client where we basically have to 'parse' PDF files from various different sources.
The solution we have come with, as 'phase 1' (as we have short time to market and will save them a huge amount of time) is
1) manually...
Started by dferraro on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
I have written many VBA functions within Excel, some of which have anywhere when using....
And a solution based on VBA if you need to modify a script.
With, but at least it gives on-the-metal access to the Excel object model.
|
|
I have a series of stores Queries/tables in an MS Access 2002 database that starts with "RP_". I would like to list those table names in a listbox menu in an MS Excel 2002 spreadsheet. Any ideas on how to do this?
Started by TheObserver on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You might findIn the VBA Immediate....
This page should get you started on how to use ADO .
Then stick something like this in a VBA in the Visual Basic editor.
In Excel define a reference to the Microsoft Access object.
|
|
I need to invoke a VBA macro within an Excel workbook from a python script. Someone else has provided the Excel workbook with the macro. The macro grabs updated values from an external database, and performs some fairly complex massaging of the data. ...
Started by jbrogdon on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Excel's Application("Excel.Application") xl.Workbooks....
However, the following should help.
This info, plus the "Microsoft Excel Visual Basic Reference": http://msdn.microsoft.com/en-usI am sorry, I dont know python enough.
|
|
I need to simply go through all the cells in a Excel Spreadsheet and check the values in the cells. The cells may contain text, numbers or be blank. I am not very familiar / comfortable working with the concept of 'Range'. Therefore, any sample codes ...
Started by Ryan Liang on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
Function://www.java2s.com/Code/VBA-Excel-Access-Word/Excel/Checksvaluesinarange10rowsby5columns.htm It seems are hosted outside the boundaries....
In Excel VBA, this function will give you the content of any cell in any worksheet.
|
|
Hi, I am working on a spreadsheet with lots of VBA code in it. Most cell references use numbers, e.g.
Worksheets("Sheet1").Cells(someRow, someColumn)
I am wondering if there is any easy way to find out exactly which cell is being referenced - is it possible...
Started by a_m0d on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You can do.
Another way to go would be to add a watch in the VBE (Visual Basic Editor).
Is refereeing to.
|
