|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
Are there any Excel VBA developers in the house?
I need to know how Excel VBA is doing in Nigeria in particular, in Europe, its hot cake, especially if you are working in the financial sector, its more common with Traders and Banks.
I think so many people...
Started by doshbass ( m ) on
, 14 posts
by 9 people.
Answer Snippets (Read the full thread at nairaland):
I just wanted to be sure, but it looks as if its true, Excel ....
Be good with Excel Functions; at least Excel vba in Nigeria before.
With Visual Basic for Applications (VBA), you need the following:
1.
|
|
I'm developing an app in which I'm trying to import an openoffice spreadsheet into a visual basic 2010 express form app so it will be visible in the app as a stand alone and not needing open office to load. I want the spreadsheet to load in my app the...
Started by philkor on
, 14 posts
by 3 people.
Answer Snippets (Read the full thread at oooforum):
VB and Excel play very well together since 2 actually looking for a ....
I'm to spreadsheets (or pivot tables, or Writer tables).
If you really want to misuse a spreadsheet for this, you are far better off with Excel.
Decades.
|
