I am trying to use an excel spreadsheet with visual Basic macros.  This program came from another site within our company, and as such, it is trying to access a file (which I have) but it is accessing it via the path at the other location.  SO.... the question is, how to type in the file location?  \n\nI am trying the format 99.99.99.999/F://pmdate/pmdata.xls  where the numbers are the IP addess of the server our shared drive is on, F is the name of the drive, pmdata is the folder, and pmdata.xls is the file.  Is this right, or can you suggest another format?
133905
This may be overly symplistic, but if it were me, I'd open up both files at the same time and just link from one file to the other as if I were linking between worksheets.  That way excel creates the full path for you.  You could do that for one cell, then do a search and replace for all of the others.
232162
Assuming cell A1 has the number you want to save as the following code will work:\n\nSub SaveAsName()\n    savename = Range("A1").Value\n    ActiveWorkbook.SaveAs Filename:= _\n        "C:&#92;Documents and Settings&#92;Owner.BLACK&#92;My Documents&#92;" & savename & ".xls"\n        \nEnd Sub\n\nYou will have to change the part of the path within the double quotes to match your SaveAs path
590170
Check this out...\nhttp://desktoppub.about.com/cs/publisher/f/share_pubfiles.htm\nhttp://www.microsoft.com/office/previous/xp/columns/column16.asp\n\nsee if this helps...
242073
If you do not have MS Office, MS Word, or any other software that uses the '.doc' format, you will not be able to view files of that format.  Most likely, this format will not be available in the drop-down box mentioned above, either.\nAlternatively, you should still be able to save the files as a valid .doc file by typing quotations around the full file name in the 'file name' section of the Save screen.\n\nFor example, if you have a document titled 'example' and you want it saved as a .doc file, but have no other option of saving it as such...in the 'file name' box simply type the following:\n"example.doc"\nwith the quotation marks.\n\nIn order to view the file, however, you will have to have the necessary software installed on your system.  The extension has to be assigned to a valid program such as MS Word or WordPad I believe views .doc files, as well - though some of the advanced formatting available in MSWord will be lost when viewed with WordPad.\n\n***RESPONSE TO ADDITIONAL DETAILS***\nDid you try putting the quotation marks around the file name...such as\n"example.doc"\n\nWhen you add the quotations, it will save the file in the format specified regardless of what is in the "save as" box.\n\nAlso, open any folder (such as 'My Documents', for example) and go to Tools - Folder Options.  Click the 'File Types' tab and scroll down the list of file types until you find 'DOC'.  If you find it, down near the bottom where it says 'Opens with...' click 'Change' and browse for the program you prefer.\n\nIf you can't find it, click 'New', and in the top box, type\nDOC\nthen click 'Okay'.  Find DOC in the list, then follow the instructions above to select the appropriate program for it.
446433
If have the same problem importanting my data.\nIn fact there are two problems, one is the separation between data columns, the other is the fact that in American notation for dates and numbers is different from the European one.\n\nIf you open a csv file  OpenOffice shows you a Text Import window.\nFirst you change the Separator options. In my case the Comma field is set, so I change it to semi-colon ; as my data are separated like that, but it might be that space or tab is the correct choice for your data.\n\nNow you have your data in correct columns.\n\nGo to the Fields lower on the pages. Each column is labelled Standard. Right clicking on the word Standard gives you various other options including several ones for the date, as well as the difference between American and European number format.\n\nIf you don't get OpenOffice to understand you, there is no other choice than to change the input file by hand or macro first.\n\nPS If a date does not contain the year, OpenOffice *always* assumes it is the present year. Therefore you have to change the date columns either by including the year explicitly, or in OpenOffice after import.\n\nPS2 I have everything automated with macros. After all it is an exercise one has to repeat often.
465268
This function I've wrote takes the right cell as argument, and, if  that cell is not empty, returns it's value , otherwise the value of the cell above the cell where the function resides: \n\nFunction MyFunction(rightcell As Range)\n   Application.Volatile True\n   MyFunction = IIf (rightcell (1, 1).Value <> "", rightcell (1, 1).Value, rightcell(1, 1).Offset(-1, -1).Value)\nEnd Function\n\nTo make the function available proceed as following:\n-Press Alt+F11- this will bring up the VBA editor\n-navigate to Insert > Module to open a blank module screen\n-paste the above code there\n-close the VBA editor\n\nAs in your example,in  B3 cell, you will call te function like this:\n =MyFunction(C3)
188005
Is not easy, but it is not imposible... I write a lot of macros in excel and i've run in that situation several time. I learned how to crack the VBE password.\n\nIf you search the web, everybody want to sell you a prduct to do that...\n\nif this is just a one time event for you, you can send it to me, i'll crack it and re-send it to you with out the VBE password\n...
377469
Depending on where you are (the main form or the subform) and what you need to access, there are several different ways of doing this.  Check out the forum archives at:\n\nhttp://www.access-programmers.co.uk/forums/archive/index.php/t-77746.html\n\nto see how to do this.  I grabbed the text and saved it on my hard drive so I could get to it later; this cheat sheet really helps!\n\nPS: This is a MS-Access question, not a VB 6 question.  MS-Access uses "VBA" (vb for applications), VB6 has a compiler and it's own form editor.
76343
GETPIVOTDATA does get in the way...\n\nEither type the cell reference directly, or select another cell outside the table then click and drag it into the pivot table to the cell you want to refer to.  No other way round it I'm afraid!
168006
If you dont have any functions in you excel, you want to dump the plain entered data only and using windows XP, use the following trick:\n\nSave all files in text format (tab delimited). You can also try using any tool to convert files in mass. Make a new folder and move all the text files to that folder.\n\nOpen CMD by typing CMD in start>run.\ngo to the folder where you have saved the text files. You can use the CD command to switch between folders.\n\nEx:\nCD myf\nto switch the CMD Line the the folder myf. use:\nCD ..\nto switch to the parent directory.\n\nWhen you have reached the required directory (where u have saved text files), type in the following command:\n\ncopy *.txt full_data.txt\n\nThis will merge all data in all files into full_data.txt\n\nThen open excel and import the full_data.txt file.\n\nThough there is some better way to do,\nI hope this will help you.
224236
Right click on the file, choose Open with... then click Choose Program.  Locate the program that is supposed to open the file on the list that appears, and make sure the box that reads "Always use this program" is checked, then click OK.  \n\nIf you don't know what program is supposed to open the file, you can post a new question with the three letter extension of the file and ask (ie, *.PDF, *.XLS, etc)
56139
Are you running VBscript native (under cscript) on an XP box, or are you writing VBscript in an HTML page, or in another container like Access or Excel???
601092
The easiest way to do this, that would not require very much programming knowledge at all would be to use the 'Publish as Webpage' feature in excel.\n\nYou can set it so that every time the spreadsheet is updated and saved, it also saves a file, readable by internet explorer, into a folder of your choice. This way you can reference the file in the rest of your site or in a frame or whatever.
510438
It's going to be a macro.\nFrom your Excel file, press ALT+F11 to open Visual Basic Editor\nFind "ThisWorkbook" (should be located on the left hand side) and double click on it, a new white frame should open on the rignt hand side. From there, there should be a dropdown list reading "general", change it into "workbook", and paste the code below\n\nPrivate Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)\na = Target.Column\nIf a = 1 Or a = 2 Then\n    Select Case a\n    Case 1\n        Target.Offset(0, 1).Select\n    Case 2\n        Target.Offset(1, -1).Select\n    End Select\nEnd If\nEnd Sub\n\nAs I don't know which columns you are going to use to put your data in , I have chosen A and B (or 1 and 2) if you want to change it  (say D and E or 4 and 5) modify this part of the code like so\nif a=4 or a=5 then\n\nHow does it work?\nEvery time you make changes in your worksheet, like adding data (with your scan gun),  this should call the macro, which in turn first checks if the changes occurred in column A or B and then if it's in A moves one cell to the right and if it's in B moves one cell to the left and one row down.\n\nIf it's not precisely what you want, feel free to send me an email through Y Q/R
475568
I just found this \nhttp://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=305\n\nand this\nhttp://support.microsoft.com/default.aspx?scid=KB;en-us;306214&\n\nIf you already have access to windows on the computer in question, use the second link, if not use the first link\n\nI have not tested either of these methods so i cant verify their safety or accuracy.
172780
This should work:\n\nfind DIRECTORY -mtime +7 | xargs rm\n\nWhere DIRECTORY is the filepath to the directory you want to search, such as home/usr/local\n\nThis looks for files with a maketime of 7 days previous, then runs the standard rm command on all such files.\n\nBe forewarned, there's no undoing this command!
93945
What hurricane is describing is using a string qualifier.\n\nFor example (in this example, replace the . with a tab):\n\n'Text column 1'. '04323221'. 'Hello'\n'Blah blah blah'. '34332321'. 'Paris'\n'Random ol&#92;' text'. '9223221'. 'Green'\n\nNotice that each field begins and ends with a single-quote. The idea is that by qualifying each field with single-quotes, Excel will import the contents as a string.\n\nThat sounds great on paper and should work in theory, but it won't, because anytime Excel sees all digits, it wants a number, even if you use qualifiers.\n\nYou have to manually set up the import in Excel to work properly, if you want those zeros saved.\n\nTo do that:\n\n1. Open Excel\n2. Use File --> Open to open your TSV file\n3. Set the Files of type drop-down to be All Files, navigate to where your TSV is saved, and open it.\n4. In the dialog box, choose Delimeted, skip any rows that need skipping, choose the right encoding and click Next\n5. Make sure Tab is chosen in the delimeters and, if you have opted to use a text qualifier, it is selected.\n6. Click Next\n7. For columns that will contain leading zeros, click on that column, then choose text for the Column data format from the radio buttons at top right.\n8. Click Finish.