Search:

Thanks for the clarification!!! We'll try the publish option and see if that's what we need.

Hello: I have been tasked to migrate a web app.

I was provided these instructions:
https://www.codeproject.com/Articles/21465/Converting-an-ASP-NET-site-into-a-SharePoint-site

and told to...

Hello: I have a workbook with several worksheets on it.
Each worksheet contains one pivot. Each pivot's data source comes
from a worksheet within the same workbook.

I have code linked to a...

Hello: I have a package created in sql server 2008. It instructs to export data from sql into an Excel file.
In doing so, it overwrites a pre-existing Excel file each time.

I wanted to know if...

Hello: I'm working in sql 2008. I have a stored procedure where I create a table and insert into it a simple select statement.

When I run just the select statement into the analyzer, it runs...

Ok, thank you for your suggestion. I'm going to give it a try.

That's good confirmation....thank you for your help!

Proctor

Thank you...this does work; however, sometimes, when it hits the line: DataSource = tblLookupProductInitialize

it goes into cboProduct.selectedindex changed and for those times, it goes into it...

Thank you for your reply. I want it to select an item....

Hello:

I'm coding a windows app.

I'm having inconsistencies with the following code:



With cboProduct
.ValueMember = "ProductId"

I just noticed something in my 97-2003 file that contains data. It originated from an old software program that exports it from a crystal file. As a result, it doesn't place all the data into one tab...

Hi Arnoutdv: Thank you again for your help.

I get the error using (just Excel)....I go to the data -> connections -> add -> browse for more -> new source -> ODBC Dsn -> Excel - > I select my file...

Hello: thanks for your reply. Yes, I just tested saving to a xlsx format and it gives me that same error message...so it doesn't like that either.

Hello: I have an old program that saves data into an Excel file as format: 97 - 2003;

In Excel 2010, using vba, I get a copy of this file, open it, and save it as a .xlsb (binary) file format. ...

Got it! Thanks for your help.

Here's the code I used:


Sub MacroSaveAsBinanary(sMostCurrentFileName)
Dim rootPath As String
Dim sFullPath As String
Dim wb As Workbook

Hi Arnoutdv: Thank you for your reply.....can you please tell me how I can learn about this Excel automation? Is this something I would do via vba?

Thanks again for your help,
Proctor

Hello: Using VBA within my Excel 2010 workbook, I'd like to copy another excel file that was created using Excel 8 and has a .xls file extension to a .xlsb file extension.

Here's the code I'm...

Wow, I had no idea that I could do this!!!! You're correct, I did also need to include voucher and vend_num...guess I was just trying to simplify it
to get my results first.

Thank you so much...

Hello: I sum field "dom_amount" by grouping by voucher and ven_num in table ledger....so created this aggregate sql:



SELECT SUM(dom_amount) AS dom_amount
FROM dbo.ledger
GROUP BY...

Hi techgnome: I was able to get the results I wanted....the code you provided, spawned ideas which enabled me to do it.

I wanted to be sure to thank you for taking the time to provide me with...

Hello:

I have a sql statement:



SELECT
job,
trans_type,
CONVERT(VARCHAR(10), MAX(trans_date), 101) AS Trans_date,

Hello: I've created a macro for Excel that gets a dataset via sql server and puts it into a QueryTable as the datasource for a bunch of worksheets that have pivot tables.

The very first time the...

Hello: I have a macro that goes to the database and gets a recordset and returns it to an Excel worksheet.
The recordset is returned via a QueryTable:



With...

I have been working on this angel thus far. If I export the data to an excel sheet off the server, it runs fast (of coarse); however, I would then need to transfer this file (which is 10 megs...

Hello: I have an Excel sheet that contains an external connection to SQL server to retrieve data
for pivot tables.

When I run it from a VPN, it's extremely slow to read it all. (15 min)
There's...

I'm going to be sure to add what you just said in my notes......
Is there a way to use addrange when working with a datatable?

thanks again - Proctor

.paul, thank you so very much for responding and letting me know this. I didn't have the order correct. I wasn't understanding what display member did but now I understand that it's setting the...

Hello: I wanted to know if I'm going about populating my combo boxes correctly, or if this behavior is normal.

Here's the code that populates a combo:


Private Sub PopulateJobsFilter()
...

Well, I found a hack solution I wanted to share in hopes something better will come along as the result of it.

Here's what I'm now doing in my RefreshALLPivotTables sub:

<code>
Sub...

Hello: I have 2 excel files. One contains pivot tables and also the macros.
The other, contains just the data and is used as the external data source for the pivot tables.

One of my macros,...

After all that and struggling a full day on this, shortly after posting this, I resolved the issue.
I added this one line in the cboStatusFilter_SelectedIndexChanged event.

...

Hello: I'm working on a windows form that has a datagridview and a filter above it.

When the page first loads, the filter is set to 'UNASSIGNED'. It's possible that at times, there could be no...

Yes, I finished it and it works great! I'm very happy with it.

Thanks again!

Proctor

jmchilhinney: I wanted to write you and thank you for that very creative solution. I followed your instructions and have gotten it to work!!!

Thank you again for providing me with this idea for...

jmchilhinney: Thank you for explaining this to me.
Do you know which event I would do this on?
I'm also wondering what effect this might have in regards to performance.

I was thinking I could...

Hello: I have a windows form that contains a datagridview which is databound.

One of the columns is a DataGridViewComboBoxColumn.

When the form loads, I bind the grid and I add the columns. I...

I was able to get my connection to open using this code:

Set cnn = New ADODB.connection
With cnn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "User ID=Admin;Data...

Hello: I have an excel file with pivot tables for each worksheet.
The datasource comes from an external xlsb file. I currently have the connection set up via the data tab. The pivot tables data...

oh...I see what you're saying. No, unfortunately, my boss wants the entire enchilada.

I wonder how others would deal with this issue. Do you think it's common to break it out so that the data is...

How do you mean....? Do you mean to try to bring less fields?

Thanks,
Proctor