Search results for query: *

Yes it is opening an existing workbook. The web query doesnt exist in the workbook, I pass it from access. We use this to download pricing from a website for a market. Each market has roughly 300 unique url's that get priced. So instaed of having 300 existing workbooks, the webquery url is...

hi, I have access code that performs opens excel and runs web queries. Not all the time but randomly I will get this error. Run-time error '1004'; Unable to open http://www.xxxxxxxxxxxxxx The connection to this Internet site took longer than the alloted time. Set dbase = CurrentDb Set objXL...

Doug, One thing to keep in mind about Excel. Even though you change an entire column to the text format, if the cell already has data in it, it will need to activated before it changes to text. Go into a cell that has numbers and hit the F2 key then ENTER to leave the cell, you should see the...

Could you change your formula to not include zeros =IF(SUM(B3-A3)=0,"",SUM(B3-A3)) Randy

This is what I use. Public Sub HTML_Email() Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim FSObj As Scripting.FileSystemObject Dim TStream As Scripting.TextStream Dim rngeSend As Range Dim strHTMLBody As String 'Select the range to be sent Set rngeSend =...

You could just setup a reoccurring appointment in Outlook and it will popup on the screen.

Thank you, worked like a charm.

I have some code that will save the excel attachments from messages in a certain folder to a folder on the network. I need some help in modifying this code only to look at emails with Todays date. The email folder has the same message in it mutiply times. I get a new excel sheet everyday with...

Thanks Zathras, that worked like a charm.

Hi, I have a excel sheet that has 2 columns. column A is a part number and column B has a string of text. there can be numerous entries in column A of one value. Column A Column B 1 1111111 1 2222222 1 3333333 1 4444444 2 1111111 2...

Need some help getting thru my brainlock. I have a form with 2 combo boxes and a tab form with 2 tabs. The combo boxes are used as criteria for 2 unbound subforms. My question is how do I insert the subforms, one on each tab. When I use the subform tool, it acts like I'm putting these on top of...

Once you reset your field to GENERAL, click behind your formula than exit the field and it should change it.

What doesnt make any sense is on each users computer it a attachment that has a specific name. One comes from the A/S 400 as a .csv attachment. (we fixed this one by renaming the .csv file) One comes from a user as a .xls attachment. the receiving user can open other .xls attachments from the...

Just bumping this up. has anybody else experienced this. We have 2 different users with the same problem. One opening and .xls document and one with a .csv document

On a Win2K system, Office 2K When opening email attachment xxx.csv, the file opens correctly with Excel When opening email attachment xxx1.csv, the file opens a System32 folder and does not open excel. These csv files are from our own system. The same file name is emailed twice a day. We...

On a Win2K system, Office 2K When opening attachment xxx.csv, the file opens correctly with Excel When opening attachment xxx1.csv, the file opens a System32 folder and does not open excel. Any ideas of what could be causing this, and how could I fix it.

Skip, I'll give you a star for that. I was always saving the data as a text file, then resaving it back to excel. Thanks

In Outlook 2000, I would do a search for anything with *.pst extension. It will give you the location of the files.

This is what I use. objWKB.SaveAs Filename:="\\QS1047122\TO400\ZERO.csv", FileFormat:=xlCSVMSDOS, CreateBackup:=False

bsagal, It sounds like the format of the cell was TEXT. But just changing the format does not actually change the cell unless you activate the data. Next time try changing the cell format then click at the end of the data in the cell and press the ENTER key. I have this same issue all the time...