Recent content by jcbirch

Will this work if the queries are nestled as "RunSQL" statements within different macros? They are not "queries" per se. I'm not sure how to code for a Macro definition, or Macro contents.

Hi, I have an Access VB module that creates an Excel report. Part of the Access VB module calls a macro that runs a series of SQL statements based upon what the user specified. Different users have different business rules, thus there are multiple macros, and I select the appropriate one...

You're a genius! That worked perfectly. Thanks so much.

Hi, I know it's bad form, but I want to run a SQL statement with a GROUP BY wherein not all my data is in the GROUP BY clause nor aggregated. I just want to randomly pick a few fields for inclusion. Long story as to why... but trust me it's fine. Fields are as follows: sender domain(s) date...

The problem is, I don't know how to form statements that define/call objects like words or emails or attachments or anything like that... so basically, I don't know where to start. I figured there are probably lots of people out there who would be able to accomplish this in just a few lines of...

Hi, Hope someone can help me. This challenge seems like a doozy to me, but I figure it would be very easy to someone who knew what they were doing. I have experience with SQL programming and using VB to automate Excel reports (formatting, page setups, etc.) but this is way above my head. I...

Hi, I'm using VFP 6.0 with Service Pack 5. I'm trying to automate an import process because I have to repeatedly import multiple tab-delimited text files. I am creating a new table structure, then using the "APPEND FROM" command to import the data. My issue is this: if one of the datetime...

Sorry, actually, the syntax should be something like: .ScaleHeight(1.33, 0, 1) .ScaleWidth(1.33, 0, 1)

Are you sure you have the correct object name ("Chart 1")? The way to tell is to deselect the object, record a new macro, select the object, stop recording, then view the macro code and see what it's called. Once you've checked that, try this: oSheet.Shapes("Chart 1").ScaleWidth(1.12) -Jessica

Hi, I'm creating an Excel report with a cover page (1st sheet) and a chart on the 2nd sheet, chart values in fields D35-F39. I can create the chart just fine. However, when I try to specify the location as an object on Sheet3, it totally disregards my specifications, and instead places the...

This might work for you too: CREATE TABLE MyTable ( ; Column1 c(25) NULL ; Column2 n(15,4) NULL ; Column3 d(8) NULL ; Column4 y NULL) SELECT MyTable APPE FROM "MyFile.xls" TYPE xl8 SHEET "Sheet1" Make sure you unfreeze any frozen panes first, and that the file is in Excel 97 format...

After hours of struggling, here's what I have found out. The next-to-last solution above works great for copying part of a sheet in a workbook to another tab in the same workbook. The last solution helps with copying part of a sheet in one workbook to another sheet in a separate workbook...

Yes, the code listed above was generated completely within Excel doing the steps I'm trying to convert to VFP-flavored VB. VFP doesn't seem to like the ARRAY() syntax, but I haven't figured out a way around it yet. The code starting with "Before:=" will need to be converted somehow as well. I...

Hi, I need some help with copying Excel sheets from one workbook to another using VFP 6. What I want to do is create several data tabs. Then create several report tabs, and copy the appropriate data tabs into each report as appropriate. The code below just copies several sheets from one open...

That is great. Thank you!