| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click Button to Load External Data Into Spreadsheet
Hi Folks,
I'm trying to figure out the easiest way to create a spreadsheet template with an "update" button on it. When clicked, this button should tell Excel to grab data from an external database and place it in specified columns. Furthermore, this Excel template should be able to apply conditional formatting to the new data if it meets certain criteria. Do I need to know VB for this, or can a macro do this work for me? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click Button to Load External Data Into Spreadsheet
Via Data/Import external data you create a QueryTable. that querytable can be refreshed when you rightclick it and choose refresh from the popup. (alternatively you can put a button next to it to call the refresh method of the QueryTable object) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam simsjr wrote : Hi Folks, I'm trying to figure out the easiest way to create a spreadsheet template with an "update" button on it. When clicked, this button should tell Excel to grab data from an external database and place it in specified columns. Furthermore, this Excel template should be able to apply conditional formatting to the new data if it meets certain criteria. Do I need to know VB for this, or can a macro do this work for me? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click Button to Load External Data Into Spreadsheet
I have Excel 2007 & want to create a command button to "Refresh All" reports
in a workbook. Which command button would be best & can someone help me with the code? -- Thanks, Kevin "keepITcool" wrote: Via Data/Import external data you create a QueryTable. that querytable can be refreshed when you rightclick it and choose refresh from the popup. (alternatively you can put a button next to it to call the refresh method of the QueryTable object) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam simsjr wrote : Hi Folks, I'm trying to figure out the easiest way to create a spreadsheet template with an "update" button on it. When clicked, this button should tell Excel to grab data from an external database and place it in specified columns. Furthermore, this Excel template should be able to apply conditional formatting to the new data if it meets certain criteria. Do I need to know VB for this, or can a macro do this work for me? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click Button to Load External Data Into Spreadsheet
You can try this
Application.CommandBars.ExecuteMso ("RefreshAll") But why not add this button that is in the Data tab on the QAT -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "AFSSkier" wrote in message ... I have Excel 2007 & want to create a command button to "Refresh All" reports in a workbook. Which command button would be best & can someone help me with the code? -- Thanks, Kevin "keepITcool" wrote: Via Data/Import external data you create a QueryTable. that querytable can be refreshed when you rightclick it and choose refresh from the popup. (alternatively you can put a button next to it to call the refresh method of the QueryTable object) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam simsjr wrote : Hi Folks, I'm trying to figure out the easiest way to create a spreadsheet template with an "update" button on it. When clicked, this button should tell Excel to grab data from an external database and place it in specified columns. Furthermore, this Excel template should be able to apply conditional formatting to the new data if it meets certain criteria. Do I need to know VB for this, or can a macro do this work for me? __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click Button to Load External Data Into Spreadsheet
Ron,
Thank you for your quick response. The code you provided is what I needed. The reason for the command button is primarily for the end user that does even know what their ribbon tools are for. Check click a button right in front of the face. Also, is it possible to create a form that pops up saying "Please wait while report queries are running". Then go away when their finished? -- Thanks, Kevin "Ron de Bruin" wrote: You can try this Application.CommandBars.ExecuteMso ("RefreshAll") But why not add this button that is in the Data tab on the QAT -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "AFSSkier" wrote in message ... I have Excel 2007 & want to create a command button to "Refresh All" reports in a workbook. Which command button would be best & can someone help me with the code? -- Thanks, Kevin "keepITcool" wrote: Via Data/Import external data you create a QueryTable. that querytable can be refreshed when you rightclick it and choose refresh from the popup. (alternatively you can put a button next to it to call the refresh method of the QueryTable object) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam simsjr wrote : Hi Folks, I'm trying to figure out the easiest way to create a spreadsheet template with an "update" button on it. When clicked, this button should tell Excel to grab data from an external database and place it in specified columns. Furthermore, this Excel template should be able to apply conditional formatting to the new data if it meets certain criteria. Do I need to know VB for this, or can a macro do this work for me? __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click Button to Load External Data Into Spreadsheet
Hi AFSSkier
You can test if it will first finish the refresh before it run other code like this MsgBox "Start" Application.CommandBars.ExecuteMso ("RefreshAll") MsgBox "Ready" If this is true you can show a label or open a small userform -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "AFSSkier" wrote in message ... Ron, Thank you for your quick response. The code you provided is what I needed. The reason for the command button is primarily for the end user that does even know what their ribbon tools are for. Check click a button right in front of the face. Also, is it possible to create a form that pops up saying "Please wait while report queries are running". Then go away when their finished? -- Thanks, Kevin "Ron de Bruin" wrote: You can try this Application.CommandBars.ExecuteMso ("RefreshAll") But why not add this button that is in the Data tab on the QAT -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "AFSSkier" wrote in message ... I have Excel 2007 & want to create a command button to "Refresh All" reports in a workbook. Which command button would be best & can someone help me with the code? -- Thanks, Kevin "keepITcool" wrote: Via Data/Import external data you create a QueryTable. that querytable can be refreshed when you rightclick it and choose refresh from the popup. (alternatively you can put a button next to it to call the refresh method of the QueryTable object) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam simsjr wrote : Hi Folks, I'm trying to figure out the easiest way to create a spreadsheet template with an "update" button on it. When clicked, this button should tell Excel to grab data from an external database and place it in specified columns. Furthermore, this Excel template should be able to apply conditional formatting to the new data if it meets certain criteria. Do I need to know VB for this, or can a macro do this work for me? __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Load ws cell data into a textbox via click on chart datapoint | Charts and Charting in Excel | |||
| when importing data from external database does not load into wor. | Excel Discussion (Misc queries) | |||
| External lookups won't load | Excel Discussion (Misc queries) | |||
| VBA Excel - Load Data button | Excel Programming | |||
| VBA Excel - Load Data button | Excel Programming | |||
Hybrid Mode
