Welcome to MacBoardz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Converting VBA macros to XML with Excel 2007?

  
   Macintosh computer (Home) -> Excel RSS
Next:  Font Smoothing in Excel  
Author Message
Halibut

External


Since: Jan 27, 2008
Posts: 1



(Msg. 1) Posted: Sun Jan 27, 2008 8:05 am
Post subject: Converting VBA macros to XML with Excel 2007?
Archived from groups: microsoft>public>mac>office>excel (more info?)
I haven't bought Office 2008 yet. But my decision would be speeded if it were possible to open spreadsheets with macros or functions done in Excel 2004 and save those macros/functions to XML in Office 2007 format. Thye could then be brought back into Office 2008 where they should work. Is that possible? Because I really can't stand the idea of converting some really complicated functions by had. From what I have read on the MS webpages, you can save VBA off into XML.<br>
<br>
The real problem is finding someone who has Excel 2007 installed. In the corporate world where I work, no one has it.

 >> Stay informed about: Converting VBA macros to XML with Excel 2007? 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3054



(Msg. 2) Posted: Sun Jan 27, 2008 10:30 am
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article ,
Halibut RemoveThis @officeformac.com wrote:

> I haven't bought Office 2008 yet. But my decision would be speeded if it were
> possible to open spreadsheets with macros or functions done in Excel 2004 and
> save those macros/functions to XML in Office 2007 format. Thye could then be
> brought back into Office 2008 where they should work. Is that possible?
> Because I really can't stand the idea of converting some really complicated
> functions by had. From what I have read on the MS webpages, you can save VBA
> off into XML.<br>
> <br>
> The real problem is finding someone who has Excel 2007 installed. In the
> corporate world where I work, no one has it.

Couple of clarifications that probably need to be made...

1) Office 2007 and 2008 both use a new XML *file format* (XML for
"Extended Markup Language"). Office 2008 can read and write the XML file
formats, including those which contain VBA macros (e.g., .xlsm), but
doesn't execute VBA.

2) All versions of Office from XL4 -> X12 support *XLM* macros - XLM for
"eXceL Macro language". Note the different order of the letters. These
macros exist on macro sheets in workbooks.

3) As far as I know, there are no tools available to automatically
convert VBA to XLM. In many cases, macros can be converted by hand
(assuming you know both VBA and XLM).

4) Since you can write XLM macros in ALL versions of XL, there's no need
to choose XL2007. The macros can be written in XL2004 or XL2008 just
fine.

 >> Stay informed about: Converting VBA macros to XML with Excel 2007? 
Back to top
Login to vote
Halibut

External


Since: Jan 27, 2008
Posts: 2



(Msg. 3) Posted: Sun Jan 27, 2008 12:53 pm
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Ah. Yes. There is this problem with conversion, and yes I know it won't be simple. But I'll leave this to ponder from the MS Office 2008 page on what what to do if your VBA macros don't run:<br>
<br>
" Solution: Save the macro in another macro-enabled file format.<br>
Macros are preserved when you save a file in any of the macro-enabled file formats, even if you've made changes to the contents of the file.<br>
In the This file contains Visual Basic macros alert that appears in Office 2008 when you open a file that contains a Visual Basic macro, click Open.<br>
On the File menu, click Save As.<br>
On the Format pop-up menu, select one of the following macro-enabled file formats.<br>
Excel Macro‑Enabled Workbook (.xlsm)<br>
Excel Macro‑Enabled Template (.xltm)<br>
Excel Binary Workbook (.xlsb)<br>
Excel Add‑In (.xlam)<br>
Excel 97‑2004 Workbook (.xls)<br>
Excel 97‑2004 Template (.xlt)<br>
Excel 97‑2004 Add-In (.xla)"<br>
<br>
Maybe they are great programmers but have a bit of trouble with the English language.<br>
<br>
Thanks for all the comments.
 >> Stay informed about: Converting VBA macros to XML with Excel 2007? 
Back to top
Login to vote
Tobias Weber

External


Since: Jul 29, 2003
Posts: 104



(Msg. 4) Posted: Sun Jan 27, 2008 6:36 pm
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Imported from groups: per prev. post (more info?)
Back to top
Login to vote
Tobias Weber

External


Since: Jul 29, 2003
Posts: 104



(Msg. 5) Posted: Sun Jan 27, 2008 6:39 pm
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Imported from groups: per prev. post (more info?)
Back to top
Login to vote
Halibut

External


Since: Jan 27, 2008
Posts: 2



(Msg. 6) Posted: Mon Jan 28, 2008 6:45 am
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks Bob. I has passed the bit I quoted above to a programmer friend of mine and we came up with both interpretations. Either it would or it wouldn't. I bet on it wouldn't. Enough said. Subject is dead.<br>
<br>
Bill
 >> Stay informed about: Converting VBA macros to XML with Excel 2007? 
Back to top
Login to vote
Bob Greenblatt

External


Since: Feb 11, 2005
Posts: 390



(Msg. 7) Posted: Mon Jan 28, 2008 9:35 am
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 1/27/08 3:53 PM, in article ee8ad7c.3 DeleteThis @webcrossing.caR9absDaxw, "Halibut"
<Halibut> wrote:

> Ah. Yes. There is this problem with conversion, and yes I know it won't be
> simple. But I'll leave this to ponder from the MS Office 2008 page on what
> what to do if your VBA macros don't run:
>
> " Solution: Save the macro in another macro-enabled file format.
> Macros are preserved when you save a file in any of the macro-enabled file
> formats, even if you've made changes to the contents of the file.
> In the This file contains Visual Basic macros alert that appears in Office
> 2008 when you open a file that contains a Visual Basic macro, click Open.
> On the File menu, click Save As.
> On the Format pop-up menu, select one of the following macro-enabled file
> formats.
> Excel Macro‑Enabled Workbook (.xlsm)
> Excel Macro‑Enabled Template (.xltm)
> Excel Binary Workbook (.xlsb)
> Excel Add‑In (.xlam)
> Excel 97‑2004 Workbook (.xls)
> Excel 97‑2004 Template (.xlt)
> Excel 97‑2004 Add-In (.xla)"
>
> Maybe they are great programmers but have a bit of trouble with the English
> language.
>
> Thanks for all the comments.
We’re not too bad with the English Language. The problem is correctly
interpreting ambiguous posts. Upon rereading your original posts, I can
offer:
- VBA macros will not work in Excel 2008.
- Excel 2008 WILL open workbooks containing VBA macros. It will completely
ignore them, AND save the macros untouched when the workbook content is
altered and saved IF you ask it to do this when the file is opened.
- There is NO automatic conversion from VBA to XLM Macros
- Old XLM macros WILL work, and new XLM macros can be written, modified and
used in Excel 2008
- Your expectation that VBA macros can be converted by opening the workbooks
in Excel 2007 and saving them in the new XML file formats and then reading
them into Excel 2008 is wrong. The workbooks should be fine, but the macros
will not be converted and will not work in Excel 2008.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
 >> Stay informed about: Converting VBA macros to XML with Excel 2007? 
Back to top
Login to vote
Byron Allred

External


Since: Mar 18, 2008
Posts: 1



(Msg. 8) Posted: Tue Mar 18, 2008 5:18 pm
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
How much trouble is it to re-write VBA macros to XML macros in Excel 2008? I don't know a great deal about Excel, so I'm wondering what the learning curve would be like. I have a spreadsheet with a bunch of VBA macros that I would need to be converted in order to use Excel 2008.
 >> Stay informed about: Converting VBA macros to XML with Excel 2007? 
Back to top
Login to vote
Bob Greenblatt

External


Since: Feb 11, 2005
Posts: 390



(Msg. 9) Posted: Wed Mar 19, 2008 8:33 am
Post subject: Re: Converting VBA macros to XML with Excel 2007? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 3/18/08 9:18 PM, in article ee8ad7c.6 RemoveThis @webcrossing.caR9absDaxw, "Byron
Allred" wrote:

> How much trouble is it to re-write VBA macros to XML macros in Excel 2008? I
> don't know a great deal about Excel, so I'm wondering what the learning curve
> would be like. I have a spreadsheet with a bunch of VBA macros that I would
> need to be converted in order to use Excel 2008.
The learning curve is very high. The XLM "language" is not really a
programming language, but an extension of Excel formulas. My educated guess
is that you can convert (code, test, and verify) about 10-15 lines of VBA
code per hour assuming you are thoroughly familiar with both VBA and XLM.
(This is the basic metric I would use in establishing a quote for
conversion.)

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
 >> Stay informed about: Converting VBA macros to XML with Excel 2007? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Converting Lotus Macros to Excel Macros - I have a macro in Lotus that I am so far unable to rewrite in MS Excel format (Visual Basic?) Macro name:\D Macro instructions (in Lotus speak): {ANCHOR}{END}{DOWN}~{EDIT-COPY} Macro Purpose: To select and copy all data in a column below an..

Excel 2007 - Unable to open an any excel file a second time - In Excel 2007 (Microsoft Office Home & Student), I can create and open a file with no problem, initially. The problem only occurs when you try and re-open the same, or any other Excel file. The program opens with a blank (light blue) screen with...

Excel 2007 not responding - My 2007 version of Excel is unusable. Whenver I make an update, even something as simple as changing the font size in a cell or cells it takes forever. As soon as I hit the enter key I get the hourglass, within seconds a totally white screen with..

Excel 2007 Performance - I just purchased a Dell Vostro 1500 with Vista Business installed. I also had installed Excel 2007. My first impression was that I did not like the new interface. However, after a brief period of time, I have come to like the new look. My issue is...

Excel 4.0 macros - My grandfather is using Excel 4.0 on Office 98 because of a boatload of macros her created (way back) and needs to keep. I'd like to get him to upgrade to 2004. Will the macros transfer up (they haven't with previous versions)? Thanks Hope c. Ibook g...
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]