0
It can be done easily by addingWorksbooks.open Filename:=command in macro.
Eg: Workbooks.Open Filename:= _"C:\Documents and Settings\abcabc\My Documents\Company List.xls"
If you like to create a particular macro for this purpose, the following lines will be helpful for you
Sub OpenWorkbook()
'
' OpenWorkbook Macro
' To Open Another workbook automatically
'
'
Workbooks.Open Filename:= _
"C:\Documents and Settings\ABABC\My Documents\Company List.xls"
End Sub
Hope this will solve your issue
Balu
What else can I help you with?
How do you Create Macro on One Workbook and then Let User Choose Location on Another Workbook They Want Macro to Run on?
One way would be to prompt the user to choose a workbook from those currently open (or browse for one that isn't). However, an easier approach is to simply run the macro on the currently active workbook by assigning the macro to a toolbar button.
How can you create a macro in Excel that saves the day's income in a workbook and then creates a new workbook every week?
how am i surpose to no?? go on the internet and find out for your self !!
What does the XLSM extension mean?
It is a macro-enabled workbook from Office 2007.
Create date macro in excel?
The following is a record macro copied into the workbook open section of the workbooks properties. Enters date in a1 Private Sub Workbook_Open() Range("a1").Activate ActiveCell.FormulaR1C1 = Now() Selection.NumberFormat = "dd/mm/yyyy;@" End Sub The macro run's it's self when the file opens
What tool is used to automatically create new formulas based on the first formula typed?
I believe you are referring to a macro. Could also be an IF statement.
How do you edit a macro stored in your personal macro workbook in excel?
You can open the Macro dialog box by pressin Alt - F8. Then choose the macro you want and click Edit and it will bring you into the code of the macro. You do need to be careful and to be sure you know what you are doing before changing anything.
What is a macro recorder for shortcut keys?
A macro is a record of a series of key presses, and is saved with a macro name. When the macro name is run, the previously saved key presses are automatically carried out.
What is another word for macro culture?
religion is a macro culture, a macro culture is a sub division of a culture
What is the file extension that indicates an Excel file?
Excel 2003: .xls = Workbook .xla = VBA Add-in .xlb = Toolbar (where custom toolbar settings are stored) .xlc = Chart .xld = Dialog (from older versions of Excel) .xlk = Archive (Excel spreadsheet backup) .xll = DLL Add-in .xlm = Macro .xlt = Template .xlv = VBA Module .xlw = Workspace (collection of multiple Workbooks) Excel 2007 and Excel 2010: .xlsx = Workbook (XML format) .xlsm = Macro-enabled Workbook .xlsb = Excel Binary Workbook (instead of XML format) .xltm = Macro-enabled Template .xlam = Add-in (XML format)
What is macro invertebrates?
Macro-invertebrates are animals that are big enough to see with the naked eye, and that do not have a backbone.
What is macro call?
Nested macro calls refer to the macro calls within the macros. A macros is available within other macro definitions also. In the scenario when a macro call occurs, which contains another macro call, the macro processor generates the nested macro definition as text and places it on the input stack. The definition of the macro is then scanned and the macro processor complies it.
What is the definition of the word macro?
In computer terms, a macro is a way to automate a task that you perform repeatedly or on a regular basis. It's a series of commands and actions that can be stored and run whenever you need to perform the task. You can record or build a macro, and then play the macro to automatically repeat the series of commands or actions.
