-
- Trying to use XML Schema to import datas
by Marcos H&&
- 0 Replies
- Last post
by Marcos H&&
- Hello all! well, I've been trying to importing some datas of a XML document based in rules XML schema to an Acess Table. What I found about it was only the code Application. ImportXML _ DataSource:="employees. xml ", _ ImportOptions:=acStructureAndData then I used this Application.ImportXML _ DataSource:="d:\schema\users.xml", _ SchemaSource:="d:\schema\users.xsd
-
- Hiding Access Application Window
by Keithyboy1
- 4 Replies
- Last post
by palaemon
- Hi Everyone!
Apologies in advance for the long thread!
I have an Access database, which I have developed to monitor and track assets issued to employees, and it is intended to be used by others, as opposed to myself. It therefore makes heavy use of forms in order to provide a friendly user interface for non-technical people.
To really polish the application off, I want to be able to compl
-
- Assigning keyboard shortcut to VBA macro programmatically
by Ad Brandt
- 3 Replies
- Last post
by Ad Brandt
- Using OLE, I create an Excel sheet with graphs and some macros to manipulate them. I'd like to assign keyboard shotcuts to the macros, so that the user has easy access to them. I can't figure out - however - how to do that. Any suggestions Thanks in advance.
-
- Browse hard disk with VBA
by gbvdh
- 1 Replies
- Last post
by Andy Pope
- Hello,
I want to read a text file into Excel with VBA. This all works fine with some code I found, the only problem is that the text file I want to open should either be written in the code, or in a textbox but than I have to type the complete location (C:\MyDocuments....) what I would like to have is a browser, similar to the one from Windows on "Ctrl O", which opens when I p
-
- Microsoft Document Image Printer - MODI Registry Settings
by Cheval
- 8 Replies
- Last post
by JoeDee
- Does anyone know what are all the available registry settings for MODI Through much searching in google (msn search finds nothing) I've found the following the following ' Write to File Only (uses current save folder and Note####.mdi as file name) SetKeyValue HKEY_CURRENT_USER, "Software\Microsoft\Office\11.0\MODI\MDI Writer", "PrivateFlags", 1, REG_DWORD ' Don't Show Popup Wi
-
- How to open a folder through excel macro!
by Harish Singh Adhikari
- 5 Replies
- Last post
by Peter Mo.
- Hi,
I am a new learner in Macro field. I want to know how we can open a folder using macro. The scenario is ---> I want to open a folder having a no of files . After that i want to open these files one by one.......
-
- Application-defined or object-defined error
by Joe Marlow
- 3 Replies
- Last post
by Luiz Cláudio - MVP
- Hello All, I'm receiving the error message in subject in the following code: Public Sub Err(ErrorID As Long , _ Optional AddInfo As String = "", _ Optional Source As String = "", _ Optional Log As Boolean = True ) If Log = True Then Me.Log MsgTypeError, ErrorID, AddInfo, Source MsgBox Me.GetErrorDescription(ErrorID), vbCritical + vbOKOnly , "
-
- Subscript out of range
by NutoVBA
- 6 Replies
- Last post
by NutoVBA
- I am new to VBA and am trying to create a copy of a sheet from one workbook to another workbook using the following code:
Workbooks.Open Filename:=bw_path & "\" & bw_file
'Opening the file from which I want to copy.
Sheets(bw_sh).Copy After:=ThisWorkbook.Sheets(3)
'Trying to copy the open worksheet into the workbook housing the macro.
I am getting the "sub
-
- Application.FileSearch in Excel 2007
by DieZeL
- 14 Replies
- Last post
by Jon Peltier
- There is an issue which I am facing after I installed Office 2007. I had written a small VBA which would search for a file and if found will rename the file. I used Application.FileSearch then. Now I am tying to do it again but unfortunately there is an error prompted stating that 'the object does not exist' Set fSearch = Application.FileSearch defPath = "H:\SourceSafe_1_Feb-28_Feb_2006\S
-
- Can you use VBA to access a spread sheet embedded in a word doc?
by Trisped
- 13 Replies
- Last post
by Trisped
- I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
-
- Excel - Resize image to specified target cells' dimensions
by suznal
- 4 Replies
- Last post
by suznal
- I have a command button on a worksheet that calls up the ¡®getsaveasfilename¡¯ dialog, and inserts the selected image file into a merged range of cells. The images are automatically re-sized to fit into the cell (aspect ratio maintained). Everything works well, but I ran into a problem.
There are about 70 sheets in the workbook, and this command button can be found about 250 times throughout the
-
- problem with pivot table Visible property in excel 2003 SP2 vba
by Jari Haaranen
- 2 Replies
- Last post
by Jari Haaranen
- Hi there,
I have problem with pivot table Visible property in excel 2003 SP2 vba."run-time error 1004: Unable to Set Visible Property" VBA code have a Pivot Item property for filtering pivot data. Pivot item is "DeliveryDay". In code i check that Visible value of items (true/false) and if it is False then i like to change it to True. Code using For Each loop for checking Vis
-
- Subscript out of range with a simple sql :-( [newbie to VBA]
by Maximus
- 14 Replies
- Last post
by Andy Pope
- Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers!
Code Snippet
Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
-
- Run-time error '13': Type Mismatch *ignore this ^^!*
by whateveritis
- 2 Replies
- Last post
by whateveritis
- i always get this error when i try to run...does anyone know what's the problem
Code Snippet
Option Explicit
Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "R
-
- Microsoft Office Document Image Writer driver
by pneuma66
- 3 Replies
- Last post
by Joe Indian
- Hi, I'm having the following problem with my installation of Microsoft Office Professional Edition 2003 on my Windows XP Professional operating system. I am trying to send a fax using my internet fax service, so I am in Microsoft Word, and click on File/Send to/Recipient Using Internet Fax Service..." and I get the following error message: "The Microsoft Office Document Image Writer driv
-
- CRM 3.0 Outlook Client - Missing Price List
by keithpsft
- 9 Replies
- Last post
by DavidJennaway
- I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying:
"Your Web browser options are currently set to disable cookies. Mi
-
- Problem: Macro not deleting columns I select
by Donaghy
- 6 Replies
- Last post
by Donaghy
- Hi all,
I have a section of code in my macro which tells it to delete a selection of columns:
Columns("C:F").Select Selection.Delete Shift:=xlToLeft
this is the first bit of code in my macro but isn't working correctly. Instead of deleting columns C to F its deleting columns A to H.
Any ideas why this could be happening
-
- Using VBA in Word to slect and print a particular Record (recipient)
by JBNV123
- 4 Replies
- Last post
by JBNV123
- Hi, I am trying to set up Word so that I can get information from Excel and input this data into a form letter. I am using Mail Merge and that part works great. But now I want to be able to search for a particular record (recipient) and print the document only for that record. I know you can search through the "find" button on the mail merge toolbar but I want to make this more user frie
-
- sending emails from MS Word with variable subject line
by gve2002
- 9 Replies
- Last post
by Andy_F
- Hi,
I've searched these forums but have not been able to find exactly what I need.
I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code ( .Subject = "New subject" )
What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
-
- A question on the ISV/Software Solutions competency customer reference requirements
by DmytroL
- 5 Replies
- Last post
by MS ISV Buddy Team
- Could you please clarify the ISV/Software Solutions competency requirements for customer references The ¡°Competency requirements¡± web page ( https://partner.microsoft.com/40012621 ) reads: ¡°Submit at least three customer references for tested packaged software solutions. The solution must be a business application, deployed for a minimum of five users.¡± I have the following questions related to
-
- Easy msgbox Query
by jaxgev
- 8 Replies
- Last post
by Andy Pope
- Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
-
- Getting word to understand html
by Anders_73
- 0 Replies
- Last post
by Anders_73
- Hi all!,
I have some html content and want word to render it.. I'm using the word.application object, creating a new document and then using selection.typetext "<h1>test123</h1>"..
That doesn't work as I want, it get typed exactly like that. I want word to understand that it should use headersize 1 and type only test123..
How to do that , would be nice wi
-
- Problem with CWnd::RunModalLoop(DWORD dwFlags) in wincore.cpp
by kpcnatraj
- 5 Replies
- Last post
by PaloMisik
- Hello,
We have created a VC++ application that has 2 menu options.
- submenu 1 opens the VBA IDE
- submenu 2 opens a Modal Dialog to execute a functionality (say FUNC1)
Whenever we directly select submenu 2 the application executes properly.
But the application hangs whenever we select submenu 1 (opening the VBA
IDE) and then select submenu 2 (having the VBA IDE still open)
-
- inserting row in excel
by Cammyr
- 2 Replies
- Last post
by Cammyr
- I'm using vb.net express to call excel with this code
Private Sub Button3_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim XL As Excel.Application
Dim xlwb As Excel.Workbook
Dim xlsheet As Excel.Worksheet
XL = New Excel.Application
xlwb = XL.Workbooks.Open( "C:\Documents and Settings\S. Ross\My Docume
-
- How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel?
by Sajagesh
- 8 Replies
- Last post
by Sajagesh
- How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel If the combo boxes are named using the cell reference on which these combo boxes are placed and linked. For example, a combo box, placed over the cell "G23", will be named as G23.