Search results for query: *

Have you tried to play with NextRecordset to get proper data (see https://paulkroon.com/2009/09/20/excel-vba-macro-to-execute-a-stored-procedure/ and https://learn.microsoft.com/en-us/sql/ado/reference/ado-api/nextrecordset-method-ado?view=sql-server-ver16 )?

I will test this tomorrow, but basing on https://learn.microsoft.com/en-us/office/vba/word/Concepts/Customizing-Word/finding-and-replacing-text-or-formatting I would try: ... Set oRng = wdDoc.Content With oRng.Find .Text = "@PrimaryPhaseNumber@" .Replacement.Text =...

Without testing, can you try to use Word as editor to edit the mail body, as gmayor suggests in http://www.vbaexpress.com/forum/archive/index.php/t-64933.html ?

It seems that this feature gone. At the very bottom-right of each page you can find small 'Help' with available BB-codes and emoticons (seem to be the same as in 'good old days'):

Yes, it is easy to get lost after this big change and there is a lot to learn. My first impressions after a couple of days of browsing the site: there is a lot to customize. I changed style to NOVA, for me it is better than the classic one. I reviewed and adjusted all profile settings, esp. it...

There are some issues to solve. First, declare worksheets, use As Sheets instead: Dim wsSheet As Sheets Second, work with the array of worksheet. It is possible only to apply logic from single sheet and apply to the rest, and it seems that activate/select is required: wsSheets.Select...

With indents you can easily find closing End If missing: For Each ctl In Me.Controls If TypeOf ctl Is CommandButton Then If ctl.Name Like "cmdOrder*" Then ctl.Visible = True ctl.Caption = DLookup("[cmdCaption]", "tblCmds", "[cmdID]='" & ctl.Name & "'")...

Excel export to pdf is in fact printing to pdf, with current page setups for each sheet, plus additional settings. So you need to either set page setups for each sheet or use preformatted workbook or template, open it (or create new workbook from template) and fill it and next export. A lot of...

It is hard to guess the data model filters and calculations behind your power pivot table. If the input tables are Excel ones, you can attach sample workbook for analysis - leave few rows in each table with false data, but still exposing the problem you have in pivot table. Remove some private...

The PT layout depend on its format, not the data source. The difference is, if pivot table is based on data model, multiple tables, measures and relations defined in the model are available in single pivot table. Measures or calculated fields have to be in 'values' area in PT (MS info concerning...

In my case default pivot table layout has one filter button. The list to filter (for row fields) depend on the field with data in active cell. combo

With a lot of guessing, I assume that you ask how to fill listbox headers headers if ColumnHeads property is set to true. If so, it works only when RowSource property of ListBox is a valid address of a range, where the data is stored. The headers are from the row above. An alternative is to...

After Excel 2003 FileSearch was deactivated. Some replacements, incl. subfolders search and FileSearch encapsulated in class module, you can find here (and in parent topic). combo

If it is not a result of macro in Excel addin or other workbook (Excel windows can switch without any user action) or long calculations, it can be a result of keyboard shortcut clicked by accident (CTRL+TAB for instance, full list here) or redefined shortcuts. combo

'Classic' calculated fields in PT can be only in 'values' area. It may be the same case when PT uses data model. Values still can be filtered here, select any field in the column and use PT global filter button to filter values. BTW, the calculated rates seem to use values that are not...

It seems that the system date was not changed. The function above returns empty string even if none of conditions is satisfied, change: MsgBox strMsg to: If Len(strMsg) Then MsgBox strMsg For testing I used a call with custom date, it is safer and taster than playing with system dates (with...

Well, occasionally it happens: thread222-1795724 or thread222-1826154 combo

Me.TreeView1.nodes.SelectedNodeSelectedItem = Me.TreeView1.nodes(0) 'whichever index combo

It's not clear for me, where you store the images: in external folder or as attachment? If in folder, you need a full path stored, if using image control, set PictureType to 1 (linked picture) and Picture to stored path. If in attachment - only short file name is stored in table, you have...

From the description here, Office is a web based set of applications with limited, but not so basic set of features. It seems to be MS' answer to Google Docs. combo