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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a macro for this?
If the link is properly established, it should update. Since what you ask
is normal behavior if you have the proper settings and proper links, there wouldn't be any special action which you would need to take or which you could take. -- Regards, Tom Ogilvy "zimon72" wrote in message ... I created a SQL script, that eventually spools an Excel file. This spool file is the source file for a total report (destination file) in Excel. I already tried to work with links between the source file and the destination file, but when I than open the destination 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 to automatically updates its value automatically wihtout having to open the source file. Can I record a marco to do this? If so, can anyone explain how? -- zimon72 ------------------------------------------------------------------------ zimon72's Profile: http://www.excelforum.com/member.php...o&userid=30592 View this thread: http://www.excelforum.com/showthread...hreadid=502842 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a macro for this?
Tom, If it would work, I wouldn't post... So, it doesn't work. The problem is - I think - that although it looks like my sql script exports an .xls file, Excel sees and recognizes it as an .xls file as soon as I open it in Excel. So, I can only update my destination file after I open my .xls source file in Excel. And for this last part, I would like to record a macro. -- zimon72 ------------------------------------------------------------------------ zimon72's Profile: http://www.excelforum.com/member.php...o&userid=30592 View this thread: http://www.excelforum.com/showthread...hreadid=502842 |
Reply |
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 |