Search:
Type: Posts; User: jdc2000
Search:
Search took 0.02 seconds.
-
Possibly useful link:
https://www.spreadsheetweb.com/how-to-change-csv-delimiter-in-excel/
-
Are you saying that when you pass the mouse pointer over the VBA editor window, it automatically gets the focus without clicking anywhere on it, and then when the mouse cursor reaches the Excel...
-
In that case, you will probably need to re-size the converted Word documents when making them into .pdf files.
Possibly useful links:
...
-
If you have multiple Word documents already created, just combine those first and then just Save As a .pdf file. That would eliminate the need for pdfSharp and solve your formatting issues. I...
-
In the Changed event of the MaskEdBox, capture the data from the control to a variable. Then, you should be able to replace that data in the control on a LostFocus or Exit event for that control.
-
Are you merging text into your Word document, or images?
Does the merged Word document look and print OK?
A better idea might be to merge all of your content into Word, so that you have one...
-
Does the Changed event for the MaskEdBox fire when you right-click and Paste the data? If it does, you should be able to capture the data from that and restore it.
-
Can you save the pasted data as soon as it is entered, and then restore it when focus is lost?
-
Also, from what I have seen, the actual .dll file for VBA may be vbe7.dll
A Google search for "disassemble vbe7.dll" might return some useful links to help in locating where to patch it.
-
Assuming that the VBA .dll file is similar, you would need to locate the correct places to patch it. That might require some additional research.
-
Possibly useful links:
https://www.codeproject.com/Questions/97679/How-to-change-the-color-of-the-title-bar-in-a-vb-n
-
-
There are ways to do this. Possibly useful links:
https://stackoverflow.com/questions/29053272/grid-control-that-can-be-placed-on-userform
http://www.vb-helper.com/howto_vba_editable_grid.html...
-
If ActiveSheet.Name <> "EXPORT" Then
MsgBox "Wrong sheet to Export!", vbOKOnly, "Error"
Exit Sub
End If
-
If an Office application loses focus, it generally ignores the first mouse click or Enter key you use on it.
As a test, add a MsgBox after the Dim statements in that Sub and see what happens on...
-
Unless you are on one of the Windows 10 versions not affected, the link below has some info from Microsoft.
...
-
Possibly useful links, if you have not already seen them:
https://stackoverflow.com/questions/37938748/copy-two-columns-from-one-excel-sheet-to-another
...
-
That depends on several things, including, first of all, what version of Windows you are using.
-
Have you checked to see if you can reach the remote server from the affected computer? It may be a network or account credentials issue.
-
How are you transferring the photos from the phone to your computer? It sounds like something may be stripping the EXIF data as a security measure.
-
Office applications and others (Adobe Reader, etc.) often like to keep connections open in case you want to re-load a document fast. I have seen this issue on numerous occasions.
-
Is this on a Mac?
What happens if you open the workbook, then immediately close it AND close Excel, then re-open Excel and try the same workbook again? Does it open OK?
-
Possibly useful link:
https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/files-fail-to-open
-
Will a simple Search and Replace work for what you need? You would need a list of what you want to replace, or a way to locate that text.
Possibly useful links:
...
-
How to create a Button in Word:
https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/add-button-in-word
Get User Name (assuming that this is the user name you...
-
VBA info links:
https://docs.microsoft.com/en-US/office/troubleshoot/word/autoexec-autoopen-macros-word
https://docs.microsoft.com/en-us/office/vba/word/concepts/customizing-word/auto-macros
...
-
If all you need is to determine whether a consecutive 4 digits is in the name, assuming that you will not have 5 or more consecutive digits, the following link might be useful.
...
-
baka -
Here is the section I saw from your linked document:
Post the code for your function that is not working on Windows 8+.
-
That is not much information to go on. When does the error occur? Is an error from Crystal Reports when it is generating the report? Where is Crystal reports getting the data for the report - from...
-
Lots of extra data, but missing some crucial data in this post.
So, if I am correct in my analysis, you are attempting to read in GPS data through a serial port to your old software but using a...
-
https://www.onmsft.com/how-to/move-screen-keyboard-windows-10-windows-10-mobile#:~:text=When%20the%20keyboard%20appears%20and,up%20and%20down%20the%20screen.
-
Possibly useful link:
http://vbcity.com/forums/t/67392.aspx
-
I am guessing that ssabc is thinking of something like an Excel spreadsheet, sorted on 2 columns.
-
Possibly useful links to get you started:
https://gregmaxey.com/word_tip_pages/using_a_macro_to_replace_text_wherever_it_appears_in_a_document.html
...
-
You could still use Excel to import the .xml data and transfer it, but automate that process using VBScript.
Possibly useful links:
...
-
Excel can import .xml files. It might be easier to do that and use VBA to copy that data to the sheet you want to add it to.
-
This can happen if someone has set the printer they are using to something strange that affects how the margins or other print layout settings are set up.
-
Possibly useful link:
https://stackoverflow.com/questions/1337419/how-do-you-convert-numbers-between-different-bases-in-javascript
-
https://www.pcmag.com/how-to/enable-internet-explorer-mode-windows-11
-
I don't see where you are actually using the jobNum as part of the file name.
Have you checked to see what thisDate actually contains?
Check to see what ActiveDocument.Path & thisDate would be....
|
Click Here to Expand Forum to Full Width
|