Excel Macro Editing -
My Problem:
I am retiring an old server and moving all user files to a new server. Many of the Excel spreadsheets contain macros that may or may not refer to \\<OldServerName>.
After the move, I won't know which macros are broken until the users try them (Bad place to be for IT person).
Has anyone written any VB to open Excel macros in a series of spreadsheets and do a search and replace?
or
The least I would need would be a script to find the spreadsheets that contain macros.
Macro in access and excel -
I have a macro in access set up that opens a query then transfers that data to a workbook in excel. From there, I have a macro that I wrote that will run in excel.
How do I get the macro to run in excel as part of the step from my access macro?
Rather than running my ma
How to see macro code -
I got an Excel file that contains macro, if choosing 'enable macro' to open it, macro will begin to run automatically, launch a form window and minimize the Excel file (cannot maximize or restore it), which makes me not able to see the macro code in the Excel file.
If I choose to 'd
How to use all features from VB6.0 in excel macro -
I had created a userform in my excel project, i would like to make it's bordertyle to be "0-none" as in VB6.0, so the form will load as borderless and without minimize, maximise, and close button.
This can be easily done in VB6.0, but no such feature in excel macro,
So m
Calling other Applications and Macros from Excel -
Howdy!
I am trying to figure out how to open an access program, then run a specified macro in the access program then close it again. all from an EXCEL macro.
Also, how to call another excel macro from an excel macro.
Call Outlook from excel and have it run a macro in outlook
Excel - Macro -
Hi! I create a macro in excel that is working fine.
Now, i need to pass arguments to macro. This is possible? When i include an argument it was hiding of macro list.
thanks
bye
Pause Macro to allow for editing -
Hi all,
Is there a way to pause a macro at a certain point to allow for editing, and then allow the user to resume the macro where it left off?
I'm automating a data-entry process that will return an error message if some of the data is incorrect. What I would like to do is have
How to add a macro in Excel from VB -
Hello,
can someone help me... HELP !!!
I would like to insert a macro in an excel file from a VB application.
So I use an Excel.Application, but after what is the function that i must use to insert a VB macro in the ActiveWorkbook. My macro must be executed as soon as the Excel
Get $$$ for programming an Excel VBA macro -
I need to quickly build an Excel macro, but don’t have any experience in VBA. I have the requirements worked out, its just a matter of putting it all together.
Money will be paid through PayPal, or another way if preferred.
This macro will not take long for an experienced Exce
Export Out to Excel -
Hi All,
Im trying to write a small proceure from access to call excel and construct a small macro. My question is how do I write a macro to make a macro? For example in my Access applicaiton the user would click an export to excel button. THis button would launch excel and populate
Placing Macro in the XLStart folder -
Hi All,
I know that by placing my Excel spreadsheet tha contains a macro in the XLStart folder I can use it to run a macro on a certain Excel spreadsheet if I go to Tools --> Macro --> Macros --> Run.
Problem is, How can I do this for one specific excel workbook. When my
Slow Excel Macro Thru VB6 -
This just isn't making sense. I have an excel macro that I execute from a VB6 application. The application opens Excel in the background and runs the macros and then saves the workbook. The problem is that when I run the macro from excel it goes realy fast but when I run it thru the VB
Run an Excel Macro from VB -
I have built a macro in excel that takes care of all the formating and data manipulation I need to do for a report I create for my team. Now I want to have a form with a button on it in VB that when I click will then run my macro in excel "Eldon_Final_Macro".
Aralius
Running excel macro across all sheets -
Ok, I've written a macro in excel that I want run across all spreadsheets in an excel workbook when there the number of worksheets is not always the same.
So far the macro runs, but it repeatedly performs the same action on the same spreadsheet and leaves the others untouched. How d
[Excel]Passing variable between macro of excel and word -
i have create macro for both excel and word, so there is 2 macro will be running Simultaneously, my problem is these 2 macro must be able to passing value to each other, is any method to do that?
Answering the other input box -
Is it possible via one vb app to answer a message box in another app (mainly excel)
meaning I have a program which Im trying to work with..basically interface with. I
cannot whatsoever modify the existing GERMAN code nor can I copy the german code
and paste it to my app so these
How to activate a macro in excel * RESOLVED* -
Dear all,
I have a simple task for you.
In excel VBA I have written a macro. I want to call the macro whenever the value of the cell is changed.
Is it possible? if so, please post the ciode also ?
How to Open PDF Files Via Visual Basic Macro Code -
How can I code a Macro in Excel to search in a preset directory and pull out, aka open/run
a certain Adobe Acrobat .pdf file automatically?
Is this even possible to code in Excel Macro or is it out of its scope of what Excel VB code can do?
Right now I have a very repetitive t
Running a Macro from VB6 -
Hello Everyone
This is time i am almost near to complete my project .. so far what i have done is extracted required information from a text file ,created an excel file and stored that information in sheet of excel ( with the help of VB6 form ) . now i have a macro and i want to run
How do I run a macro automatically once excel opens -
Hi guys,
I am currently extracting data to a spreadsheet from my VB app. However, once a user extracts the data successfully and Excel opens I want to run a macro without them having to click on Tools-->Macro-->Macro-->Run.
How do I do this. Someone please help. It's qui
Excel macro (code) -
Hi I am using Excel with VB. and I am using a macro that I made with excel, this macro activates a complementary macro that comes with Excel.
When I run my macro from Excel it works ...but from VB it doesnt ???
When I run the program It tells me that it cannot find the macro file
macro activation -
I have a Markov model in excel that is opened by a VB exe file. The excel model is activated from the VB file by opening one of the sheets which in turn calls a macro from the worksheet_activate sub. A better way would be to call the macro in the excel application from the VB code. Doe
Can an Excel macro launch a Word macro -
Like the title says:
Can an Excel macro launch a Word macro?
And if so, how?
There it is, short and sweet.
Anybody got a quick answer? Please? I hope?
If so, I may be able to ditch another thread I have going, since that one may be irrelevant!
passing data from an excel macro to VB -
I'm executing an excel macro from a VB module. The excel macro has a loop and within this I want to pass data back to VB. Anyone know how?
the following code works but only returns the data after the macro in excel has finished. I want to update the label in VB during the loop so pro
Excel, macro and VB -
Hi,
First of all This is what I would like to do
I have an excel workbook with one worksheet I use my vb program to update the worksheet..All is fine except when the records exceed 23 etc., then I have to create another worksheet(which looks exactly like the first(blank)) within
disabling Excel workbook macro from VB -
Hi .. i hv got some prob with Excel VBA code .. if any one can help me out .. I am doing soem actions on opening of workbook in Excel through my DLL .. DLL is associated with Excel it does some actions while a workbook is opened .. but some work book has macro code which dont let my co
Saving an excel document. -
I´m going to import a lot of excel files to my access db. The thing is I must run a macro on them before the data can be imported.
When the macro is done, I want to save the excel document as the value of cell A1. (i e save as [A1].txt).
I tried to include the saving in the macr
link an excel macro into a commandButton click event -
This an easy question :
I have a macro named "sort" in my excel file.
I have a button on the sheet wich I want to execute this macro,
But how can I do that?
Excel macro -
I need an Excel macro that does the following:
After I have selected a group of cells with the mouse, I exceute the macro (hotkey = ctrl/something) and the (numeric) contents of all the cells in the range gets divided by 1000. May be easy but I just can't figure out how to do it.
EXCEL Macro AutoRun -
Hi,
How can I make an EXCEL macro automatially run when the file opens? Without having to press the macro run button.
Regards
ger
How to kick off an Excel macro with VB (RESOLVED, THANKS ) -
I am working with an Excel Spreadsheet that has a macro called convert_data. How can I kick this macro off while processing the file in VB????????
Thanks in advance
how to run macro when Excel is just opened -
To let macro run, the only way I know is to open Excel file first, then hit Alt + F8, and click 'Run' button, or hit F11 and F5, then it will start running.
But how can we let macro run when we just open the Excel file? Thanks.
Calling Excel Macro's from VB .exe -
Hi, I have a simple .exe that opens an Excel sheet, runs a macro and closes:
<code>
Sub Main()
'Opens Excel, runs a macro and closes
Dim xlApp As Excel.Application
Set xlApp = CreateObject("Excel.Application")
xlApp.Application.DisplayAlerts =
Populate Combobox from excel -
Can anyone help me?
I have a combo box, and i want to populate it from a range in excel. Can i do this from a named range in excel? in a similar way as to the Text Validation in excel?
Also how do i call a macro from VB in Excel?
The basic list is some client names, and i want
$$ - Need an XL mac 2 periodically retrieve web n send or save -
I either need some help developing or an individual to develop for me an excel macro to work in office XP. The macro monitors a web page and if data changes, copies it - reformats some of it and sends it out as an email (or could just save the update as htm - read below)
Here's what
How to add macros in Excel sheet -
I want to write a Macro on Excel Sheet which should open a user name & password form made in VBA. I have made the form in VBA & trying to link it with a macro, but the macro is not working on excel file load? How should I do this.
Excel 97 This workbook contains... -
Question -
I was writting a program in Excel 97 VBA and tested it with Macro Virus Protection enabled, and declined to enable Macros.
After the standard warning, I got the following message:
"This workbook contains a type of macro (Microsoft Excel Version 4) that cannot be
Saving a macro -
So I have successfully created my VB app within excel. How do I save it as a macro so I can run it with other excel files? I cant find a save as macro option.
Global Macro Problem -
Hey,
I am having a problem.
I would like to record a macro that i can run through a VB.NET app, but how do I create global macros with excel? I did it with word once and it worked fine.
Basically, I am creating new excel files with this program, and I then want to open up thi
Excel Macros and VB -
Hi all!!!
Is is possible to insert a macro from vb on a new excel file?
For example, I create it, fill it and, before closing if, I want to insert a macro on the file. Is it possible?
Another one: Can I execute a macro in excel from vb?
Setting macro security level in Excel -
I am initialising excel from within VB. I am then loading a spreadsheet that contains macros. I keep getting a warning that pops up about the macro whenever I load the spreadsheet. I know that within excel I can set the Macro security level. However how can I do this from my vb cod