| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a macro for this?
I created a SQL script, that eventually spools an Excel file. This spool file is the source file for a total report (destinatio file) in Excel. I already tried to work with links between the sourc file and the destination file, but when I than open the destinatio file, it can only updates the values if I also open the source file This is not what I want. I would like the destination file t automatically updates its value automatically wihtout having to ope the source file. Can I record a marco to do this? If so, can anyon explain how -- zimon7 ----------------------------------------------------------------------- zimon72's Profile: http://www.excelforum.com/member.php...fo&userid=3059 View this thread: http://www.excelforum.com/showthread.php?threadid=50284 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
| What is a macro, how to create and use it? | New Users to Excel | |||
| Using a macro to create a macro in another workbook | Excel Worksheet Functions | |||
| How to create a macro | Excel Programming | |||
| create macro | Excel Programming | |||
Threaded Mode
