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.
HOW CAN MACRO BE STORED?
Macros can be stored in various ways depending on the software being used. In applications like Microsoft Excel, they can be saved within the workbook itself or in a separate macro-enabled file format (e.g., .xlsm). Additionally, macros can be stored in a personal macro workbook, allowing them to be accessible across multiple workbooks. For programming environments, macros may be stored in script files or code libraries.
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)
How do you create a macro in QA4?
To create a macro in QA4, first open the Macro Editor from the "Tools" menu. Use the scripting language provided to define the sequence of actions you want the macro to perform, ensuring you specify any necessary parameters. After writing your script, save the macro with a descriptive name. Finally, you can run the macro directly from the Macro Manager or assign it to a keyboard shortcut for easier access.
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.
