Opening a spreadsheet using VB
Basically you are asking how to use automation to automate Excel. Here are
several examples: http://support.microsoft.com/search/...false&numDays= The above should all be on one line in your browse. For specific code to use in Excel, all you need to do is turn on the macro recorder and perform those actions manually. Turn off the macro recorder, then view the code recorded. Then you can adapt that code to an automation scenario as shown above. -- Regards, Tom Ogilvy "zac" wrote in message ... Hello, I have a spreadsheet (XP) with links to query's in Access XP and SQL 2000 that needs to be opened and refreshed (Refresh All button is the one that works when done manually) on all tabs. Would anyone be able to provide some sample code in VB 6 that would show how to open and refresh a spreadsheet, then save and close? The first 2 are more important though. thanks, Zac |
Opening a spreadsheet using VB
Tom,
As someone who regularly posts links, could I respectfully suggest that you take a look at www.tinyURL.com, which will do a similar job to condensing the URLs as Make A Shorter Link, but without the intermediate step via that site. In addition, you can add a link to your favourites that will generate a tinyURL from the active web page. I think you will like it. Regards Bob "Tom Ogilvy" wrote in message ... Basically you are asking how to use automation to automate Excel. Here are several examples: http://support.microsoft.com/search/...3D1033%26CDID% 3DEN-US-KB%26PRODLISTSRC%3DON&withinResults=&QuerySource=g ASr_Query&Product= vb6&Queryc=automation+excel&Query=automation+excel &KeywordType=ANY&maxResult s=25&Titles=false&numDays= The above should all be on one line in your browse. For specific code to use in Excel, all you need to do is turn on the macro recorder and perform those actions manually. Turn off the macro recorder, then view the code recorded. Then you can adapt that code to an automation scenario as shown above. -- Regards, Tom Ogilvy "zac" wrote in message ... Hello, I have a spreadsheet (XP) with links to query's in Access XP and SQL 2000 that needs to be opened and refreshed (Refresh All button is the one that works when done manually) on all tabs. Would anyone be able to provide some sample code in VB 6 that would show how to open and refresh a spreadsheet, then save and close? The first 2 are more important though. thanks, Zac |
All times are GMT +1. The time now is 03:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com