It's just an Excel feature, hidden rows have still data and can be referenced in other cells.
It seems that Excel copies visible cells. There are possibilities (copy & paste in filtered range):
single cell copied, single cell selected to paste: trivial,
single cell copied, range selected...
Thanks, it seems that there is a total mess here. I tested some types, my observations:
Access will not save query with not recognized field type,
a direct answer to my post: simple BIGINT and DATETIME2 work!
TINYINT is not recognized, BYTE works,
TEXT and LONGTEXT create text and long text...
I found a list a list of Access SQL data types from MS here.
However, this article refers to Access 2013. In the meantime Access introduced large number and extended datetime fields handling. Is it possible to generate new types fields with access query, if so - what type names should be used?
With a layout as in the workbook, IMHO the only way is to manually arrange output.
If it is possible to rearrange data, I would use:
column
example/remarks
CustID
C004200
Name
Cusomer #4
SettlementID
#1, #2, ...
Type
Settlement, collection
Amount
use negative in one of types (for...
Actually, Word may repaginate document for different printer, update fields or styles.
NB, read-only document can be changed, next saved, but only with different name.
Another option to close changed document without saving:
wdDoc.Saved = True
wdDoc.Close
If your data is a copy from pivot table report and both Code and Serial are in row area, you can format set pivot table field (in this case code) to repeat labels - no need to fill field with empty entries.
The rest is in subaddress.
Sub test()
Dim wdDoc As Word.Document
Dim oLink As Word.Hyperlink
Set wdDoc = ThisDocument
Set oLink = wdDoc.Hyperlinks(1)
1 Debug.Print oLink.Address & "#" & oLink.SubAddress
2 Debug.Print oLink.TextToDisplay
3 Debug.Print oLink.Name
End Sub
In (1): I guessed the...
...solved, so it's just an idea to complete the task with queries only:
1. create a table [T10] with field [V], values 1 to 10,
2. query:
SELECT
100*[T10_2].[V]+10*[T10_1].[V]+[T10].[V]+1 AS ID, Int(Rnd(2*[ID]-1+Timer())*6)+1 AS Dice1, Int(Rnd(2*[ID]+Timer())*6)+1 AS Dice2
FROM T10, T10 AS...
To make referencing easier i would either pick data from range to variant array (vData=rngData) or reference range cells by indexes:
Dim rngData As Range
Dim iRngRows As Integer, i As Integer
Dim sHTMLBody As String
Set rngData = Worksheets(1).Range("A1").CurrentRegion ' if no other data next to...
@remeng, please describe the required process of transformation of data you have. As far as I understood (?) from all the above you have in Excel:
1) hardware packs table:
2) components table:
There are a lot of questions, how the tables are related, some fields have the same name - which...
In:
"(sAMAccountName=UserLogonName));" & _
you have UserLogonName in string, I guess you need a variable here:
"(sAMAccountName=" & UserLogonName & "));" & _
As Andy wrote, you can attach whole excel file, in your case without some data. In case of one or more worksheets: (1) select required sheets, (2) copy to new workbook, (3) break links, (4) save, (5) attach saved file. Delete remaining confidential data if still necessary, convert formulas to...
I don't know the process you plan to automate, but some time ago I made an Excel application to deal with Word mail merge - export documents to 'pdf' format. Mail merge, for security reasons, is blocked in case of full automation - existing data source is not available (AFAIR it is still...
Depending on the purpose of workbook and necessity of other code - if it is the only reason to introduce VBA, I would use data validation instead, with list as entry type and range consisting of two cells, with 'x' in one of them (hard-coded blank in DV list does not work). With entry and error...
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'):
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.