Search results for query: *

I am having trouble passing parameters via excel vba to a stored proceudure in MS SQL server 2005. The code is as follows: - Sub Get_RowData(TeamName As String, sheetname As String, rownum As Integer) Dim SQLcmd As String Dim fromDate As String Dim toDate As String Dim strTeam...

I have created a web page that consists of a repeating region from a database. The resulting table gives the details of a server stored document. The columns are: the date the document was stored,the document title, and a final 3rd column. I want this 3rd column to contain an icon of either a...

How do I export data from a sheet in an open workbook to another sheet in a closed wokbook using SQL?

Hi, I'm using VBA to create an approval workflow. Each user has their own (default) Outlook Information store (e.g. "Mailbox - Bloggs, Joe") which is a .pst store. In addition, they all have shared access to an Exchange Server store ("Mailbox - Inspection"). When they click a button, creating...

Hello, I've added some VBA to an Excel workbook to allow it to be automatically sent for approval. I use VBA to create an Outlook message informing the approver that they need to approve the new item. Instead of sending the form as an attachment, I need to send a link to where it is stored...

I'm writing a workload planner for all the departments at my office. Each dept. is represented by a column. As there are several admin staff, each responsible for a different group of depts., I hide the irrelevant columns (depts.) depending on which admin member has opened the file. The problem...

I have written an Expert Finder that displays the pictures of the Experts when you search. I do this by loading the jpeg photo into an Image control on a UserForm e.g. imgExpertPhoto.Picture = LoadPath(strPhotoPath & "joe bloggs.jpg"), where strPhotoPath is the path of the folder containing...

Hi, I have an Excel workbook that contains 3 sheets. Each of these sheets is required. Although I hide the worksheet tabs in the Excel file ('Tools' -> 'Options'), when I save as a Web Page, the tabs are still visible in Internet Explorer. Is there a way to force the worksheet tabs to remain...

I am running a VBA program from Internet Explorer. The application opens in the browser window. I would like the link to automatically open an instance of Excel Application and run the program there - NOT in the browser. Could anyone offer any suggestions? Thanks.

I have an Excel VBA app that works fine when I open it as an Excel file, but gives a "Run-time error 1004: Method 'Range' of object '_Global' failed" error when I hyperlink to it using Internet Explorer 5.5 (it fails when it hits the following line:) Call populateExpertise(cbo...

I am running VBA code from an Excel workbook(wkb1) which then uses the code 'Application.run("'" & WorkbookName & "'!Auto_open") to start running the Auto_open routine in another workbook (wkb2). Within this routine wkb1 is closed. However, on closing wkb1; the code from the currently active...

How do I download and save a file (txt, zip, exe, etc) from an internet site using VBA.

Can anyone suggest a decent book to learn visual basic for MS Access.