Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add database values to a specific cell
I am building a report using DTS Packages. The data resides on a PSQL server.
What I want to do is take the results of a value in a table and put it on an Excel spreadsheet in a specific cell. What I have found are ways of taking information from the spreadsheet and putting it into an Access Database. How can I go from the database to a specific cell in a spreadsheet? Thanks in advance for your help, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add database values to a specific cell
worksheets("Sheet1").Range("B9").Value = variableValue
-- Regards, Tom Ogilvy "Jef S" <Jef wrote in message ... I am building a report using DTS Packages. The data resides on a PSQL server. What I want to do is take the results of a value in a table and put it on an Excel spreadsheet in a specific cell. What I have found are ways of taking information from the spreadsheet and putting it into an Access Database. How can I go from the database to a specific cell in a spreadsheet? Thanks in advance for your help, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add database values to a specific cell
I put this one line of code in my Visual Basic ActiveX Script Task, and that
is it? That will be outstanding!!! Thanks Tom. Thanks for the speedy reply as well. Jef "Tom Ogilvy" wrote: worksheets("Sheet1").Range("B9").Value = variableValue -- Regards, Tom Ogilvy "Jef S" <Jef wrote in message ... I am building a report using DTS Packages. The data resides on a PSQL server. What I want to do is take the results of a value in a table and put it on an Excel spreadsheet in a specific cell. What I have found are ways of taking information from the spreadsheet and putting it into an Access Database. How can I go from the database to a specific cell in a spreadsheet? Thanks in advance for your help, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add database values to a specific cell
What I want to do is take the results of a value in a table and put it on
an Excel spreadsheet in a specific cell. If you put that value from a table in a variable name VariableValue, and you have a reference to Excel and the workbook is open, then yes, you have a template for what you need. You might want to qualify it with your reference to the workbook xlbook.worksheets("Sheet1").Range("B9").Value = variableValue Enjoy! -- Regards, Tom Ogilvy "Jef S" wrote in message ... I put this one line of code in my Visual Basic ActiveX Script Task, and that is it? That will be outstanding!!! Thanks Tom. Thanks for the speedy reply as well. Jef "Tom Ogilvy" wrote: worksheets("Sheet1").Range("B9").Value = variableValue -- Regards, Tom Ogilvy "Jef S" <Jef wrote in message ... I am building a report using DTS Packages. The data resides on a PSQL server. What I want to do is take the results of a value in a table and put it on an Excel spreadsheet in a specific cell. What I have found are ways of taking information from the spreadsheet and putting it into an Access Database. How can I go from the database to a specific cell in a spreadsheet? Thanks in advance for your help, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add database values to a specific cell
If you need some way from Excel of reading the value from the table, and if
it is only one value, take a look at the SQL.REQUEST function. If it is more complex than that, search this site under topics MSQuery or ADO. -- - K Dales "Tom Ogilvy" wrote: What I want to do is take the results of a value in a table and put it on an Excel spreadsheet in a specific cell. If you put that value from a table in a variable name VariableValue, and you have a reference to Excel and the workbook is open, then yes, you have a template for what you need. You might want to qualify it with your reference to the workbook xlbook.worksheets("Sheet1").Range("B9").Value = variableValue Enjoy! -- Regards, Tom Ogilvy "Jef S" wrote in message ... I put this one line of code in my Visual Basic ActiveX Script Task, and that is it? That will be outstanding!!! Thanks Tom. Thanks for the speedy reply as well. Jef "Tom Ogilvy" wrote: worksheets("Sheet1").Range("B9").Value = variableValue -- Regards, Tom Ogilvy "Jef S" <Jef wrote in message ... I am building a report using DTS Packages. The data resides on a PSQL server. What I want to do is take the results of a value in a table and put it on an Excel spreadsheet in a specific cell. What I have found are ways of taking information from the spreadsheet and putting it into an Access Database. How can I go from the database to a specific cell in a spreadsheet? Thanks in advance for your help, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering Using Values In A Specific Cell | Excel Worksheet Functions | |||
Extract text within two specific values within a cell | Excel Worksheet Functions | |||
Specific cell values | Excel Discussion (Misc queries) | |||
specific cell values in two ranges | Excel Programming | |||
Exporting Cell Values Only To A Database | Excel Programming |