VBA Converter
Sep 16, 2007
I have just upgraded to Office 2007 and am having problems with some XL spreadsheets.
Some of the spreadsheets have VBA and when XL 2007 opens them it gives the error msg telling me I need to install a "VBA Converter".
First question is...what on earth is that!?!?
Second question is...why do I need one, isn't it backwardly compatible?
Third question...where do I get one from?
I did check the Microsoft web site and all I could find was a page directing me to ask their customer support!
View 9 Replies
Feb 22, 2008
I have one JPG format file, is there any way where i can convert this JPG format file to Excel file to make some changes.
View 9 Replies
View Related
Mar 8, 2012
So I have table that consists of several columns describing a single transaction. I want a macro to translate the (potentially thousands) of rows into a single cell for each row on another worksheet.
The rows need to be formatted by transaction type. The problem is that I know nothing of excel syntax .
I was thinking something along the lines of a case loop, if possible:
Case D1 = BUY
Output("You bought ("C1") on ("A1") for the amount ("E1")")
Case D1 = SELL
Output("You sold ("C1") on ("A1") for the amount ("E1")")
etc.
How would I get that into workable excel code, if possible?
View 2 Replies
View Related
Nov 30, 2007
I am looking to write a small macro to convert all figures on a page to either EUR or $ at the click of a button
View 5 Replies
View Related
Nov 4, 2008
I am using Excel 2002 on an xp system
The database is of information relating to homes for sale in my area.
When I try to open my database I am getting a message in a box that flashes for a second that says:
File conversion in progress
there is a "cancel" option with this message but there is only a half second to click on it which I am unable to do.
Then this message appears:
The converter failed to open the file.
With this message the program opens, but the screen is a dark grey. Very few of the buttons are useable.
These messages only started appearing recently. The file has been in constant use for several months.
The data seems to be intact evidenced by the file size. But the data is not viewable.
View 10 Replies
View Related
